Lightbringer
Member
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.
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.