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;
วันเสาร์ที่ 27 มีนาคม พ.ศ. 2553
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;
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
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);
.
.
.
.
RUN_PRODUCT(REPORTS,V_RPT_NAME,SYNCHRONOUS,RUNTIME,FILESYSTEM,LIST_ID);
DESTROY_PARAMETER_LIST(LIST_ID);
HOST('taskkill /f /im RWRBE60.EXE', NO_SCREEN);
.
.
สมัครสมาชิก:
ความคิดเห็น (Atom)
