oracle performance [message #485023] |
Sun, 05 December 2010 05:43 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dba_7722
Messages: 197 Registered: August 2010 Location: Delhi
|
Senior Member |
![jayvardhancs](/forum/theme/orafaq/images/google.png)
|
|
Dear Experts,
While investigating for performance issue, i found number of Oracle session looking for wait event "read by other session".
Please explore this event with effective solution.
Regards,
Jay vardhan
|
|
|
|
|
Re: oracle performance [message #485031 is a reply to message #485026] |
Sun, 05 December 2010 07:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
The columns p1 and p2 in gv$session_wait give you the file and block number on which the wait is occurring. You'll need to join to dba_extents to find the segment.
|
|
|