Trace a session while it accesses the cache buffer chain latches, etc
From: Michael Cunningham <napacunningham_at_gmail.com>
Date: Tue, 17 Nov 2015 19:47:23 -0800
Message-ID: <CAPt39tuY0UY7BCd+CHD_kZEn-Dcu1Hg7428JA+FqNqPc0zQR7Q_at_mail.gmail.com>
Does anyone know of a way to trace a session after the soft parse to see how it knows where to access blocks on the CBC? I'm starting by assuming the session has to find out where to start by knowing the Data Block Address, but I can't figure out where the session gets that information after the session determines there is a shared cursor it can use.
Date: Tue, 17 Nov 2015 19:47:23 -0800
Message-ID: <CAPt39tuY0UY7BCd+CHD_kZEn-Dcu1Hg7428JA+FqNqPc0zQR7Q_at_mail.gmail.com>
Does anyone know of a way to trace a session after the soft parse to see how it knows where to access blocks on the CBC? I'm starting by assuming the session has to find out where to start by knowing the Data Block Address, but I can't figure out where the session gets that information after the session determines there is a shared cursor it can use.
Any help with me finding the next steps is greatly appreciated.
--
Michael Cunningham
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 18 2015 - 04:47:23 CET