Upgrade from Solaris 9 to Solaris 10 caused serious performance degradation

After upgrading from Solaris 9 up to Solaris 10 with Oracle 9.2.0.8 we've got performance degradation. %Sys time doubled. Database has almost 70% writes , very intensive application. Smth about 100G SGA . 278 G phys mem and 136 CPU-s on SF25K.

Everything is bad. Coming back to the old Solaris 9 just now ...

The night is gone...

.........Now we run again on Solaris 9 118558-28 kernel patch. Everything is quite right! %Sys time is normal again. The server is under heavy load but the database feels ok itself.

The bad configuration was Solaris 10 11/06 125100-09 with the latest patchset + SunCluster 3.2 + Oracle 9.2.0.8

What is the problem? All the system parameters were copied from /etc/system and transferred to Solaris 10

Regards, Pavel

[790 byte] By [PavelTsvetkova] at [2007-11-27 8:31:45]

«« file not found exception
»» Mutiterabyte file system

# 1

> What is the problem? All the system parameters were

> copied from /etc/system and transferred to Solaris

> 10

That may well be the problem then. Some /etc/system parameters may well inhibit Solaris 10. You'll need to provide a list of what parameters you are copying over and see if anyone can spot which one might be causing the problem.

You still haven't said whether the database is on the file system or raw disk, whether it is HA Oracle or 9i RAC.

Regards,

Tim

Tim.Reada at 2007-7-12 20:27:21 >

top of Java-index,Solaris Operating System,Solaris Essentials - General Technical Questions...

# 2

Hi Tim!

This is the Oracle HA cluster on raw vxvm devices. I think this problem may be related to the /etc/system parameters. But the parameters are the same. Only some default values may be changed. The Solaris 10 has higher default values. But it can hardly lead to any serious problems..

PavelTsvetkova at 2007-7-12 20:27:21 >

# 3

So, I would suspect that it is almost certainly something to do with the /etc/system parameters or some new bug we've not seen. I expect it is more likely to be the former.What /etc/system parameters do you have set?Tim

Tim.Reada at 2007-7-12 20:27:21 >

# 4

Hi, Tim!Could you give me your e-mail? I could give you some details from my box hastart@yandex.ruBest regardsPavel

PavelTsvetkova at 2007-7-12 20:27:21 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Upgrade from Solaris 9 to Solaris 10 caused serious performance degradation

Solaris Operating System Hot Topic

Solaris Operating System

All Classified