Home » RDBMS Server » Server Administration » oracle performance (Oracle 10.2.0.4 AIX 6L )
oracle performance [message #485023] Sun, 05 December 2010 05:43 Go to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member
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

Report message to a moderator

Re: oracle performance [message #485025 is a reply to message #485023] Sun, 05 December 2010 05:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Other session is reading the same block into the cache.

Regards
Michel

[Updated on: Sun, 05 December 2010 05:48]

Report message to a moderator

Re: oracle performance [message #485026 is a reply to message #485025] Sun, 05 December 2010 06:02 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member
So what can be done to improve performance.? Also how to find the hot block which is causing the wait.?

Regards
jay vardhan

Report message to a moderator

Re: oracle performance [message #485031 is a reply to message #485026] Sun, 05 December 2010 07:47 Go to previous message
John Watson
Messages: 8931
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.

Report message to a moderator

Previous Topic: density of the index
Next Topic: Multiple 11g databases
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 11 02:30:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.