Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

statspack report generation shell script?

210761Oct 24 2005 — edited Oct 26 2005

Does anyone have a shell script (unix/solaris) which does the following:

Gets the snap_ids from the 09:00 and 17:00 statspack snapshots (from today or yesterday), and runs spreport.sql, using these snapshot ids as begin_snap and end_snap.

I do not want to purge any snapshots from the database. I simply want to generate a daily "9 to 5" statspack report every day.

TIA,
Dave

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 23 2005

Added on Oct 24 2005

#general-database-discussions

5 comments

948 views