OLTP Vs. Batch processing Operations

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 19 May 2004 14:22:47 +0530
Message-ID: <F0CB3C9983B77E4AB4ADEFA63DAB109F07114556@twrmsg03.ad.infosys.com>

 

For OLTP versus Batch processing with WRITE Operations into Databases, what may be best practices?  

For OLTP

Smaller Oracle DB Block Size

Smaller Stripe Unit Size

Use of Bind Variables to avoid re-parsing

Row-wise load of data

Logging to Redo Logs    

For Batch  

Smaller Oracle DB Block Size

Smaller Stripe Unit Size

Use of Literal SQLs

Block-wise Loading of Data

NOLOGGING to Online Redo Logs            

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed May 19 2004 - 03:51:40 CDT