SQL Performance (MOSC)

MOSC Banner

Query data dictionary is to slow

Hello,

When I try to edit a table in SQL Developer (right clic over the table in the left pane), the interface is to slow to show the result. I use the Statements - Log and get a big elapsed time. See picture attached.

I copy the SQL returned in the statements and run it in a SQL worksheet and notice that the sub-query that return the information from the SYS.DBA_COL_COMMENTS are the problem.

I run the SQL whitout the sub-query and the result was successfully.

I adjust newly the SQL and add the SYS.DBA_COL_COMMENTS table in the FROM with a LEFT JOIN and the result was successfully again.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center