No. i am running it from the foreground... babu ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, April 10, 2002 5:48 PM
> Babu - Are you running this session in the background? On my system (Compaq > Tru64), when I run a SQL*Plus script in the background, I have to put the > EXIT command as the last command of the script. Otherwise the script just > sits there and echos the prompt into the spool file until it fills up the > disk. My system administrator isn't too happy when this occurs, so I try to > be careful. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Wednesday, April 10, 2002 4:38 PM > To: Multiple recipients of list ORACLE-L > > > Thats what I thought. But here is more details on the issue.. > > I am running a SQL*PLus session with a massive query that returns about 2.5g > of data, i am spooling the data to file - that is something similar to what > the essbase application is trying to do. > > that session spooled the data in around 2 hours - so the access paths are > fine. after getting the data though, my sql session has still not completed. > from the size of the spool file i can see the data came more then three > hours ago. this session is still doing something and these waits are > increasnig and sql is not returning the SQL prompt to me... > > trying to find out why... > > babu > > ----- Original Message ----- > To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ; > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Sent: Wednesday, April 10, 2002 2:52 PM > > Looks like you have PQ enabled. > These waits are considered idle. > The PQ slave processes are waiting for work to > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).