Hello Oracle Sql Developer Team.
The high CPU usage still exists in Sql Developer 4.0.2.15.21 (Java 1.7.0_55) if i use Mac Look And Feel ("LnF"):
Does it happen with everyone using MacBooks? (i tested on another Macbook Pro (non-retina) and the results are the same).
Does anyone knows why isn't this issue solved yet? It seems like it's a very old issue:
https://community.oracle.com/message/10157696#10157696
ps: I HATE Oracle Look and Feel!!!
Sql Developer 4.0.2.15.21 (Build 15.21)
java version "1.7.0_55"
Java(TM) SE Runtime Environment (build 1.7.0_55-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.55-b03, mixed mode)
Active extensions/features:
- Dba Navigator
- Real Time SQL monitoring
- Schema Browser
All other extensions/features are disabled
Code completion insight is completely disabled.
Sql history is set to : 1
MacBook Pro 15 Retina Display Mid 2012
Processor 2,3 GHz Intel Core i7 (quad core)
Memory 8 GB
Graphics NVIDIA GeForce GT 650M 1024 MB
OS X 10.9.2 (13C1021)
I did the following test to compare CPU Usage between Oracle "LnF" versus Mac "LnF"
1 - Open Sql Developer (no connections active)
2 - wait some time doing nothing
3 - Open only one connection to a Oracle 10g database and issue only one simple SQL statement 5 times in a row:
"select v.username,W.EVENT,COUNT(*) from v$session v, v$session_wait w where v.sid = w.sid GROUP BY v.username, W.EVENT ORDER BY W.EVENT;"
4 - wait some time doing nothing
5 - Close the active Worksheet
6 - wait some time doing nothing
7 - Close Sql Developer
I repeated these exact 7 steps above with Mac LNF and Oracle LnF unsing the following command in Mac terminal in order to monitor CPU usage across time:
while true; do ps aux | grep -i oracle.sqldeveloper | grep -v grep | awk '{print SystemDate" "$3 '} SystemDate=$(date "+%Y%d%m:%H:%M:%S"); sleep 3; done
See bellow the results:
The diference between Mac and Oracle Lnf is HUGE. During idle time Mac Lnf uses a LOT of CPU (average of 7%).
Closing the active Worksheet reduces the CPU usage to 2.8% but still absurdly high compared to Oracle LnF of 0.1% CPU usage.
Mac LnF is MUCH more faster than Oracle LnF in regard of usability, User interface, Typing, Grid transversing, etc...
Mac LnF is MUCH better looking than Oracle LnF.
Mac LnF is MUCH has a better integration with Mac OSX than Oracle LnF.
Details of the result:
******** Mac Look and Feel ****************
<sysdate> <CPU usage>
20141905:13:33:51 2,5 (open SQL Developer)
20141905:13:33:54 192,1 (open SQL Developer)
20141905:13:33:57 245,2 (open SQL Developer)
20141905:13:34:00 318,7 (open SQL Developer)
20141905:13:34:03 0,2 (open SQL Developer)
20141905:13:34:06 1,5 (doing nothing)
20141905:13:34:09 0,2 (doing nothing)
20141905:13:34:12 12,5 (doing nothing)
20141905:13:34:15 0,1 (doing nothing)
20141905:13:34:18 0,0 (doing nothing)
20141905:13:34:21 0,1 (doing nothing)
20141905:13:34:24 0,0 (doing nothing)
20141905:13:34:27 0,0 (doing nothing)
20141905:13:34:30 0,1 (doing nothing)
20141905:13:34:33 0,0 (doing nothing)
20141905:13:34:36 0,1 (doing nothing)
20141905:13:34:39 0,0 (doing nothing)
20141905:13:34:42 0,1 (doing nothing)
20141905:13:34:45 0,0 (doing nothing)
20141905:13:34:48 0,0 (doing nothing)
20141905:13:34:51 0,1 (doing nothing)
20141905:13:34:54 0,0 (doing nothing)
20141905:13:34:57 0,0 (doing nothing)
20141905:13:35:01 0,1 (doing nothing)
20141905:13:35:04 0,1 (doing nothing)
20141905:13:35:07 0,1 (doing nothing)
20141905:13:35:10 0,1 (doing nothing)
20141905:13:35:13 0,0 (doing nothing)
20141905:13:35:16 0,1 (doing nothing)
20141905:13:35:19 0,0 (doing nothing)
20141905:13:35:22 0,1 (doing nothing)
20141905:13:35:25 0,0 (doing nothing)
20141905:13:35:28 0,1 (doing nothing)
20141905:13:35:31 0,1 (doing nothing)
20141905:13:35:34 1,3 (doing nothing)
20141905:13:35:37 0,5 (doing nothing)
20141905:13:35:40 35,4 (issue SQL Statement 5 times)
20141905:13:35:43 73,9 (issue SQL Statement 5 times)
20141905:13:35:46 9,8 (issue SQL Statement 5 times)
20141905:13:35:49 110,2 (issue SQL Statement 5 times)
20141905:13:35:52 66,2 (issue SQL Statement 5 times)
20141905:13:35:55 12,8 (issue SQL Statement 5 times)
20141905:13:35:58 8,9 (doing nothing)
20141905:13:36:01 7,5 (doing nothing)
20141905:13:36:04 8,5 (doing nothing)
20141905:13:36:07 11,6 (doing nothing)
20141905:13:36:10 39,9 (doing nothing)
20141905:13:36:13 6,4 (doing nothing)
20141905:13:36:16 7,4 (doing nothing)
20141905:13:36:19 7,1 (doing nothing)
20141905:13:36:22 7,1 (doing nothing)
20141905:13:36:25 7,0 (doing nothing)
20141905:13:36:29 7,3 (doing nothing)
20141905:13:36:32 9,6 (doing nothing)
20141905:13:36:35 13,0 (doing nothing)
20141905:13:36:38 6,6 (doing nothing)
20141905:13:36:41 6,4 (doing nothing)
20141905:13:36:44 7,3 (doing nothing)
20141905:13:36:47 6,3 (doing nothing)
20141905:13:36:50 6,2 (doing nothing)
20141905:13:36:53 27,7 (Close the active Worksheet)
20141905:13:36:56 4,7 (doing nothing)
20141905:13:36:59 2,6 (doing nothing)
20141905:13:37:02 2,8 (doing nothing)
20141905:13:37:05 2,8 (doing nothing)
20141905:13:37:08 2,2 (doing nothing)
20141905:13:37:11 2,8 (doing nothing)
20141905:13:37:14 2,8 (doing nothing)
20141905:13:37:17 2,1 (doing nothing)
20141905:13:37:20 2,5 (doing nothing)
20141905:13:37:23 9,1 (close sqldeveloper)
20141905:13:37:26 18,8 (close sqldeveloper)
*********** Oracle Look and Feel: ****************
<sysdate> <CPU usage>
20141905:13:49:30 234,4 (open SQL Developer)
20141905:13:49:33 192,7 (open SQL Developer)
20141905:13:49:36 387,4 (open SQL Developer)
20141905:13:49:39 15,6 (open SQL Developer)
20141905:13:49:42 1,2 (doing nothing)
20141905:13:49:45 1,2 (doing nothing)
20141905:13:49:48 0,6 (doing nothing)
20141905:13:49:52 0,1 (doing nothing)
20141905:13:49:55 0,1 (doing nothing)
20141905:13:49:58 0,1 (doing nothing)
20141905:13:50:01 0,0 (doing nothing)
20141905:13:50:04 0,1 (doing nothing)
20141905:13:50:07 0,1 (doing nothing)
20141905:13:50:10 0,0 (doing nothing)
20141905:13:50:13 0,1 (doing nothing)
20141905:13:50:16 0,1 (doing nothing)
20141905:13:50:19 0,1 (doing nothing)
20141905:13:50:22 0,1 (doing nothing)
20141905:13:50:25 0,1 (doing nothing)
20141905:13:50:28 0,1 (doing nothing)
20141905:13:50:31 43,3 (issue SQL Statement 5 times)
20141905:13:50:34 11,3 (issue SQL Statement 5 times)
20141905:13:50:37 53,6 (issue SQL Statement 5 times)
20141905:13:50:40 22,8 (issue SQL Statement 5 times)
20141905:13:50:43 8,4 (issue SQL Statement 5 times)
20141905:13:50:46 12,5 (issue SQL Statement 5 times)
20141905:13:50:49 37,5 (issue SQL Statement 5 times)
20141905:13:50:52 4,2 (doing nothing)
20141905:13:50:55 3,8 (doing nothing)
20141905:13:50:58 5,3 (doing nothing)
20141905:13:51:01 4,4 (doing nothing)
20141905:13:51:04 4,5 (doing nothing)
20141905:13:51:07 4,2 (doing nothing)
20141905:13:51:10 3,8 (doing nothing)
20141905:13:51:13 3,8 (doing nothing)
20141905:13:51:16 3,9 (doing nothing)
20141905:13:51:19 6,8 (doing nothing)
20141905:13:51:23 4,1 (doing nothing)
20141905:13:51:26 6,5 (doing nothing)
20141905:13:51:29 4,7 (doing nothing)
20141905:13:51:32 3,8 (doing nothing)
20141905:13:51:35 4,0 (doing nothing)
20141905:13:51:38 4,1 (doing nothing)
20141905:13:51:41 4,2 (doing nothing)
20141905:13:51:44 4,2 (doing nothing)
20141905:13:51:47 4,3 (doing nothing)
20141905:13:51:50 4,1 (doing nothing)
20141905:13:51:53 4,3 (doing nothing)
20141905:13:51:56 6,0 (doing nothing)
20141905:13:51:59 164,2 (Close the active Worksheet)
20141905:13:52:02 0,2 (doing nothing)
20141905:13:52:05 0,1 (doing nothing)
20141905:13:52:08 0,2 (doing nothing)
20141905:13:52:11 0,2 (doing nothing)
20141905:13:52:14 0,3 (doing nothing)
20141905:13:52:17 0,2 (doing nothing)
20141905:13:52:20 0,2 (doing nothing)
20141905:13:52:23 0,1 (doing nothing)
20141905:13:52:26 0,2 (doing nothing)
20141905:13:52:29 0,2 (doing nothing)
20141905:13:52:32 0,2 (doing nothing)
20141905:13:52:35 0,1 (doing nothing)
20141905:13:52:38 0,2 (doing nothing)
20141905:13:52:41 0,3 (doing nothing)
20141905:13:52:44 0,2 (doing nothing)
20141905:13:52:47 0,2 (doing nothing)
20141905:13:52:51 0,2 (doing nothing)
20141905:13:52:54 0,2 (doing nothing)
20141905:13:52:57 3,8 (close sqldeveloper)