[Ora12c] Row Migration과 Row Chaining 조회

/*
-- Title : [Ora12c] Row Migration과 Row Chaining 조회
-- Tag : oracle 오라클 행 마이그레이션 행 체인화
*/

---

■ Row Migration 조회

select to_char(sysdate,'yyyy-mm-dd hh24:ss:ss') day, a.sid, vss.username, a.name, a.value, vss.schemaname, vss.prev_sql_id
from ( select vst.sid,vst.value,vsn.name,vsn.statistic#
       from v$statname vsn, v$sesstat vst 
       where vsn.statistic# = vst.statistic# 
       order by vst.value desc 
    ) a
    , v$session vss
where a.sid = vss.sid
and vss.username = <Schema_Name>
and a.name =  'table fetch continued row';

• 세션을 찾은 후 해당 스크립트를 확인하고 찾아야 함.

■ Row Chaining 조회

SELECT owner, table_name, num_rows, blocks, chain_cnt from dba_tables
where chain_cnt <> 0;

 

---