statpack setup

May 22, 2007 at 3:37 pm (ORACLE)

  1. create perfstat tablespace ~ 100M
  2. create temp tablespace ~ 100M
  3. run ?/rdbms/admin/spcreate.sql
  4. execute statspack.snap
  5. run ?/rdbms/admin/spreport.sql

if needed:- run ?/rdbms/admin/spdrop.sql to drop perfstat schema.

Advertisement

Leave a Reply

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

Gravatar
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 )

Cancel

Connecting to %s

Follow

Get every new post delivered to your Inbox.