We have different projects with two environments:
DB2 on AIX and Oracle on DEC UNIX. Now we wonder why a statement lasts
on DB2 (17000 records) about 1 second, and on Oracle (11000 records
only) more then 10 seconds. It's a simple update on several columns
without condition. The machines should be comparable in CPU Speed.
(compiling C code is faster on DEC UNIX). The AIX mschine has 256 MB of
memory, the DEC machine 640 MB. The SGA on the DEC machine is 320 MB!
The affected rows are off slightly different type: Smallint on DB2,
Number (3) on Oracle.
Any ideas, why performance is so bad in Oracle? (It's Oracle 8.0.5)
--
Burkhard Schultheis
Tele Data Electronic
Wagnerstr. 10
D-76448 Durmersheim
Email: schultheis_at_tde-online.de
Phone: +49-7245-9287-21
Fax: +49-7245-9287-30
Received on Tue Jul 03 2001 - 10:56:08 CDT
