Switch branches/tags
Nothing to show
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
01-install.sql
02-schedule.sql
03-idle-events.sql
04-modify-level.sql
08-create-delta-views.sql
11-comment-with-load.sql
README.md
oracle-scene-63-f-pachot-improving-statspack-experience.pdf

README.md

Please refer to UKOUG Oracle Scene article: Improving Statspack Experience

Here are the related scripts for Statspack installation:

  • 01-install.sql to create the tablespace and call spcreate
  • 02-schedule.sql to schedule snap and purge jobs
  • 03-idle-events.sql to fix issue described at https://blog.dbi-services.com/statspack-idle-events/
  • 04-modify-level.sql to collect execution plans and segment statistics

Additional scripts:

  • 08-create-delta-views.sql to create views easy to query
  • 11-comment-with-load.sql to add load information to snapshots without comments