InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Do I Create A Performance Report? |
|
Answer» $sqlplus SQL>connect perfstat/perfstat SQL>@?/rdbms/admin/spreport.sql The performance report calculates differences in the statistical numbers of two snapshots (final snapshot MINUS the start snapshot). To ensure that these calculated values can be USEFULLY interpreted, the instance between the two snapshots must not have been stopped. The reason for this is that a snapshot determines its FIGURES from the V$ tables, which are reset to 0 each time an instance starts. $sqlplus SQL>connect perfstat/perfstat SQL>@?/rdbms/admin/spreport.sql The performance report calculates differences in the statistical numbers of two snapshots (final snapshot minus the start snapshot). To ensure that these calculated values can be usefully interpreted, the instance between the two snapshots must not have been stopped. The reason for this is that a snapshot determines its figures from the V$ tables, which are reset to 0 each time an instance starts. |
|