วันเสาร์ที่ 27 มีนาคม พ.ศ. 2553

Which object is locked ?

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;

How to check opened cursors ?

select substr(a.sid,1,10) sid,
substr(nvl(b.program,machine),1,30) program,
count(*),b.osuser,
sysdate
from v$open_cursor a, v$session b
where a.saddr=b.saddr
group by substr(a.sid,1,10),
substr(nvl(b.program,machine),1,30),b.osuser
order by 3 desc;

How to run Oracle Report by DOS command ?

run this command by HOST();

C:\ORANT\BIN\RWRUN60.EXE USERID=user/pwd@db MODULE=D:\REPORT\RPT01.REP ORACLE_SHUTDOWN=YES PRINTJOB=NO PARAMFORM=NO EXECMODE=BATCH

How to kill (Auto close) "Oracle Report Background Engine"

.
.
.

RUN_PRODUCT(REPORTS,V_RPT_NAME,SYNCHRONOUS,RUNTIME,FILESYSTEM,LIST_ID);
DESTROY_PARAMETER_LIST(LIST_ID);
HOST('taskkill /f /im RWRBE60.EXE', NO_SCREEN);
.
.