Create Performance Monitoring Objects

Introduction:

These are extra schema components that allow the DBA and users to monitor the performance of some aspects of the database.

Aim:

Install:

• plustrace
• catclust
• utlchain

Requirements:

Oracle instances are up.

Procedure:

• Log in as oracle.
• Open Terminal.
• For the instances sta & whs:
• $ chora SID
  
• $ sqlplus system/*********
• SQL> connect sys as sysdba
• Enter password: *********
• Connected.
• SQL> @$ORACLE_HOME/sqlplus/admin/plustrce
• SQL> @$ORACLE_HOME/rdbms/admin/catclust
• SQL> @$ORACLE_HOME/rdbms/admin/utlchain