Re: Objects data in SGA

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_at_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_at_T11DB:94> select KSMFSADR from x$ksmfsv where ksmfsnam = 'kcbbktmsk_'; KSMFSADR

SYS_at_T11DB:94> oradebug setmypid
SYS_at_T11DB:94> oradebug dumpvar sga kcbbktmsk_ uword kcbbktmsk_ [06001B9F0, 06001B9F4) = 000000FF

T11DB [oracle_at_OEL ~]$ ps -ef | grep -i LOCAL oracle 3854 1 0 21:32 ? 00:00:00 oracleT11DB (LOCAL=NO) T11DB [oracle_at_OEL ~]$ gdb -p 3854
(gdb) x 0x6001b9f0
0x6001b9f0: 0x000000ff

• Oracle 12.2.0.1 T122DB [oracle_at_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_at_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: _at_OracleSK
Upcoming online seminar: http://tinyurl.com/17-06-13-Shared-Pool-Internals  

> Nikash Kumar <nikashkumar03_at_gmail.com> 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
 

--
http://www.freelists.org/webpage/oracle-l