When we need to insert data(table) to database (NO RAC and RAC) faster...,
we should have disk i/o faster. that's a good idea (example: solid state or make raid 1+0)
INSERT INTO XXX VALUES(a,b,...);
Anyway What should we do on Oracle Database?
- insert nologging
- No Archivelog
- No index
- Use big block size(example 16k, 32k)
- Concern about redo log, if use logging
What about your idea to improve this case?