RE: Saving STATSPACK Reports
- From: "Lawie, Duncan" <duncan.lawie@xxxxxxxxxxxxxxxxx>
- To: "'bnsarma@xxxxxxxxx'" <bnsarma@xxxxxxxxx>, "_oracle_L_list" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Sep 2006 17:06:07 +0100
If your purpose is overall trend analysis, something like orca_oracle (
http://www.hoopoes.com/cs/orca/ <http://www.hoopoes.com/cs/orca/> ) may be of
use to you (disclosure: I wrote it)
It requires some perl knowledge to make the best use of, but will retain the
headline stats from perfstat for a long time for trend analysis.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of BN
Sent: 08 September 2006 16:57
To: _oracle_L_list
Subject: Saving STATSPACK Reports
Greetings,
Have oracle 8.1.7.4 <http://8.1.7.4> , 9iRel2, and 10g Database running on
HP-UX, AIX, and SUN servers
We run Statspack every hour on all the prod servers and reatin only this weeks
data, the rest of the data is purged.
I am looking for a way to save the previous reports, like run spreport every
hour from cron job and pull reports every hour automatically.
I was also thinking of exporting the perfstat schema from all the 50 DB prod
servers and saving them in some other database
Not sure If run into resource issues to this.
Appreciate your suggestions in advance.
If some body has a script to do this I apppreciate if you can share with me.
--
Regards & Thanks
BN
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
Other related posts:
