OraFAQ Forum: Performance Tuning » LOG_BUFFER

Home » RDBMS Server » Performance Tuning » LOG_BUFFER - Selects?

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

LOG_BUFFER - Selects? [message #64884]

Wed, 25 February 2004 06:05

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

Report message to a moderator

Re: LOG_BUFFER - Selects? [message #64885 is a reply to message #64884]

Wed, 25 February 2004 09:39

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

Report message to a moderator

Re: LOG_BUFFER - Selects? [message #64933 is a reply to message #64885]

Tue, 09 March 2004 22:38

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

Report message to a moderator

Previous Topic:	Covering Index - Execution plan
Next Topic:	is tuning necessary or not.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 06 10:12:29 CST 2025