OraFAQ Forum: Client Tools » PL/SQL developer poor performance

Home » Other » Client Tools » PL/SQL developer poor performance

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PL/SQL developer poor performance [message #274479]

Tue, 16 October 2007 03:45

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

Report message to a moderator

Re: PL/SQL developer poor performance [message #274486 is a reply to message #274479]

Tue, 16 October 2007 03:57

Frank
Messages: 7901
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..

Report message to a moderator

Re: PL/SQL developer poor performance [message #274714 is a reply to message #274479]

Tue, 16 October 2007 22:45

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.

Report message to a moderator

Re: PL/SQL developer poor performance [message #274850 is a reply to message #274714]

Wed, 17 October 2007 07:10

Frank
Messages: 7901
Registered: March 2000

Senior Member

Cool. Thanks for the feedback.
Now, I'm off, unchecking the option Wink

Report message to a moderator

Previous Topic:	SQR and Oracle 10g issue
Next Topic:	SQL*Plus help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 09:22:22 CST 2025