Parsing views during database object search

Good day.

Currently I am testing PL/SQL Developer in trial mode on large production database. While using database object search mode I have noticed severe Oracle perfomance issues; a little investigation using session trace revealed that PL/SQL Developer parses the queries in ALL views where it performs the search, which has great impact on shared pool.
Is there any way to disable this operation? And by the way, why perform it at all? In the end, all we need from search tool is to find some text, not to control its syntax or something...

Thanks in advance.
 
This is currently not possible. To obtain the view DDL, it currently needs to be parsed to get the alias list. It is on the list of enhancement requests to get more control over this though.
 
Back
Top