Oracle SQL Developer Tips and Tricks Series, Episode 1

Oracle Product Manager Jeff Smith shows you how to navigate and work with your PLSQL code with fewer clicks and much more efficiency.

[Vaibik]

Thanks for the tips Jeff Smith. Do you have any video (or any that you know of) for using debugger in the SQL Developer?

[JeffSmiththat]

Once Java requests memory for the OS, it doesn't give it back. While Windows Task Manager will show SQL Developer 'using' 700MB, it's not REALLY using that much. That's how much it's requested over time. What it's REALLY using can be seen in a Java Profiler. What we need to worry about is why it's slow and hanging. Can you try these tips and let me know if it helps? + Disable unused extensions + Set Look and Feel to 'Windows' + Close Grids when you're done reviewing data + Use v3.2 with 1.6JDK

[davidespada]

i like Oracle SQL Developer but its problem is memory ! its really memory eater, when its 1st start "no woorksheet open or any thing" it takes 140 MB vs toad or PL\SQL Developer about 64MB, the big problem after extensive use sqlDeveloper takes in my PC 700MB wow... i wish if it was better "after 700MB its bad to work on why? very slow also HANGS and simply closes with a tear in my eyes" some say its the Java GC issue, i dont really know... but if this problem fixed i wont use any other apps

[davidespada]

i see..
//Disable unused extensions : it helped also faster application start :)
//Set Look and Feel to 'Windows' :i will try it
//Close Grids when you're done reviewing data : ya its logical true it will help
//Use v3.2 with 1.6JDK: i downloaded the latest version with the JDK inside the package "that what oracle say" so i thought it will use the internal JDK.. my PC has a 1.7 java not 1.6 and i know that there is a problem with 1.7 "GC" but as i said i thought it will use the internal JDK,

[MrPAKISTANI]

NOT MUCH CLEAR....POOR VIDEO QUALITY...