To find that, I did the following: [oracle@dbserver marius]$ ps aux | sort -nrk 3,3 | head -n 10 oracle 28986 75.8 1.6 10739264 1602896 ? Rs Jan24 137897:06 ora_q002_DBINST oracle 23660 63.1 1.2 10730424 1221500 ? Rs Feb12 97718:28 ora_q003_DBINST oracle 8360 15.7 6.0 10734592 5970484 ? Ss May28 377:34 oracleDBINST (LOCAL=NO) oracle 2264…
SELECT P.SPID, S.SID, S.SERIAL# FROM V$PROCESS P, V$SESSION S WHERE P.ADDR = S.PADDR AND S.SID = 405; col “SID/SERIAL” format a10 col username format a15 col osuser format a15 col program format a40 select s.sid || ‘,’ || s.serial# “SID/SERIAL” , s.username , s.osuser , p.spid “OS PID” , s.program from v$session s , v$process…
set serveroutput on BEGIN dbms_output.enable(1000000); for do_loop in (select session_id, a.object_id, xidsqn, oracle_username, b.owner owner, b.object_name object_name, b.object_type object_type FROM v$locked_object a, dba_objects b WHERE xidsqn != 0 and b.object_id = a.object_id) loop dbms_output.put_line(‘.’); dbms_output.put_line(‘Blocking Session : ‘||do_loop.session_id); dbms_output.put_line(‘Object (Owner/Name): ‘||do_loop.owner||’.’||do_loop.object_name); dbms_output.put_line(‘Object Type :…
