Oracle - 과도한 메모리 사용 검색

Select
D.sid "SID" ,
--s.serial# "Serial#",
D.username "Oracle User",
D.program "Program",

D.module "Module",
D.status "Status",
D.type "Type",
D.server "Connection",
to_char(D.logon_time,'YYYY-MM-DD HH24:MI:SS') "Logon Time",
D.osuser "OS User" ,
decode(D.lockwait,null,'','Blocking') "Lock",
decode(D.taddr,null,'','TX') "Transaction",
SYSDATE - (D.last_call_et/86400) "Last Call",
A.User_Name,
D.machine "Machine",
B.Disk_Reads,
B.Buffer_Gets,
B.Rows_Processed,
C.SQL_Text,
A.Address
From V$Open_Cursor A,
V$SQLArea B,
V$SQLText C,
sys.v_$session D
Where A.User_Name = Upper('IEPCS')
AND B.ADDRESS = D.SQL_ADDRESS
AND B.HASH_VALUE = D.SQL_HASH_VALUE
And A.Address = C.Address

댓글 없음:

댓글 쓰기