Why is my Oracle Database Slow? The SQL Developer Performance Dashboard

Oracle SQL Developer's product manager, Jeff Smith, takes you through the Instance Viewer: a performance dashboard for your Oracle Database. See expensive queries, wait event break downs, and more!

[@JeffSmiththat]

Sorry about the audio in the first minute or 2, not sure what was going on with my mic...

[@juno7893]

👏🏻👏🏻👏🏻

[@navinkale6129]

Why are few complex queries take too much time on SQL developer where as they work comparatively quite fast in Toad . Do we need to tune SQL developer IDE ? If yes what are the settings

[@JeffSmiththat]

first things first - are they actually the same queries? if the optimizer is picking a different plan to use to run the query, the amount of work being done isn't the same. So step 1, check your planID. remember, the DB runs the queries, not the clients. The clients fetch the data back (in groups of say 50 - 250 rows at a time) and print them to the screen. So we need to know exactly what we're measuring.

[@giahuytran7957]

My Sql developer now can't run any query. It's not show any fail, just run it forever. Can you tell me what wrong with that? Pls

[@JeffSmiththat]

It sounds like something is wrong with the program. Does the rest of sqldev work, can you open a table for example?