RE: non-rollback-able DML

The answer is simply "no", because that would defeat the purpose of the RDBMS as
a TP monitor and logical consistency is ALWAYS more important then the performance.
If you want raw speed, then simply write a bunch of C programs accessing ASCII files
and you don't have to worry about rollbacks, redo logs and alike. If you need SQL you
might resort to MySQL which does not have built in transaction management (yes, no
commit/rollback commands) and does not adhere to ACID standard but does achieve
blinding speed.

-----Original Message-----
From: andrey [mailto:bronfin_at_visualtop.com] Sent: Tuesday, December 05, 2000 6:31 AM To: Multiple recipients of list ORACLE-L Subject: non-rollback-able DML

Dear all !  

Is there a way to perform a DML ( insert , update , delete ) against an Oracle DB without writing to rollback segments ( in order to improve performance ) ?
Is there a way to insert , update , delete without writing to redo log buffer as well ( i'm aware of "nologging" , but this does not good enougth for any DML ) . Received on Tue Dec 05 2000 - 10:35:38 CST