Autotrace Taking a Long time [message #65675] |
Tue, 30 November 2004 03:26 |
Shikha
Messages: 36 Registered: January 2002
|
Member |
|
|
On what situation would an execution plan take so long time...
I am using TOAD and also from sqlplus... There was some system operation today (disk space addition). But I don't think any database operation took place... When I am using some simple queries like:
SELECT * FROM ERROR_DUPLICATES;
Which should simply show me a full scan in a fraction of second and which it used to show, is taking amazingly long time...
Why a query to the DBA_LOCKS taking infinitely long time??
What could possibly be wrong...
Note that when I do a simple SELECT * FROM ERROR_DUPLICATES, it goes on showing me the data till I cancel the output.
Thanks,
Shikha
|
|
|
Re: Autotrace Taking a Long time [message #65676 is a reply to message #65675] |
Tue, 30 November 2004 03:55 |
Shikha
Messages: 36 Registered: January 2002
|
Member |
|
|
Aah,
never mind...
There was some database operations taking place
now. No more new users are able to log in. I hope
this is something to do with some backups...
(we do not have direct access to the dba team and
before raising a ticket, wanted to know what could
possibly be wrong)...
Thanks
(though, any quick comments on the same solicited)
|
|
|