Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SGA_TARGET and LOG_BUFFER

538022Feb 19 2007 — edited Feb 28 2007
Hello guys,
i am a little bit confused about setting sga_target and sizing log_buffer manually.

At first the documentation:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams192.htm#sthref792

The following pools are manually sized components and are not affected by Automatic Shared Memory Management:
* Log buffer
* Other buffer caches, such as KEEP, RECYCLE, and other block sizes
* Fixed SGA and other internal allocations


Ok.. now my Oracle 10gR2 database:
- spfile:
-----------------------------------------------------------------
*.log_buffer=1048576
*.sga_target=3154116608
-----------------------------------------------------------------

Ok now in my opinion, the log_buffer should not be changed by oracle AMM.
So lets have a look:

SQL> show parameter log_buffer
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_buffer integer 14254080


SQL> show sga
Total System Global Area 3154116608 bytes
Fixed Size 2074600 bytes
Variable Size 603981848 bytes
Database Buffers 2533359616 bytes
Redo Buffers 14700544 bytes

Oh ok.... why does oracle change my manually sized value log_buffer from 1MB up to 14MB!!! (have a look at the output of show sga!)

Hmm and now?
What is right and what is wrong?

Maybe someone can clear the confusion...

Thanks and Regards
Stefan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2007
Added on Feb 19 2007
9 comments
8,115 views