 |
Create The PSL Home Directory
Since you're reading these instructions we're assuming you
created a working directory and unzipped the PSL source files into it correctly. |
| |
 |
Login To SQL*Plus as SYS
From your new PSL working directory
start-up SQL*PLUS using
the 'sys' account.
D:\> cd \dev\tune\opt\psl
D:\dev\tune\opt\psl\>plus33 sys/<password>
Note:If you've set up a windows shortcut, make sure that the Current
Working Directory property is correctly defined as the PSL Home Directory because output from
the sqlplus scripts are required to be in the PSL working directory. |
| |
 |
Run The PSL Script
Located in your new PSL home directory is a sql script called 'snapshot.sql'.
This one script is a collection of many different scripts. As the script runs,
you'll see the various reports its generating. Depending on the size of your
database (SGA,Tables,etc.), it may take some time for the entire script to complete.
After you've run the script you may want to comment out some of the more
time consuming scripts to speed things along.
SQL> @snapshot
Start Time:04/13/98 12:45:49
Retreiving Database Info...
Retreiving Version Info...
Retreiving Init.ora Parameters...
Retreiving Undocumented INIT.ora Parameters...
Retreiving SGA Statistics...
Retreiving Hit Statistics...
.
.
End Time:04/13/98 12:58:16
SQL>_
A Few DBA Notes: - Most DBA's are uncomfortable just running any old script as 'sys', even if the
script is from Oracle. Feel free to view the snapshot.sql script. It does
create a few temporary tables and views. All the temporary objects are documented
in the header of the script and are like wised dropped upon completion.
- A few reports require the existence of certain v$_ views that may not exist in
your database. If a report is blank, they'll be a footer note indicating which Oracle
admin script it needs.
- The snapshot.sql script does not have an 'exit'. Feel free to add it.
- A few scripts may already be commented out due their long runtime. If this is
the case, a message in the report will indicate this. Just uncomment the source to turn it
back on.
|
| |
 |
Point Your Browser To 'psl.htm'
When the snapshot script is finished direct your browser
to
file:///d|/dev/tune/opt/prod/psl.htm or whatever directory is
appropriate. 
Selecting 'Performance Snapshot Results'
will present you with a screen containing the results from the various
scripts. |
| |
The Short Explanation
In short, once the
PSL directory is set-up, run the 'snapshot.sql' script as the 'sys' user from that working directory. The output from the script generates
a variety of *.htm files. After the script is finished, point your browser
to psl.htm. Once the main menu appears select 'Performance Snapshot Results'.
|