How to find/kill the locked objects in an oracle database
The below query can be used for determining the if any object locked in an oracle database. select  c.owner, c.object_name, c.object_type, b.sid, b....
How to Find Maximum Open Cursors and Current Cursor Count in Oracle Database
Learn how to monitor and manage Oracle database cursors with SQL queries. Find out maximum allowed cursors and track currently open cursors to prevent ORA-01...