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
|
- PX Deq: Table Q qref Babu Nagarajan
- RE: PX Deq: Table Q qref Deshpande, Kirti
- RE: PX Deq: Table Q qref Babu Nagarajan
- RE: PX Deq: Table Q qref DENNIS WILLIAMS
- Re: PX Deq: Table Q qref Babu Nagarajan
- Re: PX Deq: Table Q qref Jonathan Lewis
- Re: PX Deq: Table Q qref Babu Nagarajan
- Re: PX Deq: Table Q qref Jonathan Lewis