Message-Id: <10701.123677@fatcity.com> From: "Gogala, Mladen" Date: Tue, 5 Dec 2000 11:35:38 -0500 Subject: 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@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 ) .