Re: Single RBS for DS system

Kevin Jernigan <kjerniga_at_emergent.com> wrote:
>Actually, UNRECOVERABLE refers to the redo logs, not to the rollback
>segments.

You are of course absolutly correct. Mea Culpa.

>Data massaging done by SQL*Loader is usually done on the client side,
>before the data is sent to the server side, and doesn't involve database
>access, so it wouldn't require any rollbac segments.

Most of the massaging we do is post load cleanup/Summary Calcs. Some of them are rather nasty.

>Index creations
>done by direct path SQL*Loader will require temp space within the database

We're currently dropping indices/truncating tables/loading tables and recreating the indices. I dont know if allowing direct load to create the indices is a major win (which I consider to be a +25% perf increase) But I do know that having all my indices left in Direct Load state because loader burped on the last row is a major lose.

This is to some degree just bitching and moaning. I'm sure that I would be willing Direct load the indices once it is a bit more stable. I had enough problems with it during this conversion to make nervous. (V7.1.3 BTW)

Even so the issue still remains that if we use direct load for index creation we are running the risk of finding out about any fatal load problems much later in the process and cutting down on recovery time.

But I digress. :-}

-- 
Regards, 

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