Home » SQL & PL/SQL » Client Tools » PL/SQL developer poor performance
PL/SQL developer poor performance [message #274479] Tue, 16 October 2007 03:45 Go to next message
deepayan
Messages: 51
Registered: December 2005
Member
Hi All ,

I m using PL/SQL developer as my development tool. Oracle server is installed in a remote place. The problem is, PL/SQL behaviour is too slow.

Some symptoms are :

It takes long time to open a package.

When I query for some records & I click on a row(for copying that row into excel) , screen goes blank for 50 secs.But when Im using TOAD for this purpose, its not happening like this.

Is there is any setting in PL/SQL developer for which its behaving like so.

Please help.
Any idea for improving PL/SQL developer performance will be greatly appreciated.

Oracle Version : Oracle 9i enterprise edition(9.2.0.6.0)
PL/SQL Developer version : 7.0.3

Thanks
Deepayan
Re: PL/SQL developer poor performance [message #274486 is a reply to message #274479] Tue, 16 October 2007 03:57 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Allround Automation has a forum for PL/SQL-Developer questions. Turnaround time is very good, so you might want to pose your problem there.
Please post any resolutions back here..
Re: PL/SQL developer poor performance [message #274714 is a reply to message #274479] Tue, 16 October 2007 22:45 Go to previous messageGo to next message
deepayan
Messages: 51
Registered: December 2005
Member
Thanks frank.
I got the solution from allround automations forum . we have to uncheck the 'Tools/Preferences/Window Types/SQL Window/Show dictionary info in result grid' option.
It worked nice.
Re: PL/SQL developer poor performance [message #274850 is a reply to message #274714] Wed, 17 October 2007 07:10 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Cool. Thanks for the feedback.
Now, I'm off, unchecking the option Wink
Previous Topic: SQR and Oracle 10g issue
Next Topic: SQL*Plus help
Goto Forum:
  


Current Time: Fri Dec 09 21:37:44 CST 2016

Total time taken to generate the page: 0.04764 seconds