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
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 Go to previous message
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)
Previous Topic: Using Index
Next Topic: Performance
Goto Forum:
  


Current Time: Sun Jan 17 13:08:10 CST 2021