Listing 2 spreport.sql

SQL> @spreport

Current Instance
~~~~~~~~~~~~~~~~

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
 4184632401 ORCL              1   ORCL



Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   DB Id    Inst Num DB Name      Instance     Host
----------- -------- ------------ ------------ ------------
 4184632401        1 ORCL         ORCL         localhost

Using 4184632401 for database Id
Using          1 for instance number

Completed Snapshots

                           Snap                    Snap
Instance     DB Name         Id   Snap Started    Level Comment
------------ ------------ ----- ----------------- ----- -----------
ORCL         ORCL             1 28 Nov 2005 20:00     5
                              2 28 Nov 2005 20:04     5



Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 1
Begin Snapshot Id specified: 1

Enter value for end_snap: 2
End   Snapshot Id specified: 2

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is sp_1_2.  To use this name,
press  to continue, otherwise enter an alternative.
Enter value for report_name: myStatspackReport.txt

-- a bunch of the report flies by the screen here, 
-- but don't worry we saved a copy to look at afterwards.

End of Report

SQL>