Home » RDBMS Server » Performance Tuning » user I/O and read by other session waits (oracle 10.2.0.3 soalris 10)
user I/O and read by other session waits [message #334952] Fri, 18 July 2008 17:39
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
experts,

my database is experience some performance problem. when i check from OEM i am able to see "active session wait :userI/O"
and read by other session wait event are high.

and when i check for top 5 sql statements and execution plans every thing is taking index scans. i am not able to pin point what could be the exact problem. can any one help to find more information on

active session waits : user I/O and read by other session waits.

how to find the cause of these wait events.
Previous Topic: query tuning
Next Topic: maximum number of process exceeded
Goto Forum:
  


Current Time: Fri Dec 09 17:25:34 CST 2016

Total time taken to generate the page: 0.35359 seconds