Re: Single RBS for DS system
Date: 1995/04/24
Message-ID: <kjerniga-2404951009190001_at_slipkevinj.emergent.com>#1/1
In article <D7CtoD.JHv_at_eskimo.com>, lparsons_at_eskimo.com (Lee Parsons) wrote:
> I'm implementing a Decision Support system next week I had a quick question
> about rollbacks segs.
>
...
> Since this flies in the face of popular (documented) wisdom I have to ask:
>
> Reasonable?
> Any DS impementors out there that went this route and regretted it?
>
> Remember we have 50 query users and the only updates are done by a single
> process with no other users on.
> --
> Regards,
>
> Lee E. Parsons
> Systems Oracle DBA lparsons_at_world.std.com
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).
Kevin Jernigan
Senior Consultant, Emergent Corporation
kjerniga_at_emergent.com
Received on Mon Apr 24 1995 - 00:00:00 CEST