1.

Where Are The Statspack Scripts Located?

Answer»

The statspack scripts are installed automatically in the $ORACLE_HOME/rdbms/admin directory (Unix) or the %ORACLE_HOME%rdbms admin directory (WINDOWS) when you install the ORACLE9I database software.

The most important scripts are:

  • spcreate.sql: INSTALLS the statspack;
  • spdrop.sql : Uninstalls the statspack;
  • spauto.sql : Automates the collection of statistics;
  • spreport.sql: Creates a performance report;
  • spdoc.txt : Provides documentation for the statspack;

spcreate.sql and spdrop.sql MUST be executed with the SYSDBA PRIVILEGE.

spauto.sql and spreport.sql should be executed under the PERFSTAT user.

The statspack scripts are installed automatically in the $ORACLE_HOME/rdbms/admin directory (Unix) or the %ORACLE_HOME%rdbms admin directory (Windows) when you install the Oracle9i database software.

The most important scripts are:

spcreate.sql and spdrop.sql must be executed with the SYSDBA privilege.

spauto.sql and spreport.sql should be executed under the PERFSTAT user.


Discussion

No Comment Found

Related InterviewSolutions