www.1q.co.kr(park1q.com)

ID :  Password : Auto  

   ȸ¿ø:0¸í / ¼Õ´Ô:0¸í
 

 

Technote

ÀÚ·á ¹× °ü¸®ÆÁ

  • DBA Notes
  • Q & A

    ºÏ¸¶Å©
  • Asktom
       (Oracle ÀÇ ´ëÇ¥ Forum)
  • Technical Bulltin(KR)
       (±â¼úÁö¿ø°Ô½ÃÆÇ)
  • Dbazine

  •  

     


     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


      ÃßõÇϱâ ÇÁ¸°Æ®   ¸ñ·Ïº¸±â

    Copyright 1999-2025 Zeroboard

     

     
     
    [Today:4 / Total:172121]    Design by p@rk1q