InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are The Advantages Of The Statspack Compared With Utlbstat/utlestat? |
|
Answer» The data collected by the statspack is more extensive and is saved in tables in the ORACLE database so that you can use it LATER to diagnose performance problems or to create trend analyses. The overall diagnosis generated by the statspack INCLUDES an overview over the instance status (instance HEALTH), a load profile, the MAIN SQL statements with the highest resource consumption and information about queues, events and profile parameters. The data collected by the statspack is more extensive and is saved in tables in the Oracle database so that you can use it later to diagnose performance problems or to create trend analyses. The overall diagnosis generated by the statspack includes an overview over the instance status (instance health), a load profile, the main SQL statements with the highest resource consumption and information about queues, events and profile parameters. |
|