
|
 |

|

 |
 transaction monitoring
|
park1q
|
2017-05-20 11:01:41, Á¶È¸ : 4,005, Ãßõ : 1039 |

SELECT /*+ ordered no_merge(r) use_hash(t r s p) */ s.username, -- 0 s.sid, -- 1 s.serial#, -- 2 p.spid, -- 3 s.machine, -- 4 t.status, -- 5 t.recursive, -- 6 r.name, -- 7 s.module, -- 8 s.program, -- 9 trunc((sysdate - to_date(t.start_time, 'MM/DD/YY HH24:MI:SS')) * 86400) duration, -- 10 t.used_ublk, -- 11 t.used_urec, -- 12 t.log_io, -- 13 t.phy_io -- 14 FROM v$transaction t, v$rollname r, v$session s, v$process p WHERE s.saddr = t.ses_addr and t.xidusn = r.usn and s.paddr = p.addr ORDER BY 1 ASC
################# À妽º°¡ ¾ø´Â »óȲ¿¡¼ INSERT ¼öÇà
insert into t001 select * from NOLOGGING_T;
CPU used by this session 426 physical reads 5634 physical writes 0 rollback changes - undo records applied 58 rollbacks only - consistent read gets 57 session logical reads 70092 sorts (disk) 0 sorts (memory) 60 sorts (rows) 5 table fetch by rowid 125 table scan blocks gotten 5632 table scan rows gotten 946162 table scans (long tables) 1 table scans (short tables) 0 undo change vector size 2547468 undo segment header was pinned 0
Used block : 300
################# À妽º »ý¼ºÈÄ¿¡ INSERT ½Ç½Ã CREATE INDEX T001_IX01 ON t001 (EMPNO, ENAME, JOB, MGR) ; insert into t001 select * from NOLOGGING_T;
CPU used by this session 3609 physical reads 6039 physical writes 0 rollback changes - undo records applied 140 rollbacks only - consistent read gets 60 session logical reads 2920429 sorts (disk) 0 sorts (memory) 74 sorts (rows) 0 table fetch by rowid 288 table scan blocks gotten 5632 table scan rows gotten 946162 table scans (long tables) 1 table scans (short tables) 0 undo change vector size 145144748 undo segment header was pinned 0
Used block : 12084 |
|
|
 |
|
|
|
|