Re: Saving STATSPACK Reports

BN,

Why would you bother saving all that information in a format that is practically impossible to search or summarize effectively (i.e. "flat" ASCII text), when you have all that information in tables and a fantastic query/reporting language available (i.e. SQL).  Forget about the STATSPACK reports themselves -- throw them away.  Save the data in the PERFSTAT schema over time so that you can reproduce whatever reports you want at will.  Exporting to another database is a good idea, or just increase your purge parameters a bit so you can retrieve reports over time.  The data starts to become useless after a while anyway.

Hope this helps...

-Tim

On Fri, 8 Sep 2006 11:56:40 -0400, BN wrote
> Greetings,
>
> Have oracle 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
 

--
http://www.freelists.org/webpage/oracle-l