Home » RDBMS Server » Performance Tuning » Redo Size doesn't increase more than 260MB (HP-UX 11.23, Oracle 9.2i)
Redo Size doesn't increase more than 260MB [message #412583] Fri, 10 July 2009 01:27 Go to next message
Messages: 1
Registered: July 2009
Location: suwon
Junior Member

My machine has two itanium processors and 20GB Memory on HP rx6600.

so I set parameters in initSID.ora like below.

sga_max_size : 6144m
log_buffer : 536870912(512m)
db_cache_size : 3172m
shard_pool_size : 1024m
java_pool_size : default
large_pool_size : default

However after startup, oracle show current status like this.

Total System Global Area 6443315568 bytes
Fixed Size 733552 bytes
Variable Size 2835349504 bytes
Database Buffers 3338665984 bytes
Redo Buffers 268566528 bytes

sga_max_size, db_cache_size is same with setting value.
but redo buffer is not matched with seeting value.

I don't know why it happens.. please let me know Confused
My boss stresses me Sad
Re: Redo Size doesn't increase more than 260MB [message #412589 is a reply to message #412583] Fri, 10 July 2009 01:45 Go to previous message
Michel Cadot
Messages: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In 9i, sizing log_buffer more than 3-4M is just a waste of RAM as Oracle will never use more.

Previous Topic: Force the optimizer to use the primary key index
Next Topic: Enable 10053 Trace information
Goto Forum:

Current Time: Wed Aug 23 20:19:19 CDT 2017

Total time taken to generate the page: 0.05265 seconds