Home » RDBMS Server » Performance Tuning » does it cause any negative impact on performance
does it cause any negative impact on performance [message #211174] Wed, 27 December 2006 00:44 Go to next message
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
Re: does it cause any negative impact on performance [message #211186 is a reply to message #211174] Wed, 27 December 2006 01:44 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi,

You can generate statspack report for interval of 15 to 30 minutes & check.
Re: does it cause any negative impact on performance [message #211211 is a reply to message #211174] Wed, 27 December 2006 04:12 Go to previous message
Mahesh Rajendran
Messages: 10672
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:
  


Current Time: Sun Dec 04 04:19:13 CST 2016

Total time taken to generate the page: 0.10158 seconds