Re: Single RBS for DS system

Kevin Jernigan <kjerniga_at_emergent.com> wrote:
>lparsons_at_eskimo.com (Lee Parsons) wrote:
>
>> Remember we have 50 query users and the only updates are done by a single
>> process with no other users on.
>
>It makes sense to have only on rollback segment, though even that won't be
>used if you are doing direct path loads. The direct path option of
>SQL*Loader bypasses the Oracle buffer cache to write data directly to disk
>- rollback is accomplished by not moving the highwater mark for the table
>being loaded until after the load is complete (or after the specified
>number of rows is loaded).

This is only true if you have the UNRECOVERABLE keywork in the control file. I only mention it because I expected it to be a command line option but find that I have to delta all my control files and make them in compatable with regular (non-direct) loads. Uhg.

Also, I do need a reasonable sized RBS when the load process does some data massaging and creates indexes.

-- 
Regards, 

Lee E. Parsons                  		
Systems Oracle DBA	 			lparsons_at_world.std.com