Remonter le mauvais SQL
SELECT disk_reads, executions, disk_reads/executions, sql_text
FROM v$sqlarea WHERE disk_reads > 5000 ORDER BY disk_reads
SELECT buffer_gets, executions, buffer_gets/executions, sql_text
FROM v$sqlarea WHERE buffer_gets > 100000 ORDER BY buffer_gets
Remonter les statistiques sur l’usage des colonnes
select obj.OWNER , obj.OBJECT_NAME, obj.OBJECT_TYPE, usg.*
from all_objects obj, col_usage$ usg
where usg.OBJ#=obj.OBJECT_ID;