This post is a summary of the Oracle Statspack Survival Guide.
To install statspack :
- Create tablespace for it
- @?/rdbms/admin/spcreate (run as sysdba)
To take snaps :
- exec statspack.snap;
To create the report :
- @?/rdbms/admin/spreport.sql
-
‹ Home
Contents
-
Categories
-
Ads
-
Archives
- December 2011
- October 2011
- May 2011
- March 2011
- February 2011
- November 2010
- September 2010
- July 2010
- March 2010
- January 2010
- December 2009
- November 2009
- October 2009
- August 2009
- July 2009
- June 2009
- April 2009
- February 2009
- January 2009
- November 2008
- October 2008
- September 2008
- July 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- November 2006
- August 2005
- October 2004
- August 2004
- July 2003
- October 2002
-
RSS Feeds
-
Meta
Post a Comment