AWR SQL ordered by CPU time
Hello,
an AWR report contains a section "SQL ordered by CPU Time". For our application this table contains the top 10 SQL statements covering about 50% of CPU Time. I need to know which are the statements responsible for the remaining 50% of CPU Time. I already did what is described in the DBMS_WORKLOAD_REPOSITORY documentation about snapshot levels, i.e. the first 100 SQL statements should be analyzed, but the results are not shown in the report. Is there a chance to execute the querry which generates this section of an AWR report manually? Thanks a lot.
regards,
Rüdiger
an AWR report contains a section "SQL ordered by CPU Time". For our application this table contains the top 10 SQL statements covering about 50% of CPU Time. I need to know which are the statements responsible for the remaining 50% of CPU Time. I already did what is described in the DBMS_WORKLOAD_REPOSITORY documentation about snapshot levels, i.e. the first 100 SQL statements should be analyzed, but the results are not shown in the report. Is there a chance to execute the querry which generates this section of an AWR report manually? Thanks a lot.
regards,
Rüdiger
0