Re: ORACLE 8.0.3.0.0 is extremely slow vs SQL7 for medium database

From: Julian Cowking <jcowking_at_hrms.co.uk>
Date: Wed, 24 Mar 1999 14:28:05 -0000
Message-ID: <7dasnv$mue$1@starburst.uk.insnet.net>

Vitaliy,

Is there any way i can force a table within a schema to use a specific rollback segment? (Since I am trying to run the same code for SQLServer and Oracle is there any way this could be configured through, say, Enterprise manager?)
At the moment it seems to be random. The 'SET TRANSACTION USE ROLLBACK SEGMENT <RBS_NAME>;' statement has help enormously but this is used via SQLWorksheet and would be annoying to put in the middle tier logic for my components.

However, using this has helped me able to get all the rows in. When using this method it takes just over 2 minutes to insert 100,000 records. If the query needs to insert NO records (but still checks all 100,000 possible inserts) the time taken is 15 seconds.
Although this is much better than before, compared to SQL Servers comparitive times of 17sec and 6sec respectively, Oracle is still lagging. I have configured the extents, and RSs (although still need to know how to use them without specifying it in SQL) and although this has made a BIG difference SQL7 is still considerably ahead.

Any futher ideas?

Many thanks

Julian Received on Wed Mar 24 1999 - 08:28:05 CST