Re: ora-1555 and minextents (8i)

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Tue, 22 Jun 2004 06:46:30 +0200
Message-ID: <ubefd0pu527201lkc81v13rsqmf42uvhvc@4ax.com>

On Tue, 22 Jun 2004 00:46:41 +0200, "Peter Laursen" <none_at_invalid.invalid> wrote:

>With very large minextents I also need large optimal size. This might
>decrease overall performence since the rollback segments will not fit in
>memory and thus not be cached. Right? I am afraid that if I do, say 9 1Gb
>rollback segments normal day performence will drop hard.

You shouldn't use OPTIMAL. It is a *CAUSE* for ora-1555

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Jun 21 2004 - 23:46:30 CDT