How to obtain a Statspack report from Oracle

Execute the script "@spcreate" in the install directory
    - creates the required tables spaces for statistics collection and the perfstat user.

Execute "statspack.snap"
    - copies the before statistics to the snapshot repository.

<perform critical testing>

Execute "statspack.snap"
    - copies the after statistics to the snapshot repository.

Execute "sqlplus perfstat/<password> @spreport.sql"
    - starts a script that displays the snapshots that are available in the repository,
    - creates a report based upon two snapshots.

How to obtain an AWR report from Oracle

A user must be granted the DBA role

Use Enterprise Manager to configure AWR report intervals.  AWR is installed by default.

The awrrpt.sql SQL script generates an HTML or text report that displays statistics for a range of snapshot IDs

Specify the report type:

   Would you like an HTML report, or a plain text report?
   Enter 'html' for an HTML report, or 'text' for plain text.

Enter value for report_type: text