Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Automated Statspack Report
> Does anyone know of a script to automatically find the latest snapshot
> id's and generate a statspack report from?
I don't know of such a script, but it shouldn't be too hard to write. One question....what starting id would you use? How would you know which one to choose? You can't pick the earliest snapshot because it would be highly likely that a db shutdown will have occurred between those snapshots.
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Wed Jan 21 2004 - 14:13:34 CST