performance of redo with CIO option on AIX JFS2 filesystem.

From: The Human Fly <sjaffarhussain_at_gmail.com>
Date: Tue, 14 Feb 2006 12:52:10 +0300
Message-ID: <97b7fd2f0602140152g2d6ddf70gec4d383a83d9a05f@mail.gmail.com>

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."
--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 14 2006 - 03:52:10 CST