Re: Hard disk configuration for fast write (Insert)

Volker Hetzer wrote:
> Sam schrieb:
> > Hi There,
> > What is the best Hard disk (Raid or striping) configuration (With minimum
> > number of hard disk) for a Oracle database with lot's of
> > Insert but not that much of read (query), also this database dos not need to
> > be in archive mode (Data is not that critical right now).
> Striping, typically 1MB stripes. No mirroring.
> Of course, with a nologging database, the only recourse with a corrupt block
> is to find out the relevant object and drop/recreate it. With a corrupt block
> in a system table this means a reinstall.
> But you /did/ ask for maximum write performance.
>
> Lots of Greetings!
> Volker

Volker Hetzer wrote:
> Sam schrieb:
> > Hi There,
> > What is the best Hard disk (Raid or striping) configuration (With minimum
> > number of hard disk) for a Oracle database with lot's of
> > Insert but not that much of read (query), also this database dos not need to
> > be in archive mode (Data is not that critical right now).
> Striping, typically 1MB stripes. No mirroring.
> Of course, with a nologging database, the only recourse with a corrupt block
> is to find out the relevant object and drop/recreate it. With a corrupt block
> in a system table this means a reinstall.
> But you /did/ ask for maximum write performance.
>
> Lots of Greetings!
> Volker

A no logging database - an Oracle database without online redo logs? Would this Oracle database also not offer undo?

The NOLOGGING clause applies to the initial creation of the objects only, not any DML that may take place on the tables, indexes, etc. after creation.
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:9549144668497

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Nov 16 2006 - 08:20:32 CST