Home » RDBMS Server » Server Administration » Drop user taking very long (Oracle 9i EE , 9.2.0.6.0, AIX 5.3)
Drop user taking very long [message #399568] Thu, 23 April 2009 00:56 Go to next message
gerop
Messages: 2
Registered: April 2009
Location: South East Asia
Junior Member
Dear All,

I am trying to drop a user with the DROP USER username.
command. It has been 5 hours already and it's still haven't completed.

The user does not own any objects/tables. The session status is active. Any ideas pls why is this taking so long?

Thanks

Rgds,
Re: Drop user taking very long [message #399569 is a reply to message #399568] Thu, 23 April 2009 00:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query v$lock adn v$session_wait to see what happens.
You can also activate a trace on the running session.

Regards
Michel
Re: Drop user taking very long [message #399611 is a reply to message #399569] Thu, 23 April 2009 02:42 Go to previous messageGo to next message
gerop
Messages: 2
Registered: April 2009
Location: South East Asia
Junior Member
I did a trace , this is the last sql it executed

select rowid
from
XDB.XDB$SCHEMA s where s.xmldata.schema_url = :1

it seems to have stopped since then.

and in v$session_wait, there's one row of data for the SID, event is db file sequential read.

What does it mean pls? How can I identify what exactly it is waiting for?

Would it help to bounce the DB?

Thanks

Re: Drop user taking very long [message #399626 is a reply to message #399611] Thu, 23 April 2009 03:19 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to post exactly what you did (to check) and what you have.

Regards
Michel
Previous Topic: How to enable the table level supplemental logging
Next Topic: Moving files in ASM
Goto Forum:
  


Current Time: Sat Dec 10 20:28:49 CST 2016

Total time taken to generate the page: 0.07326 seconds