Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 20000 INSERTs per second?

Re: 20000 INSERTs per second?

From: Orca777 <kreitsch_at_csc.com>
Date: 24 Apr 2003 00:22:41 -0700
Message-ID: <867549b5.0304232322.1a1261df@posting.google.com>


Hi,
* JDBC drive : jdbc supports bulk-operations, this should be fast enough
* RAC : I see no need for RAC, this is for many many user-sessions, but not for fastest writing. * 64BIT : I see no advantage, because inserting is not so hard for the CPU

The main thing is:

* Large online-redo-logs
* Large log-buffer
* fast Disks/Cache where only online-redo -accesses
* no RAID for online-redo,
* fast Disk for archived Logs

I am sure that when i have an PIV/LINUX and ultra-speed Disk/Controllers i outnumber your nice 64 Bit-System having all data on SAN/RAID 5

ORca

ibm_97_at_yahoo.com (JZ) wrote in message news:<10bc841c.0304231047.5bc925ad_at_posting.google.com>...
> Oracle 9.2.0.3 enterprise for Solaris 2.8
> I like to know whethere it's possible to accomplish 20000 INSERTs (through
> JDBC drive, not pure INSERT SQL) per second on Oracle 9.2.0.3.
> If so, should we go with RAC or high end storage (to improve disk I/O)?
> Any docs about this or any suggestions to improve INSERTation rate
> through JDBC driver?
> Can 64bit environment improve this?
> Thanks a lot!
Received on Thu Apr 24 2003 - 02:22:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US