InterviewSolution
| 1. |
What Is A Statspack? |
|
Answer» Statspack is the abbreviation for statistics package. The statspack consists of a collection of SQL, PL/SQL and SQL*Plus scripts. The statspack helps you to collect, STORE, compare, FORMAT and analyze performance data for an Oracle instance. With the statspack, you can, for example, determine the cause of performance problems or determine and quantify the effects of profile parameter CHANGES. Refer to the section about TYPICAL usage SCENARIOS for more information. Statspack is the abbreviation for statistics package. The statspack consists of a collection of SQL, PL/SQL and SQL*Plus scripts. The statspack helps you to collect, store, compare, format and analyze performance data for an Oracle instance. With the statspack, you can, for example, determine the cause of performance problems or determine and quantify the effects of profile parameter changes. Refer to the section about typical usage scenarios for more information. |
|