OraFAQ Forum: Performance Tuning » does it cause any negative impact on performance

Home » RDBMS Server » Performance Tuning » does it cause any negative impact on performance

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

does it cause any negative impact on performance [message #211174]

Wed, 27 December 2006 00:44

sreehari
Messages: 101
Registered: May 2006

Senior Member

Hi all

I have set sga_max_size, sga_target parameters to 950M and
increased the value of log_buffer parameter to 10MB from 7MB seperately. will that cause any performance degradation..

Please clarify on this.

Thanks

Report message to a moderator

Re: does it cause any negative impact on performance [message #211186 is a reply to message #211174]

Wed, 27 December 2006 01:44

seema.taunk
Messages: 96
Registered: October 2006

Member

Hi,

You can generate statspack report for interval of 15 to 30 minutes & check.

Report message to a moderator

Re: does it cause any negative impact on performance [message #211211 is a reply to message #211174]

Wed, 27 December 2006 04:12

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

Senior Member
Account Moderator

>> increased the value of log_buffer parameter to 10MB from 7MB seperately. will that cause any performance degradation..
What is your oracle version?
In most cases log_buffere more 1mb is just a waste.
http://www.orafaq.com/forum/m/167405/42800/?srch=log_buffer#msg_167401

[Updated on: Wed, 27 December 2006 06:58]

Report message to a moderator

Previous Topic:	about sql tuning
Next Topic:	tkprof fetch count

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 01:04:09 CDT 2024