Home » RDBMS Server » Performance Tuning » LOG_BUFFER - Selects?
LOG_BUFFER - Selects? [message #64884] Wed, 25 February 2004 06:05 Go to next message
Xenofon Grigoriadis
Messages: 33
Registered: May 2002
Member
Hi.

We have performance problems with Ora9 on a Linux cluster. One thing I consider is configuring oracle to run with bigger LOG_BUFFER.

Question: Does the LOG_BUFFER parameter perhaps also influence SELECT-statement performance. What if your use sorts and fill temp-space? What about the dictionaries which have to be kept up to date? Isn't all that being also logged in the redo log?

Thanks in advance for the help.

Grigoriadis
Re: LOG_BUFFER - Selects? [message #64885 is a reply to message #64884] Wed, 25 February 2004 09:39 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
temp extents do not get logged. Data dictionary updates do get logged,but is minimal. In essence,Select performance shouldnt get influenced by log_buffer size directly.

-Thiru
Re: LOG_BUFFER - Selects? [message #64933 is a reply to message #64885] Tue, 09 March 2004 22:38 Go to previous message
bhavin shah
Messages: 11
Registered: November 2003
Junior Member
select statement should not influence by log buffer .and any transaction on the database will log to log buffer..
bhavin
Previous Topic: Covering Index - Execution plan
Next Topic: is tuning necessary or not.
Goto Forum:
  


Current Time: Wed Jan 27 14:19:51 CST 2021