Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

improving redo log I/O performance

User_UOVAAOct 17 2013 — edited Oct 28 2013

Hi folks,

I'm using rdbms EE 11.2.0.2 on Solaris 10.

Yesterday, we had a very high usage on our top activities graph in OEM.

I've run addm and one of the recommendations it says is:  "investigate improving the performance of I/O to the online redo log files."

So, what kind of things can be done to improve the performance of the I/O on the online redo logs?

They are already on their own LUN that is striped across 90 drives in our SAN.

The log sizes are sized such that they switch approx. every 45 minutes to an hour.

What else can I consider to do to improve their I/O performance?

We are running the database on an older DL360 G6, with dual quad-core CPUs, using fiber to connect from the HBA cards to the SAN.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 25 2013
Added on Oct 17 2013
#general-database-discussions
12 comments
2,382 views