Enhancement Request - execute script on Primary Connection prior to querying catalog

[Dylan_K]

Full details to justify this request can be found here:

Detailed proof of concept for improving PLSQL Developer connect time

More recent versions of Oracle database take an extraordinary amount of time just to select zero rows from dba_ views. Many of us need to use the option "Use DBA Views if available" to see all objects in the PL/SQL Developer object browser. However, with the default session options, it can take over a minute for PL/SQL Developer to complete its connection step because of the slowness of the dba_ views.

This request is to allow for a .sql file to be executed on what ultimately becomes the Primary Connection for PL/SQL Developer prior to any of the "select * from sys.dba_xxxxxx where rownum < 1" queries. The idea is that by executing the requested .sql file, we can set whatever session parameters aid response time of the dba_ views in our database environments.

Thanks for your consideration. I really hope you will choose to implement this soon as it would save a bunch of us a whole lot of time!

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[D.Wenzel]

my 2cent

i think a

where 1=2

is the better Solution .. as "Short Circuit Evaluation"

Yours D.

 

[Dylan_K]

I have tried both for querying the catalog. It doesn't short circuit in either case. The only way I have found to make catalog queries fast is to force RULE based optimization.