log_buffer size in Oracle 10g Rel.2
- From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- To: _oracle_L_list <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 9 Aug 2006 11:56:03 +0300
Hello List,
We have recently upgrade our 9i Rel.2 database to 10g Rel.2, on AIX 5L OS.
We are oftenly getting 'log file sync' and 'log file parallel wait' wait event.
In 9i, we have solved this by enabling CIO to the filesystem.
Surprisingly, the log_buffer size is set to 16M, by default.
We tried to set multiple value, but, by default it takes 16M.
I feel, 16M is very big value for log_buffer.
When I go and search in the metalink, it says, its a bug and
redo_buffer can't be resized, as it depends on no. of datafiles.
Our server has 16cpus and 160 datafiles.
The _log_io_size is 0. Can we play with this hidden parameter to bring
back the redo_buffer size to 3M?
--
Best Regards,
Syed Jaffar Hussain
8i,9i & 10g OCP DBA
Banque Saudi Fransi,
Saudi Arabia
I blog at :http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
