Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 20000 INSERTs per second?
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
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