|
1. µð½ºÅ© Àб⠿À¹öÇìµå°¡ ½ÉÇÑ SQL¹® ã±â
select disk_reads, sql_text from v$sqlarea where disk_reads > 1000 order by disk_reads DESC;
2. ³í¸®Àû Àб⠿ÀÆÛ·¹ÀÌ¼Ç ¿À¹öÇìµå°¡ ½ÉÇÑ SQL¹® ã±â
select buffer_gets, sql_text from v$sqlarea where buffer_gets > 2000 order by buffer_gets DESC;
|