Help with query

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Thu, 07 Dec 2006 17:05:23 GMT
Message-ID: <nRXdh.186$7h.26@trnddc02>

-----BEGIN PGP SIGNED MESSAGE-----

Hash: SHA1

I'm trying to come up with a query of v$undostat that will show the total # of undo blocks used during any two hour period. The output should look like this..

begin_time	end_time	undoblks
==========	===========	===========
09:00		11:00		123
09:10		11:10		145
09:20		11:20		1032

You get the picture. It's essentially the same thing that "Select begin_time, end_time, undoblks from v$undostat" would show if each row was 2 hours apart instead of 10 minutes apart.

TIA
-----BEGIN PGP SIGNATURE-----

Version: GnuPG v1.4.5 (MingW32)

iEYEARECAAYFAkV4SdMACgkQzIf+rZpn0oRP5wCfbQgQ0RDy6oBm5exvkYUsLCNm jZEAn3I/T2ctqgwj1OrtHD8DblZwUAoa
=4KyX
-----END PGP SIGNATURE-----
Received on Thu Dec 07 2006 - 11:05:23 CST