Re: Oracle Benchmark on Sun workstation??!!

On Thu, 22 Jun 2000 20:08:08 GMT, ibm 97_at_yahoo.com wrote:

>Hi, all:
>
>Oracle 8i for solaris 2.6 on Sun Ultra 10 workstation.
>
>We want to know the max number of inserting can be done per second.
>Inserting size is around 200 bytes.
>
>How can we know this benchmark? 'cause we don't want to crash our
>machine.
>
>Thanks a lot!!!

just write simple OCI program that uses: insert into t1 (f1)values(:1); so u'll see network performance and oracle perf.

or create two tables with the same fields, fill out one, then: insert into t1 (f1,f2) select f1,f2 from t2; this tests only oracle perf.

• Azamat Khalilov --- aza(a)aisdev*gns*bashnet*ru ---