Re: performance of redo with CIO option on AIX JFS2 filesystem.
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: sjaffarhussain@xxxxxxxxx, panandrao@xxxxxxxxx
- Date: Tue, 14 Feb 2006 03:12:10 -0800 (PST)
to use cio you have to have your filesystemio_options set to setall
we are actualy use this in our oltp environments with great success. but
again esting is really very important.
ibm fas a complete document on performance options with cio and 9i.
you can find it on their website
Fuad
The Human Fly <sjaffarhussain@xxxxxxxxx> wrote:
Oracle 9i Rel2. (9205).
This is bug is not the issue. This was cleared by Oracle support in the TAR.
On 2/14/06, Anand Rao
wrote:
> Hi,
>
> any idea what version of Oracle that you are using :-)
>
> thanks for the info...
>
> well, there is a lot of debate on 'log file sync' and 'log file parallel
> write' and there is timing bug too. Look at BUG: 2669566.
>
> look at http://www.jlcomp.demon.co.uk/log_file_writes.html
>
> also, what was your setting for disk_async_io, filesystemio_options and
> _lgwr_async_io?
>
> did you modify any of these?
>
> thanks
>
> anand
>
>
> On 14/02/06, The Human Fly wrote:
> >
> > Hello list,
> >
> > Today we have a light smile on our face because we were struggling
> > with log file sync event on one of our business critical database. We
> > opened a TAR and implemented everything they have suggested.
> > Yesterday, we made litte changes, like, created a new mountpoint
> > enabling CIO (concurrent I/O) on AIX 5.3 using JFS2 filesystem, and
> > move our redo groups to this new mount point also increased the size
> > of redo groups from 512M to 1gb.
> > When we look at the log file sysn event in the statspack, it was just
> > vanished. Earlier, we used to get 40% as log file synce in the top
> > timed events and now it is just 3%. Its really a drastic change in the
> > wait event.
> > Now, I am planning to do the same for our datafiles, i.e. enabling cio
> > and moving the tablespace to new moutn point. Redo has only inserts,
> > but, for tables, we have read and write, does this can improve the
> > throughput? Will there be any performance gain? Does anyone using this
> > kind of option with JFS2 filesystem?
> >
> > Thanks for your time.
> >
> > --
> > Best Regards,
> > Syed Jaffar Hussain
> > 8i,9i & 10g, OCP DBA
> > Banque Saudi Fransi,
> > Saudi Arabia
> > http://jaffardba.blogspot.com/
> >
> ----------------------------------------------------------------------------------
> > "Winners don't do different things. They do things differently."
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
--
Best Regards,
Syed Jaffar Hussain
8i,9i & 10g, OCP DBA
Banque Saudi Fransi,
Saudi Arabia
http://jaffardba.blogspot.com/
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
