2
Configuring the Oracle Tuning Pack

Oracle Tuning Pack addresses particular tuning needs and activities which help ensure that the database and applications run at peak efficiency.

Some of the applications in the Oracle Tuning Pack require configuration.

Applications	Configuration Required?
Expert	No configuration required
Index Tuning Wizard	No configuration required
SQL Analyze	Yes, see the section, "Configuring SQL Analyze"
Tablespace Map	No configuration required.
Reorg Wizard	No configuration required

Note: The Oracle Tuning Pack is a separately licensed and purchased product.

Configuring SQL Analyze

To run SQL Analyze, you must have certain object privileges which are available to users who are granted the DBA role. If you want to assign the minimum privileges required, you can use the optional SQLADMIN role, which assigns the base set of object privileges required by a user.

The VMQROLE.SQL script is provided to help automate the process of creating the SQLADMIN role. It is located in the $ORACLE_HOME\SYSMAN\ADMIN directory.

1. From the DBA Management Pack program group via the Start menu, select the SQLPLUS Worksheet icon to start the application.

2. Use the Login Information dialog box to connect SYS to the database on which you want to run SQL Analyze.

3. From the Worksheet menu, run the VMQROLE.SQL script to create the SQLADMIN role for the managed database.

4. In the SQL*Plus Worksheet, assign the SQLADMIN role to the user by typing

    Grant SQLADMIN to <user>;
   
   

5. Exit SQL*Plus Worksheet.

---