Statspack Analyzer 2.0.1 beta

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.

http://www.statspackanalyzer.com/analyze_2_0_1.asp

 

Enjoy

 

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s