How to Identify Hot Objects for "dbms_shared_pool.markhot" after Oracle Database 12cR2?

Hi,

With 12cR2, there are some modifications for X$KGLOB table.

The columns KGLOBT23 was replaced with "KGLOBLCT" and  KGLOBT24 was replaced with "KGLOBPCT".

So, you can use the following query to identify hot objects then you can mark them with dbms_shared_pool package.

select *

  from (Select case

                 when (kglhdadr = kglhdpar) then

                  'Parent'

                 else

                  'Child ' || kglobt09

               end cursor,

               kglhdadr ADDRESS,

               substr(kglnaobj, 1, 20) name,

               kglnahsh hash_value,

               kglobtyd type,

               KGLOBLCT LOCKED_TOTAL,

               KGLOBPCT PINNED_TOTAL,

               kglhdexc EXECUTIONS,

               kglhdnsp NAMESPACE

          from x$kglob

         order by KGLOBPCT desc)

 where rownum <= 20