Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Automated Statspack Report

Re: Automated Statspack Report

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 21 Jan 2004 22:20:23 +0100
Message-ID: <400eecb4$0$1157$636a55ce@news.free.fr> 






"Dave" <david.register_at_eds.com> a écrit dans le message de
news:2fc017e4.0401211204.38d74cde_at_posting.google.com...


> Does anyone know of a script to automatically find the latest snapshot

> id's and generate a statspack report from?

>

> Thanks in advance!




I give you a clue:



select startup_time, min(snap_id),max(snap_id),
min(snap_time),max(snap_time) from stats$snapshot
group by startup_time;



Regards


Michel Cadot
Received on Wed Jan 21 2004 - 15:20:23 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US