Re: How can I find out what the current size of my rollback segments are?

From: Chuck <chuck_hamilton_at_yahoo.com>
Date: Fri, 7 Dec 2001 12:57:51 -0500
Message-ID: <9uqvt7$aegc6$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

"Stan Brown" <stanb_at_panix.com> wrote in message news:9uqun4$ihp$1_at_panix3.panix.com...
> 7.3.4.5
>
> How can I fund out how big, and how utilized my rollback segments
> are at any given time?

select b.name, a.rssize
from v$rollstat a, v$rollname b
where a.usn = b.usn;

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPBEDHGm5A4kkb4ZsEQIPqgCg60CkWtA6yXaZvjU2+6e86hTC3jwAn0n6 oVSpy9Nc1OPzhsQ8Cnu091FG
=zLgV
-----END PGP SIGNATURE----- Received on Fri Dec 07 2001 - 11:57:51 CST