| Drop user taking very long [message #399568] |
Thu, 23 April 2009 00:56  |
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 #399611 is a reply to message #399569] |
Thu, 23 April 2009 02:42  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
