I got “ORA-30013: undo tablespace ‘UNDOTBS’ is currently in use ” error in Oracle database.
Read More »Tag Archives: ALTER SYSTEM KILL SESSION
ORA-00031: session marked for kill
I got ” ORA-00031: session marked for kill ” error in Oracle database.
Read More »enq: SS – contention Wait Event in Oracle Database
Hi, I will explain enq: SS – contention Wait Event in this article.
Read More »Alter System Kill Session Tips in Oracle
I will explain Alter System Kill Session Tips in Oracle in this post. Sometimes application developers or client offers you to kill any session or sessions group like SQL Net …
Read More »Session Killer Procedure for Developers in Oracle Database
Hi, I will share with you Session Killer Procedure for Developers in Oracle Database in this post.
Read More »ORA-01940: cannot drop a user that is currently connected
You can get “ORA-01940: cannot drop a user that is currently connected” error during the drop any user.
Read More »ORA-016340: cannot drop a user that is currently connected
Hi, You can get ” ORA-016340: cannot drop a user that is currently connected ” error during the drop any user.
Read More »ORA-04021: timeout occurred while waiting to lock object during truncate table or alter table
Hi, Sometimes you can get ” ORA-04021: timeout occurred while waiting to lock object ” during truncate table or alter table.
Read More »How to Drop and Recreate Temp Tablespace in Oracle Database
Hi, I will explain How to Drop and Recreate Temp Tablespace in Oracle Database in this article.
Read More »