| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Hard disk configuration for fast write (Insert)
Charles Hooper wrote:
> 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.
It also applies to INSERTs when the rows are SELECTed from another object...
SQL> create table t1116(c number) nologging;
Table created.
SQL> begin
2 for i in 1..100000 loop
3 insert /*+ append */ into t1116 values(i);
4 end loop;
5 end;
6 /
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> select value from v$mystat where statistic#=(select statistic# from v$statname where name = 'redo size') 2 /
VALUE
SQL> insert /*+ append */ into t1116 select * from t1116;
100000 rows created.
SQL> commit;
Commit complete.
SQL> select value from v$mystat where statistic#=(select statistic# from v$statname where name = 'redo size') 2 /
VALUE
SQL> Regards,
Steve Received on Thu Nov 16 2006 - 08:51:44 CST
 |
 |