Re: oracle spool to a flat file slow

yogi wrote:
> 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.

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_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org