Objects data in SGA
From: Nikash Kumar <nikashkumar03_at_gmail.com>
Date: Thu, 13 Apr 2017 19:07:18 +0530
Message-ID: <CAEdhB7GUxWfRxH0jyCiQW=_rOtZQAxkqNh0nJKeUnbiiv+A4Ww_at_mail.gmail.com>
Hi folks
We were using the following variables from x$ksmfsv table Name Type
kcblhbpseg_ uword
kcbbktmsk_ uword
Date: Thu, 13 Apr 2017 19:07:18 +0530
Message-ID: <CAEdhB7GUxWfRxH0jyCiQW=_rOtZQAxkqNh0nJKeUnbiiv+A4Ww_at_mail.gmail.com>
Hi folks
We were using the following variables from x$ksmfsv table Name Type
kcblhbpseg_ uword
kcbbktmsk_ uword
We were using these variables to compute object details on oracle 11.2.0.4. With the release of Oracle 12cR2 (12.2.0.1), these variables are no longer present in x$ksmfsv (SGA).
On Oracle 11.2.0.4, we could also retrieve these variables from SGA by using the command "oradebug dumpvar sga kcbbktmsk_". But it seems that in Oracle 12.2.0.1, these variable are not present in the SGA. In our
investigation we found that these variables seem to have now moved to a static/global area inside the code. Does anyone know where this information is kept now?
Regards
Nikash Kumar
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 13 2017 - 15:37:18 CEST