Home » RDBMS Server » Performance Tuning » Autotrace Taking a Long time
Autotrace Taking a Long time [message #65675] Tue, 30 November 2004 03:26 Go to next message
Messages: 36
Registered: January 2002
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:


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.



Re: Autotrace Taking a Long time [message #65676 is a reply to message #65675] Tue, 30 November 2004 03:55 Go to previous message
Messages: 36
Registered: January 2002
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)...

(though, any quick comments on the same solicited)
Previous Topic: Using Index
Next Topic: Performance
Goto Forum:

Current Time: Thu Feb 29 22:00:38 CST 2024