OraFAQ Forum: Performance Tuning » Performance impact Kernel Parameters

Home » RDBMS Server » Performance Tuning » Performance impact Kernel Parameters (Oracle 9.2.0.8,HP-UX 11.11 ----> Oracle 9.2.0.8, HP-UX 11.23)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Performance impact Kernel Parameters [message #346501]

Mon, 08 September 2008 14:01

vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton

Member

Dear All,

Will there be a Performance impact if the OS Kernel Parameters are not configured properly. I got the binaries and datafiles from a source server and bought the database up and running on the target server.

The Source and Target Hardware configuration is same. The kernel parameters on source and target do not match.

Now i see that the performance on Target is bad when compared to on Source. I know that, there are a lot more things that we need to consider. But my question is, does the kernel parameters play any role in affecting Database performance?

Thanks in Advance,
Vikramjogi

Report message to a moderator

Re: Performance impact Kernel Parameters [message #346517 is a reply to message #346501]

Mon, 08 September 2008 14:52

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>But my question is, does the kernel parameters play any role in affecting Database performance?

Yes. Not just "any". It plays rather "important" role.

Report message to a moderator

Re: Performance impact Kernel Parameters [message #346540 is a reply to message #346517]

Mon, 08 September 2008 16:25

vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton

Member

Thanks Mahesh. I am in the process of figuring out the kernel parameters that are not same on source and target. I will update them to appropriate values.

-Vikramjogi

Report message to a moderator

Re: Performance impact Kernel Parameters [message #346542 is a reply to message #346501]

Mon, 08 September 2008 16:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Just be aware that after making the values the same, you may still have noticeable performance differences.
I am not convinced that the differences between initSID.ora values are the root cause of the slower performance.

Report message to a moderator

Re: Performance impact Kernel Parameters [message #346543 is a reply to message #346542]

Mon, 08 September 2008 16:46

vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton

Member

anacedent,

Thanks for your reply. My initSID.ora on both the systems is alike. I am looking at OS kernel parameters.

-VIkramjogi

Report message to a moderator

Re: Performance impact Kernel Parameters [message #346545 is a reply to message #346501]

Mon, 08 September 2008 16:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Sorry, I was not paying close enough attention.

Noticeable performance differences should be visible when comparing sar data between the 2 systems; assuming they are of similar hardware configuration.

Report message to a moderator

Re: Performance impact Kernel Parameters [message #347108 is a reply to message #346501]

Wed, 10 September 2008 13:56

coleing
Messages: 213
Registered: February 2008

Senior Member

One we always seem to come across is the default number of semaphores on HPUX11 is never enough for our oracle installations and we end up increasing them several times to find the right anount,

Report message to a moderator

Previous Topic:	use of index in performance tuning
Next Topic:	Gather statistics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 22:15:57 CST 2024