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

babu
----- Original Message -----
To: "Multiple recipients of list ORACLE-L"
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;
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).

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 5 of 8 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedApr 10, '02 at 5:51p
activeApr 12, '02 at 9:09a
posts8
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase