Find DB Objects

[cdtucker]

I find the performance of this utility a real problem. If I look for a given string in Package Bodies it takes a very very long time (can take more than an hours to return results). If I select directly from ALL_SOURCE it takes only seconds. What is PL/SQL Developer doing that it takes so long? Are there tricks to make this utility perform faster?

Thanks.

 

[Marco Kalter]

If you have enabled the "Use DBA views if available" preference (Tools > Preferences > Options tab page), then the DBA_SOURCE view will be used (if available), which may be slower.

Furthermore it may be that you have enabled other object types (e.g. tables) for which the definition cannot be queried from the DBA/ALL_SOURCE view. This can also take longer if you have many tables.

In short, the dictionary performance, the selected object types, and the number of objects will determine the search performance.

------------------
Marco Kalter
Allround Automations

 

[CTucker]

I tried this feature again with version 5.1.1. If I do a simple find with only Package specifications selected and I don't use regular expressions it can find all occurances of a string in about 30 seconds. However if I repeat the seach, this time I also include Package bodies, the find runs fairly quickly to about 99% (according to the status bar) but then sits on the last 1% as if it is hung. I killed the session and the application after about 20 minutes. Note that pressing the break button had no effect. I'm pretty sure that something not working as it should. Can you please verify.

Thanks,

[This message has been edited by CTucker (edited 09 April 2003).]

 

[Marco Kalter]

So you have just selected package specs and bodies? I can't immediately reproduce this, but we'll look into this.

------------------
Marco Kalter
Allround Automations