Re: PX Deq: Table Q qref

No. i am running it from the foreground...

babu
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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.
> dwilliams_at_lifetouch.com
>
> -----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: ORACLE-L_at_fatcity.com <mailto:ORACLE-L_at_fatcity.com> ;
> orclbabu_at_hotmail.com <mailto:orclbabu_at_hotmail.com>
> 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: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: ListGuru_at_fatcity.com (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: orclbabu_at_hotmail.com

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: ListGuru_at_fatcity.com (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).