Month: March 2008
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.serial#, b.status, b.osuser, b.machine from v$locked_object a , v$session b, dba_objects c where b.sid = a.session_id and a.object_id = c.object_id; And if you need to kill any session you can…
How to find out maximum open cursors and no of cursors open in Oracle
The maximum number of open cursors in an oracle database can be determined by the following query select name, value from v$parameter where name like ‘open-cursors’ the value for open_cursors parameter refers to maximum number of open cursors allowed. The below query can be used to determine number of open cursors for the current session.…