Requetes diagnostics tuning

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;