Scripts other than catalog.sql and catproc.sql?

As part of any database creation, the DBA is required to run 2 scripts that handle the creation of Data Dictionary objects and basic PL/SQL and internal packages. These files are catalog.sql and catproc.sql and can be found in the $ORACLE_HOME/rdbms/admin directory on a UNIX host.

Oracle comes with a number of other scripts not called by the installer that create objects that many DBA's find useful. These scripts should be run in addition to the basic catalog.sql and catproc.sql.

dbmspool.sql

Along with the script prvtpool.sql creates the DBMS_SHARED_POOL package. This package provides access to the shared pool. This is the shared memory area where cursors and PL/SQL objects are stored. These two scripts must be run while connected as SYS or INTERNAL.

catblock.sql

Creates several views including DBA_LOCK and DBA_LOCK_INTERNAL that can be used in monitoring locks within the database. This script must be run while connected as SYS or INTERNAL.

catparr.sql

Parallel-Server specific views for performance queries, etc. This script must be run while connected as SYS or INTERNAL.

pupbld.sql

This script is used by the DBA to create the product_profile and user_profile tables in the SYSTEM account. There are two views, product_privs and user_privs, which are what a user will see as product_profile and user_profile. They allow the user to see (and in the case of user_profile, modify) only their own privileges or profiles. This script must be run while connected as SYSTEM.


Your Name:
Email:
Subject:
Comments:

Scripts other than catalog.sql and catproc.sql?

See Also