Home » SQL & PL/SQL » Client Tools » echo on slow with large stored procedure (10.2.0.3 AIX)
echo on slow with large stored procedure [message #404209] Wed, 20 May 2009 18:09 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 22790
Registered: January 2009
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?
Re: echo on slow with large stored procedure [message #404217 is a reply to message #404209] Wed, 20 May 2009 22:46 Go to previous messageGo to next message
Frank
Messages: 7877
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.
Re: echo on slow with large stored procedure [message #404691 is a reply to message #404209] Fri, 22 May 2009 16:49 Go to previous messageGo to next message
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
Re: echo on slow with large stored procedure [message #404692 is a reply to message #404209] Fri, 22 May 2009 17:07 Go to previous message
BlackSwan
Messages: 22790
Registered: January 2009
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:
  


Current Time: Fri Sep 19 17:26:00 CDT 2014

Total time taken to generate the page: 0.10813 seconds