UNDO Statistics on Hourly Basis?
546111Jul 2 2008 — edited Jul 2 2008V$undostat displays undo statistics for the last 7 days and for every 10 minutes.now i want a sql which should display the undo statistics for the last 7 days for every one hour.The format shoul be as below
begin_time end_time sum(undoblks) sum(txncount) max (maxquerylen)
------------------------------------------------------------------------------------------------
01-jun-2008 00:59:05 01-jun-2008 01:59:05 300 100 1500
01-jun-2008 01:59:05 01-jun-2008 02:59:05 390 150 1200
undoblks should be sum of all undo blocks during one hour duration
txnncount should be sum of all txncount during one hour
maxquerylen should be maximum maxquerylen during one hour duration.
DB version is 9.2.0.6
Thank you all