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)
icon5.gif  Performance impact Kernel Parameters [message #346501] Mon, 08 September 2008 14:01 Go to next message
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
Re: Performance impact Kernel Parameters [message #346517 is a reply to message #346501] Mon, 08 September 2008 14:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Performance impact Kernel Parameters [message #346540 is a reply to message #346517] Mon, 08 September 2008 16:25 Go to previous messageGo to next message
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
Re: Performance impact Kernel Parameters [message #346542 is a reply to message #346501] Mon, 08 September 2008 16:32 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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.
Re: Performance impact Kernel Parameters [message #346543 is a reply to message #346542] Mon, 08 September 2008 16:46 Go to previous messageGo to next message
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
Re: Performance impact Kernel Parameters [message #346545 is a reply to message #346501] Mon, 08 September 2008 16:54 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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.
Re: Performance impact Kernel Parameters [message #347108 is a reply to message #346501] Wed, 10 September 2008 13:56 Go to previous message
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,
Previous Topic: use of index in performance tuning
Next Topic: Gather statistics
Goto Forum:
  


Current Time: Sat Dec 03 07:52:15 CST 2016

Total time taken to generate the page: 0.05594 seconds