OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Performance Issue

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

Performance Issue [message #208935]

Tue, 12 December 2006 11:34

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

Report message to a moderator

Re: Performance Issue [message #208937 is a reply to message #208935]

Tue, 12 December 2006 11:37

Mahesh Rajendran
Messages: 10707
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?

Report message to a moderator

Re: Performance Issue [message #208940 is a reply to message #208935]

Tue, 12 December 2006 11:48

dba_blr
Messages: 43
Registered: December 2006

Member

Which operation/queries are performing poorly?

Report message to a moderator

Re: Performance Issue [message #208944 is a reply to message #208940]

Tue, 12 December 2006 12:12

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%.

Report message to a moderator

Re: Performance Issue [message #208945 is a reply to message #208944]

Tue, 12 December 2006 12:15

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Performance Issue [message #208947 is a reply to message #208944]

Tue, 12 December 2006 12:18

Mahesh Rajendran
Messages: 10707
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

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.

Report message to a moderator

Re: Performance Issue [message #208951 is a reply to message #208949]

Tue, 12 December 2006 12:42

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

Report message to a moderator

Re: Performance Issue [message #208952 is a reply to message #208951]

Tue, 12 December 2006 12:48

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Previous Topic:	Timed out trying to start process J002 massage
Next Topic:	Find - Database growth monthwise

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 22:59:36 CDT 2024