[20250901]x$kglob的kglhdbid字段.txt

--//x$kglob的kglhdbid字段对应的bucket number。简单验证看看：

$ ./lookup.awk kglhd
kglhd : kernel generic library cache management object handle

--//最后的bid 表示 bucket id.

1.环境：
SCOTT@book01p> @ver2
==============================
PORT_STRING                   : x86_64/Linux 2.4.xx
VERSION                       : 21.0.0.0.0
BANNER                        : Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
BANNER_FULL                   : Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
BANNER_LEGACY                 : Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
CON_ID                        : 0
PL/SQL procedure successfully completed.

2.测试：
SCOTT@book01p> select * from dept where deptno=20;

    DEPTNO DNAME                          LOC
---------- ------------------------------ -------------
        20 RESEARCH                       DALLAS

SCOTT@book01p> @ hashz
HASH_VALUE SQL_ID        CHILD_NUMBER KGL_BUCKET HASH_HEX   SQL_EXEC_START      SQL_EXEC_ID
---------- ------------- ------------ ---------- ---------- ------------------- -----------
  95129850 80baj2c2ur47u            0     102650   5ab90fa  2025-09-01 16:46:20    16777216


3.验证：

SYS@book> @ sharepool/shp4 80baj2c2ur47u -1

HANDLE_TYPE            KGLHDADR         KGLHDPAR         C40                                        KGLHDLMD   KGLHDPMD   KGLHDIVC KGLOBHD0         KGLOBHD6           KGLOBHS0   KGLOBHS6   KGLOBT16   N0_6_16        N20   KGLNAHSH KGLOBT03        KGLOBT09
---------------------- ---------------- ---------------- ---------------------------------------- ---------- ---------- ---------- ---------------- ---------------- ---------- ---------- ---------- --------- ---------- ---------- ------------- ----------
child handle address   0000000065DC79E0 0000000065DC9140 select * from dept where deptno=20                0          0          0 0000000065DC7820 0000000065DC8768       8080      20224       3299     31603      31603   95129850 80baj2c2ur47u          0
parent handle address  0000000065DC9140 0000000065DC9140 select * from dept where deptno=20                0          0          0 0000000065DC8F80 00                     4064          0          0      4064       4064   95129850 80baj2c2ur47u      65535

--//我写的脚本查询不包括kglhdbid字段。

SYS@book> @ descv x$kglob kglhdbid
           Name                            Null?    Type
           ------------------------------- -------- ----------------------------
  168      KGLHDBID                                 NUMBER

SYS@book> select kglhdbid,KGLHDADR,KGLHDPAR,kglnaobj c40,KGLNAHSH, KGLOBT03, KGLOBT09 from x$kglob where KGLOBT03='80baj2c2ur47u';

  KGLHDBID KGLHDADR         KGLHDPAR         C40                                        KGLNAHSH KGLOBT03        KGLOBT09
---------- ---------------- ---------------- ---------------------------------------- ---------- ------------- ----------
    102650 0000000065DC79E0 0000000065DC9140 select * from dept where deptno=20         95129850 80baj2c2ur47u          0
    102650 0000000065DC9140 0000000065DC9140 select * from dept where deptno=20         95129850 80baj2c2ur47u      65535
--//与前面hashz脚本的查询结果完全一致(KGL_BUCKET=102650)。

--//手工测试表dept看看：
SYS@book> select kglhdbid,KGLHDADR,KGLHDPAR,kglnaobj c40,KGLNAHSH, KGLOBT03, KGLOBT09 from x$kglob where kglnaobj='DEPT';
  KGLHDBID KGLHDADR         KGLHDPAR         C40                                        KGLNAHSH KGLOBT03        KGLOBT09
---------- ---------------- ---------------- ---------------------------------------- ---------- ------------- ----------
     98828 0000000065DC5080 0000000065DC5080 DEPT                                      249266700                        0

--//表对象dept的KGLHDBID=98828，验证看看。

$ sql_idz.sh "DEPT.SCOTT.BOOK01P\01\0\0\0" 3
sql_text = DEPT.SCOTT.BOOK01P\01\0\0\0
full_hash_value(16) = 05DB243908B3C797B99628590EDB820C or 05db243908b3c797b99628590edb820c
xxxxx_matching_signature(10) = -5073823567219817972 or  13372920506489733644
hash_value(10) = 249266700 or hash_value(16) = 0EDB820C or 0edb820c
sql_id(16) = B99628590EDB820C or b99628590edb820c
sql_id(32) = bm5j8b47dr0hc
sql_id(32) = bm5j8b47dr0hc
sql_id(32) = bm5j8b47dr0hc

--//hash_value(10)=249266700,与KGLNAHSH=249266700一致。
--//249266700 % 2^17 = 98828，也与KGLHDBID=98828对上。