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

Hi Julian,

You can not tell the table to use a specific RBS, but you can MAKE IT, by taking all other RBS OFFLINE and just living the BIG_ONE online:

you can do this by removing their names from the INIT.ORA file which is located in %ORACLE_HOME%\database\ <---- NT

               %ORACLE_HOME%/dbs/ < ---- UNIX or you can issue this comand in SQLPLUS: SQL> alter rollback segment <RBS_NAME> offline;

Good Luck !

Vitaliy Mogilevskiy

Julian Cowking wrote:

> 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 - 10:56:36 CST