delete

Show structure of ref cursor

declare l_rcursor sys_refcursor; l_colCnt number; l_descTbl dbms_sql.desc_tab; begin open l_rcursor for select * from all_users; dbms_sql.describe_columns ( c       => dbms_sql.to_cursor_number(l_rcursor), col_cnt => l_colCnt, desc_t  => l_descTbl ); for i in 1 .. l_colCnt loop dbms_output.put_line( l_descTbl(i).col_name ); end loop; end;
delete

Show locked objects with user who caused...

Shows all objects even source code. select  OS_USER_NAME os_user, lo.PROCESS os_pid, ORACLE_USERNAME oracle_user, l.SID oracle_id, s.MACHINE, s.TERMINAL, decode(l.TYPE, 'MR', 'Media Recovery', 'RT', 'Redo Thread', 'UN', 'User Name', 'TX', 'Transaction', 'TM', 'DML', 'UL', 'PL/SQL User Lock', 'DX', 'Distributed Xaction', 'CF', 'Control File', 'IS', 'Instance State', 'FS', 'File Set', 'IR', 'Instance Recovery', 'ST', 'Disk Space Transaction', 'TS', 'Temp Segment', 'IV', 'Library Cache Invalidation', 'LS', 'Log Start or Switch', 'RW', 'Row Wait', 'SQ', 'Sequence Number',...
delete

Show exclusive locks on package / functi...

If you cannot compile and save updated source code of package / function etc. you need to find who is blocking it: select distinct s.sid, s.username, l.name object_name, l.mode_held from dba_ddl_locks l, v$session s where l.session_id = s.sid and l.mode_held != 'Null' and l.name = '...your_package_name....'