You left out how much time you have for the 8600 inserts. What kind of
indexes will be on the table. Are there any foreign keys that need to be
checked upon insert. Is there a primary key on the table. It's not hard to
get 1000-2000 rows per second inserted into a database, but it is also
sometimes difficult getting 100. It just depends.
--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
<psyklops_at_my-deja.com> wrote in message news:8hmihh$nak$1_at_nnrp1.deja.com...
> Hi All,
>
> Does anyone have any suggestions in regards to a typical storage
> hardware requirement or configuration setup to service around 8600
> Oracle "inserts". Each insert is 500 bytes in size and is write
> intensive. I am assuming that each insert would equate to an IOP? We're
> possibly looking at a high-end RAID array system or even a large number
> of mirrored disk spindles. Has anyone implemented anything similar and
> what storage subsystem was used to provide the performance needed?
>
> We're running a HP9000 L-Class server and that the Oracle database will
> either be configured for RAW volumes, or using standard filesystem with
> Veritas's Quick I/O available on Veritas Database Edition for HP-UX.
>
> Please let me know if more information is needed.
>
> Thanks
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jun 08 2000 - 00:00:00 CDT
