automate statspack reports

is there a way to automate statspack reports to generate a daily report
oracle 11g aix 7
LVL 1
bkreynolds48Asked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
You can copy spreport.sql and modify it to not prompt for the snaps but you would need some queries to decide the start and end snap you want.  I guess it depends on how you define "daily report" since the snaps might span different times.

Once you get your script created you can schedule it to run from cron or whatever scheduler you have available.
0
 
bkreynolds48Author Commented:
do you know anything about using spauto.sql to automate the statspack reports?
0
 
slightwv (䄆 Netminder) Commented:
Nothing from personal experience.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
bkreynolds48Author Commented:
is there a way to write a wrapper script to run statspack reports?  I have that for the awr reports but can only find a start time for statspack not an end time like awr has
0
 
slightwv (䄆 Netminder) Commented:
The short answer is yes.  I cannot comment on "how" from personal experience since I've never done it.

There are several examples on the web that show ways to automate statspack reports.
0
 
bkreynolds48Author Commented:
I was able to write a wrapper script to do this
thanks for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.