[10.2.0.4 on W2K3] How to detect high activities period on database ?
Hi,
In an AWR report, comparing Elapsed time with DB Time seems to be the first task we have to perform in order to detect problem on a database.
I need a query that will enable me to display DB time for periods between each snapshots (in dba_hist_snapshot).
Who could help me ?
Another question :
When I run awrrpt.sql it asks me the file format, begin and end snapshot,...etc : is there a way to run awrrpt.sql in non interactive mode ?
Rgds,
Frederic
I need a query that will enable me to display DB time for periods between each snapshots (in dba_hist_snapshot).
Who could help me ?
Another question :
When I run awrrpt.sql it asks me the file format, begin and end snapshot,...etc : is there a way to run awrrpt.sql in non interactive mode ?
Rgds,
Frederic
0