Hi All,

I am working on oracle 9i on unix server .we are running a chain of
various shell scripts which in turn calls pl/sql procedures and takes
dump of oralce tables into flat files on unix server.

database and unix server on which shell scripts are running are on
diffrent unix machines.when i directly take the spool of the table (on
the server on which shell scripts are running), for dumping 80,000 rows
it takes 30-40 secs.But same spool when we running through shell script
takes 7 mins on the same server.

so my problem is i can't even simulate that situation while working on
for tuning this spool.

The code i am using is simple.I am putting the query into a file and
then connecting to database from unix and taking spool.

i was suggested to puse the parameter 'set fflush on ' but i could not
see any diffrence.

Please suggest me what may be the possible reasons or is it some dba
settings which is required to be set.

thanks a lot in advance.

yogi wrote:

And with no version information.
No operating system or platform information.
No code.
You want someone to gaze into their crystal ball and tell you the answer.
Ok.
The answer is 42.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org