| Log buffer [message #63904] |
Mon, 22 November 2004 22:10  |
M. Pallas
Messages: 12
Registered: November 2004
|
Junior Member |
|
|
The Log-buffer value in the initialization file is not reflected on the values stored in V$SGA, or V$SGASTAT. There is no relation - that I could find - between the value in the pfile and the V$SGA value. Oracle docs indicate that the parameter log_buffer sets the size of this buffer. Can someone help? Many Thanks in advance.
M.P
|
|
|
|
| Re: Log buffer [message #63905 is a reply to message #63904] |
Mon, 22 November 2004 23:04  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
If the log_buffer value you specify is less than 4 times the db_block_size Oracle will silently enlarge it to this value.
SQL> select parm "Parameter Value",
2 mem "Memory Value",
3 greatest(mem, 4*blksiz) "Expected Value"
4 from (select value blksiz from v$parameter where name = 'db_block_size'),
5 (select value parm from v$parameter where name = 'log_buffer'),
6 (select value mem from v$sga where name = 'Redo Buffers')
7 /
Parameter Value Memory Value Expected Value
--------------- ------------ --------------
409600 565248 565248
Best regards.
Frank
|
|
|
|
| Re: Log buffer [message #63908 is a reply to message #63904] |
Tue, 23 November 2004 06:01 |
M. Pallas
Messages: 12
Registered: November 2004
|
Junior Member |
|
|
|
I changed the log_buffer parameter to 1 byte and saw no change in values oracle produces when I shut the database and restarted it. This is a test database with db_Block_size of 2048 bytes. The value returned was 77112 much greater than 4 X 2048 which is 8192. the information that you gave me Frank was good to start the diagnostics but still I nned more help. Thank you in advance. M.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
