When first visiting a site TRU (UK) consultants use this and other similar scripts to gain quick insights into database performance. This shareware version of PSL contains almost 100 scripts. The reports built by these scripts are designed to give you statistics on much of the internals of ORACLE. Learning to interpret these statistics will speed you on your way to becoming a performance expert.

Generating Performance Reports
Using the 'sys' account the DBA runs snapshot.sql from SQL*Plus. Immediately, the script begins spooling off a variety of statistical reports in easy to read HTML format. The script currently connect to the database as "/ as sysdba", but can be modified with a suitable sysdba user. It is recommended that if a username/password is stored in the script, then it should have its ownership changed to that of READ-ONLY for the DBA user.

All Performance Scripts?
Although some of the scripts included are not directly related to performance tuning they provide important information to assist in the initial evaluation the site.

Why PSL?
TRU (UK). is releasing this shareware version of PSL mostly as an aid to those interested in Oracle Performance Tuning. We realize this product is not a major GUI application with a lot of 'bells & whistles' however we feel that it will help those using it to better understand Oracle performance issues. Some of our clients have even 'cut & pasted' and hacked up the core PSL script creating their own unique set of reports. Feel free to do the same! Just remember, its just a bunch of scripts and some html.