Daily Archives: May 4, 2014

Find out which objects are locked using the following query:   select   substr(a.os_user_name,1,15) "OS User",   substr(a.oracle_username,1,8) "DB User",   substr(b.owner,1,8) "Schema",   substr(b.object_name,1,20) "Object Name",   substr(b.object_type,1,10) "Type",   substr(c.segment_name,1,15) "RBS",   substr(d.used_urec,1,12) "# of Records",  …

You can find the number of uncommited transactions using the following query:SELECT ROWS_PROCESSED,sql_textFROM v$sqlareaWHERE (address, hash_value) IN(SELECT sql_address, sql_hash_valueFROM v$sessionWHERE sid in (select sid from v$session where schemaname='VAG'))or using v$transaction…