Frank van Bortel wrote:
> fitzjarrell_at_cox.net schreef:
>>>>
>>>> With multiple rollback segments, Oracle tries to use the SYSTEM
>>>> rollback segment only for special system transactions and distributes
>>>> user transactions among other rollback segments.
>
> I thought DDL used the System Rollback?
>
>>>> If there are too many
>>>> transactions for the nonSYSTEM rollback segments, then Oracle uses the
>>>> SYSTEM segment as necessary. In general, after database creation,
>>>> create at least one additional rollback segment in the SYSTEM
>>>> tablespace."
>
> That's a new for me...
And it appears to not be good advice based on preliminary information
from Oracle. The only place it appears in the docs is on a page
dedicated to deprecated features: And then only with 9.2.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Thu Sep 07 2006 - 21:32:17 CDT
