Hey Kumar,
yes, the variable has become an external object with 12.2.0.1. Maybe this
provides the needed information.
-- Oracle 11.2.0.3.6
T11DB [oracle@OEL ~]$ readelf -s $ORACLE_HOME/bin/oracle | grep -i kcbbktmsk
31657: 000000006001b9f0 0 NOTYPE GLOBAL DEFAULT ABS kcbbktmsk_
704178: 000000006001b9f0 0 NOTYPE GLOBAL DEFAULT ABS kcbbktmsk_
SYS@T11DB:94> select KSMFSADR from x$ksmfsv where ksmfsnam = 'kcbbktmsk_';
KSMFSADR
----------------
000000006001B9F0
SYS@T11DB:94> oradebug setmypid
SYS@T11DB:94> oradebug dumpvar sga kcbbktmsk_
uword kcbbktmsk_ [06001B9F0, 06001B9F4) = 000000FF
T11DB [oracle@OEL ~]$ ps -ef | grep -i LOCAL
oracle 3854 1 0 21:32 ? 00:00:00 oracleT11DB (LOCAL=NO)
T11DB [oracle@OEL ~]$ gdb -p 3854
(gdb) x 0x6001b9f0
0x6001b9f0: 0x000000ff
-- Oracle 12.2.0.1
T122DB [oracle@OEL ~]$ readelf -s $ORACLE_HOME/bin/oracle | grep -i kcbbktmsk
47242: 0000000011365be8 8 OBJECT GLOBAL DEFAULT 17 kcbbktmsk_
232446: 0000000011365be8 8 OBJECT GLOBAL DEFAULT 17 kcbbktmsk_
T122DB [oracle@OEL ~]$ gdb $ORACLE_HOME/bin/oracle
(gdb) x 0x11365be8
0x11365be8 <kcbbktmsk_>: 0x000008fc
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: @OracleSK
Upcoming online seminar: http://tinyurl.com/17-06-13-Shared-Pool-Internals
Nikash Kumar <nikashkumar03@xxxxxxxxx> hat am 13. April 2017 um 15:37
geschrieben:
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