very long to open the table liste of a shema

[gma]

Hello,

I'm trying PL/SQL Developer and i have a problem. It's very long to open a shema of 1400 tables. After ten minutes I should kill the process.

With other SQL Tools, I have no difficulty, it take less than 1 minute.

Why?

Oracle 8.1.6.4
Windows NT4

Thank you.

PS : Sorry for my bad English.

 

[Marco Kalter]

Can you go to Tools > Browser Filters and check the where clause and order by clause of your default filter? Can you also let me know if your default filter is "All objects" or "My objects"?

 

[Kirurgs]

Querying oracle dictiorary with CBO enbled can cause such a performance degradation, the best way to query certain dictiorary tables is enabling RULE hint which then invokes RBO, result should show up a lot faster...
It can be applied to various dictionary queries, so check it out, it should help...

 

[gma]

Thank you for yours responds.

My default filter was "All objects", when I set "My objects", The responds time is good.

regards
Guillaume