ORACLE too slow on HP 7400 vs WinNT2000 ? Why ?

[nurlan]

HP_UX (?????? rp7400 ? rp5430, 750 MHz PA8700 CPU2.25 Mb cache, RAM 2Gb) NT (?????? Dell PowerEdge 1500SC, ??? ?????????? 2x Intel Pentium III1130 Mhz, with Level –2 cache, 512 KB, RAM 2Gb)
??? ??: HP_UX 11i (64 bit) ??? ??: Windows 2000 Server (build 2195:sp4)
????????? ???? ?????? ORACLE 9.2.0 Total System Global Area 714043304 bytes (??????)Fixed Size 737192 bytesVariable Size 234881024 bytesDatabase Buffers 477626368 bytesRedo Buffers 798720 bytes ????????? ???? ?????? ORACLE 8.1.7 (32 bit)Total System Global Area 1 171 458 076 bytesFixed Size 5804 bytesVariable Size 307400704 bytesDatabase Buffers 863903744 bytesRedo Buffers 7824 bytes
???????????? SQL ????????
SQL>select count (*) from l_oper; ?????????? ??????? ? ???????: 1653707????? ??????????: 00:00:01.04???? ??????????---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1803 Card=1) 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'L_OPER' (Cost=1803 Card=1650150)??????????---------------------------------------------------------- 0 recursive calls 4 db block gets (?????. ?????? ????????? 18745 consistent gets ? ????) 0 physical reads (?????? ? ?????) 0 redo size 298 bytes sent via SQL*Net to client 358 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed SQL> select count (*) from l_oper; ?????????? ??????? ? ???????: 1654385????? ??????????: 00:00:00.06???? ??????????---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=185 Card=1) 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'L_OPER' (Cost=185 Card=484111)??????????---------------------------------------------------------- 0 recursive calls 4 db block gets (?????. ?????? ????????? 18879 consistent gets ? ????) 0 physical reads (?????? ? ?????) 0 redo size 371 bytes sent via SQL*Net to client 304 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed

 

[smartq]

Can anyone tell me what the rubblish is? After watching this stuff, my brain become slowly, why?

 

[bi]

Nurlan, no one is going to be able to help you with what you perceive as a problem because no one can read what you have cut and pasted here. And just showing some output from Oracle isn't asking a question or giving anyone anything to go on if you had asked a real question.

 

[RanganathRamachandra]

please post in english