Slowdown listing tables after upgrade to 10.2 Oracle

W

wfj

Member
When I try dropping down the table, view or synonym list in the Browser tool, it takes about 60 seconds to populate before displaying. This only occurs on my Oracle 10.2.0.1 databases. The response for 10.1 and earlier versions is instantaneous. Do you have any idea what's going on?
 
It sounds like this does apply. And the poor performance appears to be caused by what is a permanent unilateral change on Oracle's part. As unattractive as this is, perhaps PL/SQLDeveloper needs to be recoded to use other system views to find objects.
 
v6 on 10.2.0.1, takes my "My Objects" and "All Objects" filters no more than 4 seconds to open Tables, Views or Synonyms.

v7 on 10.2.0.1, takes my "My Objects" and "All Objects" filters no more than 5 seconds to open Tables, Views or Synonyms.

Wish I knew why ours is so much faster than yours, but such it is.
 
You must log in or register to reply here.
Back
Top