Re: Rollback Segments?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 27 Oct 1999 21:30:53 +0800
Message-ID: <3816FE8D.103@yahoo.com>

Nick wrote:
>
> Hi,
>
> We have the standard 4 rollback segments, which are set at roughly 1gig
> each. But with only 4 users, occasionally they get errors stating that
> the rollback segments are full. Is their a way to flush out the rollback
> segments - ? Thanks for any help,
>
> -Nick

Ensure that they have an optimal clause set - check DBA_ROLLBACK_SEGS --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Oct 27 1999 - 08:30:53 CDT