IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1

---

Oracle database optimization

Complete the following steps to perform database maintenance on the Oracle database:

1. Login to the database server: for UNIX or Linux:

    su - oracle

   For Windows: Open an oracle sqlplus editor.

2. Connect to the octigate database:

   sqlplus am username/password@octigate

3. Run the command to collect schema statistics:

   exec dbms_stats.gather_schema_stats ('am')

4. Exit the database:

   quit

Parent topic:

Performing database optimization

---

+

Search Tips   |   Advanced Search