read by other session
Date: Thu, 3 Dec 2009 08:36:28 -0500
Message-ID: <f30139790912030536u2ecdabc5n9b5a92492f40a154_at_mail.gmail.com>
My interpretation on this is that multiple sessions are trying to read the same block. Oracle can only let 1 person read the same block and makes the other sessions wait. Is this correct?
We have the same queries that regularly run in concurrency. now we are getting performance problems with a wait of "read by other sessions'. My take on it is that now multiple users are running the same query with similiar parameters. Where in the past they may have run the same query, but with different parameters so we did not get read by other session.
when I run the query in sqlplus it returns quickly with minimal read by other session waits, but users in the application frequently have to wait 45 seconds. My take on this is that at the moment I run the query, i am not querying the exact same blocks as other people.
Is that how I interpret read by other sessions? Yes I have traced sessions and AWR, but now I need to interpret my results.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 03 2009 - 07:36:28 CST