Home » RDBMS Server » Performance Tuning » Performance Issue
Performance Issue [message #208935] Tue, 12 December 2006 11:34 Go to next message
Alps
Messages: 28
Registered: November 2006
Location: Toronto
Junior Member
My company has added one more CPU to AIX box and now in total 4cpu are there. But now its hitting performance of Database. Anything needs to be done like increasing db_block_buffer size, SGA size or anything that can increase the performance of my system.
thanks
Re: Performance Issue [message #208937 is a reply to message #208935] Tue, 12 December 2006 11:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> But now its hitting performance of Database.
How do you say that?
Did you take statspack/sql trace?
Re: Performance Issue [message #208940 is a reply to message #208935] Tue, 12 December 2006 11:48 Go to previous messageGo to next message
dba_blr
Messages: 43
Registered: December 2006
Member
Which operation/queries are performing poorly?
Re: Performance Issue [message #208944 is a reply to message #208940] Tue, 12 December 2006 12:12 Go to previous messageGo to next message
Alps
Messages: 28
Registered: November 2006
Location: Toronto
Junior Member
I dont know whats hitting the performance but when I see the hit ration of system & session it shows 75% and normally it should be 90%.
Re: Performance Issue [message #208945 is a reply to message #208944] Tue, 12 December 2006 12:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> normally it should be 90%.
Says who?
I recollect a thread started by you where we said
HIT RATIO's are not a measure of performance.
Re: Performance Issue [message #208947 is a reply to message #208944] Tue, 12 December 2006 12:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As dba_blr arelady stated,
the best approach is to isolate the issue/sql/module.
generate statspack report/trace and see what is happening.
Again, HIT RATIO's are not a measure of performance. In most cases is just an accumulated number since the database was re-started. In some cases it may indicated something. But it is NOT a measure of performance.
Regards~

[Updated on: Tue, 12 December 2006 12:21]

Report message to a moderator

Re: Performance Issue [message #208949 is a reply to message #208935] Tue, 12 December 2006 12:33 Go to previous messageGo to next message
dba_blr
Messages: 43
Registered: December 2006
Member
Alps, sometimes the buffer cache hit ratio may be negative because of direct path IO. What will you say then about database performance?

Best approach would be to run statspack to see the bottleneck.
Re: Performance Issue [message #208951 is a reply to message #208949] Tue, 12 December 2006 12:42 Go to previous messageGo to next message
Alps
Messages: 28
Registered: November 2006
Location: Toronto
Junior Member
thank you guys for your help. I am new to this company and even in this field. Do somebody have to documentations to setup statspack for ORACLE 7.3.4.4 .
Thanks really appreciated
Re: Performance Issue [message #208952 is a reply to message #208951] Tue, 12 December 2006 12:48 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>setup statspack for ORACLE 7.3.4.
Something is really up today. This is the 4th case dealing with oracle 7.x Smile
The version is old and de-supported.
Search docs/Google yourself for UTLBSTAT/UTLESTAT.
STATSPACK was not available in those days.
Previous Topic: Timed out trying to start process J002 massage
Next Topic: Find - Database growth monthwise
Goto Forum:
  


Current Time: Sat Dec 07 02:19:41 CST 2024