[20241113]建立显示某个内存段的通用脚本disp_addr.sh.txt

--//该工具仅仅建议在测试环境学习使用。

$ cat disp_addr.sh
#/bin/bash
# display address information
# arg1=address arg2=offset arg3=length arg4=format

offset=${2:-0}
length=${3:-8}
format=${4-wx}

if [ "$format" == "s" ] ; then
        len=1
fi
if [ "$format" == "S" ] ; then
        format="s"
fi

gdb -q -batch -p $(pgrep -f ora_mmon_${ORACLE_SID}) -ex "x/${length}${format} 0x${1}+0x${offset}" -ex "quit" |  grep "^0x" | grep -v "^0x0"

--//简单介绍正常wx格式显示。如果以字符串输出，输入s(小写)时，长度等于1.输入S(大写)，改成小写，不修改length值。

SCOTT@book01p> select * from dept where deptno=40;
    DEPTNO DNAME                          LOC
---------- ------------------------------ -------------
        40 OPERATIONS                     BOSTON

SCOTT@book01p> @ hash
HASH_VALUE SQL_ID        CHILD_NUMBER KGL_BUCKET PLAN_HASH_VALUE HASH_HEX   SQL_EXEC_START      SQL_EXEC_ID
---------- ------------- ------------ ---------- --------------- ---------- ------------------- -----------
3912471479 14ymr4znm74xr            0     103351      2852011669  e93393b7  2024-11-14 09:18:39    16777216

SYS@book> @ sharepool/shp4p 14ymr4znm74xr 0
SYS@book> @ pr
==============================
HANDLE_TYPE                   : parent handle address
KGLHDADR                      : 0000000062B283D0
KGLHDPAR                      : 0000000062B283D0
C40                           : select * from dept where deptno=40
KGLHDLMD                      : 0
KGLHDPMD                      : 0
KGLHDIVC                      : 0
KGLOBHD0                      : 0000000062B28210
KGLOBHD6                      : 00
KGLOBHS0                      : 4064
KGLOBHS6                      : 0
KGLOBT16                      : 0
N0_6_16                       : 4064
N20                           : 4064
KGLNAHSH                      : 3912471479
KGLOBT03                      : 14ymr4znm74xr
KGLOBT09                      : 65535
PL/SQL procedure successfully completed.
--//KGLHDPAR : 0000000062B283D0

$ ./disp_addr.sh 0000000062B283D0 1c8 1 s
0x62b28598:     "select * from dept where deptno=40"

--//如果不知道偏移可以这样写。
SYS@book> @ fchaz 0000000062B283D0
LOC KSMCHPTR           KSMCHIDX   KSMCHDUR KSMCHCOM           KSMCHSIZ KSMCHCLS   KSMCHTYP KSMCHPAR         KSMCHPTR_BEGIN   KSMCHPTR_END+1
--- ---------------- ---------- ---------- ---------------- ---------- -------- ---------- ---------------- ---------------- -----------------
SGA 0000000062B283A0          1          1 KGLHD                   816 recr             80 00               0000000062B283A0 0000000062B286D0
--//该chunk占用818字节。

$ ./disp_addr.sh 0000000062B283D0 0 816 S | grep -i select
0x62b28598:     "select * from dept where deptno=40"

--//0x62b28598-0x0000000062B283D0 = 0x1c8,偏移在0x1c8位置。
--//带入816越界没有问题。

--//前面@hash的输出KGL_BUCKET=103351
SYS@book> oradebug setmypid
Statement processed.
SYS@book> oradebug dump library_cache 4;
Statement processed.
SYS@book> @ t
TRACEFILE
--------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/book/book/trace/book_ora_3719.trc

$ grep 103351 /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_3719.trc
Bucket: #=103351 Mutex=0x7309f5c0(639950127104, 11, 0, 6)
--//mutex地址在0x7309f5c0。

$ ./disp_addr.sh 7309f5c0 0 6 wx
0x7309f5c0:     0x00000000      0x00000000      0x0000000b      0x00000000
0x7309f5d0:     0x000193b7      0x00000000
--//gets=0xb.
--//0x000193b7 = 103351,等于KGL_BUCKET值。

$ ./disp_addr.sh 7309f5b0 0 8 wx
0x7309f5b0:     0x62b283d0      0x00000000      0x62b283d0      0x00000000
0x7309f5c0:     0x00000000      0x00000000      0x0000000c      0x00000000
--//0x62b283d0就是该sql语句父游标句柄地址。

SCOTT@book01p> select * from dept where deptno=40;
    DEPTNO DNAME                          LOC
---------- ------------------------------ -------------
        40 OPERATIONS                     BOSTON

$ ./disp_addr.sh 7309f5b0 0 12 wx
0x7309f5b0:     0x62b283d0      0x00000000      0x62b283d0      0x00000000
0x7309f5c0:     0x00000000      0x00000000      0x0000000d      0x00000000
0x7309f5d0:     0x000193b7      0x00000000      0x62820b38      0x00000000
--//gets=0xd.增加1.
--//每执行1次查看1次。

$ ./disp_addr.sh 7309f5b0 0 12 wx
0x7309f5b0:     0x62b283d0      0x00000000      0x62b283d0      0x00000000
0x7309f5c0:     0x00000000      0x00000000      0x0000000e      0x00000000
0x7309f5d0:     0x000193b7      0x00000000      0x62820b38      0x00000000

$ ./disp_addr.sh 7309f5b0 0 12
0x7309f5b0:     0x62b283d0      0x00000000      0x62b283d0      0x00000000
0x7309f5c0:     0x00000000      0x00000000      0x0000000e      0x00000000
0x7309f5d0:     0x000193b7      0x00000000      0x62820b38      0x00000000
--//光标缓存后gets不在增加。