I'm unable to rebuild index on a particular table because I receive an error:
ORA-00054:resource busy and acquire with NOWAIT specified
My question is how can I find out who is using this table so I can kill the session?
Printable View
I'm unable to rebuild index on a particular table because I receive an error:
ORA-00054:resource busy and acquire with NOWAIT specified
My question is how can I find out who is using this table so I can kill the session?
see the v$access table
There is no need to kill a session for rebuilding the index ..
Use the cool new feature
alter index indexname rebuild online ;