Re: system tablespace rollback segment is corrupted in 8i or 9i

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 07 Sep 2006 21:06:27 +0200
Message-ID: <edpq9n$pv7$1@news5.zwoll1.ov.home.nl>

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...

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Thu Sep 07 2006 - 14:06:27 CDT