Hy!

We got the same datamodell on Solaris and on WindowsXP. But there is a mojor
difference in the Performance. The database on Windows is much faster than
the one on Solaris although the Solaris machine is a dual processor. The
initialization parameters are also correct, I hope so (like db_block_size
rtc.). Does anyone have the same problem or know what can be the reason of
this performance lack?

Solaris Version:
Machine hardware: sun4u
OS version: 5.9
Processor type: sparc
Hardware: SUNW,Sun-Fire-V250

Hi

Begin with tuning the kernel parameters in Solaris for oracle
otherwise it will be slow because it allocates memory to SGA from
there and after changing the parameters reboot the system. Secondly,
set the db_block_size = 8K in solaris machine.

I hope after making these changes it will be much faster than windows
machine.
If you face further problem mail me at sameer_rawal (AT) cms (DOT) com
Sameer










"Putz Ronald" <rputz (AT) etm-ag (DOT) com> wrote