OraFAQ Forum: Client Tools » echo on slow with large stored procedure

Home » Other » Client Tools » echo on slow with large stored procedure (10.2.0.3 AIX)

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

echo on slow with large stored procedure [message #404209]

Wed, 20 May 2009 18:09

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

I run sqlplus(10.2.0.3) on AIX 5L via ssh remote terminal(putty).

creating larger stored procedure(with SET ECHO ON) is extremely slow.
Is it possible to increase speed with any AIX or oracle parameters?
ECHO ON is necessary to me.

Thanks,
Zoltanp

[Updated on: Wed, 20 May 2009 18:10]

Report message to a moderator

Re: echo on slow with large stored procedure [message #404210 is a reply to message #404209]

Wed, 20 May 2009 18:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>creating larger stored procedure(with SET ECHO ON) is extremely slow.
Please quantify.
How many lines in SP?
How long in seconds is extremely slow?

Report message to a moderator

Re: echo on slow with large stored procedure [message #404217 is a reply to message #404209]

Wed, 20 May 2009 22:46

Frank
Messages: 7901
Registered: March 2000

Senior Member

How long does it to create the procedure vs the time it takes to do a cat of the file?
In other words, is it the time to write back the output to your ssh session?
If so, you could spool and set termout off. Then the echo'ed response will not be displayed on your terminal screen, but instead be spooled to a file.

Report message to a moderator

Re: echo on slow with large stored procedure [message #404691 is a reply to message #404209]

Fri, 22 May 2009 16:49

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

~8000 line with ECHO ON 10 minutes, while with ECHO off it is 1 minute.

I create spool and write to the terminal also.
cat is a few seconds.

Regards,
Zoltanp

Report message to a moderator

Re: echo on slow with large stored procedure [message #404692 is a reply to message #404209]

Fri, 22 May 2009 17:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

8000 lines    1 minute
---------- * ---------  = 13.3 lines/second
10 minutes   60 seconds

From where I sit, what you see appears reasonable.
You are bandwidth limited & I doubt you'll be able to change reality.

[Updated on: Fri, 22 May 2009 17:08]

Report message to a moderator

Previous Topic:	How to save contents?
Next Topic:	MERGE Statement... TIME OUT error... hanged (merge 6)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 02:30:36 CST 2025