Improve company productivity with a Business Account.Sign Up

x
?
Solved

How to increase log buffer parameter in Oracle 9i

Posted on 2004-04-09
8
Medium Priority
?
2,038 Views
Last Modified: 2011-10-03
I want to increase the my redo buffers size. For that i need to modify the log buffer parameter. But the same is not there in init.ora. Where can i find the parameter and how to increase my redo buffer size?
0
Comment
Question by:pradiptam
6 Comments
 
LVL 11

Expert Comment

by:vc01778
ID: 10790877
1. select * from v$parameter where name like '%log%buffer%'

NUM      NAME      TYPE      VALUE      ISDEFAULT      ISSES_MODIFIABLE      ISSYS_MODIFIABLE      ISMODIFIED      ISADJUSTED      DESCRIPTION      UPDATE_COMMENT
352      log_buffer      3      524288      TRUE      FALSE      FALSE      FALSE      FALSE      redo circular buffer size      

2. If you are using an spfile, then:

alter system set log_buffer=<whatever> scope=spfile

If you are using  a pfile, then edit it (init...ora):

log_buffer=<whatever>

3. Restart Oracle.

VC
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 10791197
Here is my advice for you ( Yes, I understand you want to increase log_buffer)

keep log_buffer set between 1M and 3M , and you are wasting your memory if setting any value above 3M mark.
for reasons, just read up on LGWR behavior (it will flush every 3 secs or 1/3rd of the mem is filledd).



Unless you are doing EXP/IMP , don't change the value....
0
 

Author Comment

by:pradiptam
ID: 10795690
Well i agree to both of your answers but my question is different. I have installed oracle and its working fine. Now I want to increase redo buffer. How to do the same? I am not using spfile and using init.ora. By default it doesn't show the log buffer parameter. Now how do i increase the log buffers?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
LVL 13

Accepted Solution

by:
anand_2000v earned 500 total points
ID: 10796445
log on with
sqlplusw
give sys as sysdba
in the username. press enter and then enter the password.

type in show parameter log_buffer in the SQL prompt. You can see the present value of log_buffer. If this is not present in the init file add it now.
0
 
LVL 11

Assisted Solution

by:vc01778
vc01778 earned 500 total points
ID: 10796945
@pradiptam


Well,  I told you how in my very first message, didnt' I ?

Using an editor add a line like this to your init.ora file:

log_buffer=<size_you_want>

.. and restrat Oracle.

I really do not know what's not clear about that ...

VC
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 10797276
VC is right, if you don't see the log_buffer parameter, don't panic, that's only because you are using the default value.

you can specify it as you like.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question