test

--最应该牢记的表
dict
v$fixed_table
v$fixed_view_definition
dba_views


--手工remaster一张表
oradebug lkdebug -m pkey DATA_OBJECT_ID

--11g需要手工重新收集字典统计信息
exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS ;
exec DBMS_STATS.GATHER_SYSTEM_STATS ;
exec DBMS_STATS.GATHER_DICTIONARY_STATS ;


SELECT ASH.SQL_ID,
       SUM(DECODE(ASH.SESSION_STATE, 'ON CPU', 1, 0)) "CPU",
       SUM(DECODE(ASH.SESSION_STATE, 'WAITING', 1, 0)) "WAITING",
       SUM(DECODE(SESSION_STATE, 'ON CPU', 1, 1)) "TOTAL"
  FROM V$ACTIVE_SESSION_HISTORY ASH
 WHERE SAMPLE_TIME > SYSDATE - (10 / (24 * 60))
   AND SQL_ID IS NOT NULL
 GROUP BY SQL_ID
HAVING SUM(DECODE(ASH.SESSION_STATE, 'ON CPU', 1, 1)) > 50
ORDER BY 4 DESC ;