Database Tuning (MOSC)

MOSC Banner

I/O Throughput

edited Jun 24, 2010 9:27PM in Database Tuning (MOSC) 7 commentsAnswered
Hi All,

We are getting the following feedback from ADDM report.

Looking for experts suggestion, Should I need to take any proactive steps on this.

Finding 10: I/O Throughput
Impact is 0 active sessions, 1.02% of total activity.
-----------------------------------------------------
The throughput of the I/O subsystem was significantly lower than expected.

   Recommendation 1: Host Configuration
   Estimated benefit is .01 active sessions, 4.23% of total activity.
   ------------------------------------------------------------------
   Action
      The performance of file +DATA_PREPAID/gsmpredb/dfidxpukmstdata1..dbf was
      significantly worse than other files. If striping all files using the
      SAME methodology is not possible, consider striping this file over
      multiple disks.
      Related Object
         Database file
         "+DATA_PREPAID/gsmpredb/dfidxpukmstdata1..dbf"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center