MY COMPASS

SELECT * FROM DBA_HIST_WR_CONTROL; SELECT * FROM DBA_HIST_SNAPSHOT ORDER BY SNAP_ID DESC;

http://m.blog.naver.com/shadouman/80122594664 STATTYPE_LOCKED 컬럼에 ALL 값이 존재하면 통계정보 생성을 하지 못하게 락이 걸려 있는것이며 값이 없다면 통계정보를 생성할 수 있는 것이다. select OWNER,TABLE_NAME,STATTYPE_LOCKED from dba_tab_statistics WHERE OWNER = 'SCOTT' AND TABLE_NAME = 'EMP'; OWNER                          TABLE_NAME                     STATTYPE_LOCKED ------------------------------ ------------------------------ --------------- SCOTT                           EMP                                ...