Re: How to see how much space I have left on the rollback segments ?

I hit send too early:

> And v$undostat doesn't actually give us directly any information how much
> the automatically managed undo segments could grow, or how much free space
> they got in them. Instead, they provide us even more valuable information
> such:
> * SSOLDERRCNT (how many times ORA-1555 has occurred)
> * NOSPACEERRCNT (how many times no free space at all was possible to
> allocate in undo seg)
> And three UNXP% parameters. SSOLDERRCNT and NOSPACEERRCNT should always be
> zero in normally working system and UNXP parameters (number of unexpired
> undo blocks/extents which have actually been allocated to another
> transaction before undo_retention should allow).

...the UNXP *columns* values in v$undostat should be low as well, otherwise undo_retention could be compromized..

Tanel. Received on Mon Aug 04 2003 - 17:40:27 CDT