[20241016]Oracle C functions annotations补充.txt

[20241016]Oracle C functions annotations补充.txt

–//网站orafun.info可以查询oracle c functions.Created by Frits Hoogland with a little help from Kamil Stawiarski.

–//可以通过它了解oracle 内部C 函数.实际上可以直接下载相关文件,在本地使用.

https://gitlab.com/FritsHoogland/ora_functions/archive/master/ora_functions-master.tar.gz

https://gitlab.com/FritsHoogland/ora_functions

$ ll

total 12828

-rwxrwxr-x. 1 oracle oinstall     1035 2021-01-29 22:06:05 annotate_flamegraph.awk

-rwxrwxr-x. 1 oracle oinstall     2439 2021-01-29 22:06:05 fold_debugtrace.awk

-rw-rw-r–. 1 oracle oinstall   348445 2021-01-29 22:06:05 functions.csv

-rw-r–r–. 1 oracle oinstall   418816 2024-10-16 09:50:45 functions.db

-rwxrwxr-x. 1 oracle oinstall     1630 2021-01-29 22:06:05 lookup.awk

-rwxr-xr-x. 1 oracle oinstall     1660 2024-10-16 09:58:54 lookupx.awk

-rw-rw-r–. 1 oracle oinstall     1679 2021-01-29 22:06:05 readme.md

-rwxrwxr-x. 1 oracle oinstall     3474 2021-01-29 22:06:05 sf.sh

-rw-rw-r–. 1 oracle oinstall 12231272 2021-01-29 22:06:05 symbol_archive_object_19.9.csv

-rw-rw-r–. 1 oracle oinstall    32650 2021-01-29 22:06:05 v_tables_x_tables_mapping.csv

-rw-rw-r–. 1 oracle oinstall    66350 2021-01-29 22:06:05 x_tables_descriptions.csv

–//实际上还有1个sf.sh脚本，它需要本机安装sqlite3。

$ grep ^sqlite3 sf.sh

sqlite3 functions.db “drop table if exists functions;”

sqlite3 functions.db “create table functions (function_name varchar(30), function_sum varchar(60));”

sqlite3 functions.db “.import functions.csv functions”

–//手工执行它后可以建立建立导入表functions。functions.db就是执行脚本sf.sh后建立的文件。

–//注意：你执行完1次后，可以注解前面的这3行.

$ ./sf.sh kgllkal

kgllkal — kernel generic library cache management library cache lock allocate

——-

–//不过显示与lookup.awk不同。

$ ./lookup.awk -w   kglpn

kglpn : kernel generic library cache management pin

kglpnal : kernel generic library cache management pin allocate

kglpnc : kernel generic library cache management pin pin heaps and load data pieces of a cursor object

kglpnck : kernel generic library cache management pin pin heaps and load data pieces of a cursor object check if latch is held

kglpndl : kernel generic library cache management pin delete data heaps

kglpnds : kernel generic library cache management pin delete state object

kglpnmi : kernel generic library cache management pin migration

kglpnp : kernel generic library cache management pin pin heaps and load data for stored procedures

$ ./sf.sh -w   kglpn

kglpn   pin

kglpnal allocate

kglpnc  pin heaps and load data pieces of a cursor object

kglpnck check if latch is held

kglpndl delete data heaps

kglpnds delete state object

kglpnmi migration

kglpnp  pin heaps and load data for stored procedures

–//还有2个文件。

$ ll *table*

-rw-rw-r–. 1 oracle oinstall 32650 2021-01-29 22:06:05 v_tables_x_tables_mapping.csv

-rw-rw-r–. 1 oracle oinstall 66350 2021-01-29 22:06:05 x_tables_descriptions.csv

–//可以直接使用grep查询：

$ grep -i kglob x_tables_descriptions.csv

X$KGLOB|kernel generic library cache object

X$KGLOBXML|kernel generic library cache object xml (version of x$kglob)

–//oracle 的X表都是大写。加入-i或者直接大写。

$ grep -i ‘x$kglob’ x_tables_descriptions.csv

X$KGLOB|kernel generic library cache object

X$KGLOBXML|kernel generic library cache object xml (version of x$kglob)

–//如果查询带有$字符，要加入单引号。

–//也可以修改lookup.awk文件，修改文件名实现查询。

$ diff -Nur lookup.awk lookupx.awk

— lookup.awk  2021-01-29 22:06:05.000000000 +0800

+++ lookupx.awk 2024-10-16 09:58:54.461069120 +0800

@@ -33,14 +33,14 @@

     exit 1

   }

   if ( ARGV[1] == “-w” ) {

–    requested_function = ARGV[2];

+    requested_function = toupper(ARGV[2]);

   } else {

–    requested_function = ARGV[1];

+    requested_function = toupper(ARGV[1]);

   }

   # load functions from csv into array

   PROCINFO[“sorted_in”] = “@ind_str_asc”;

   FS=”|”;

–  while ( ( getline < “functions.csv” ) > 0 ) function_array[$1]=$2;

+  while ( ( getline < “x_tables_descriptions.csv” ) > 0 ) function_array[$1]=$2;

   # lookup function annotation starting with <function>

   if ( ARGV[1] == “-w” ) {

     for ( function_from_array in function_array )

$ ./lookupx.awk   ‘x$kglob’

X$KGLOB : kernel generic library cache object

–//这个的查询特点一定要带单引号，还是grep方便。

$ grep -i alert x_tables_descriptions.csv

X$DBGALERTEXT|debug alert extended information

X$DIAG_ALERT_EXT|diagnostics alert extended. database alert log details

X$KELRSGA|kernel event alert SGA

X$KELRTD|kernel event alert threshold type descriptions

X$KELTGSD|kernel event alert types generator descriptions

X$KELTOSD|kernel event alert types operations descriptions

X$KELTSD|kernel event alert types descriptions

X$KXDCM_OPEN_ALERTS|kernel execution exadata cell metrics open alerts

–//查询v_tables_x_tables_mapping.csv可以知道一些对应关系,不过好像不全。

$ grep -i ir_failure v_tables_x_tables_mapping.csv

GV$IR_FAILURE|X$DBKFDG

GV$IR_FAILURE_SET|X$DBKFSET

$ grep -i ‘^GV$SESSION|’ v_tables_x_tables_mapping.csv

GV$SESSION|X$KSUSE

–//仅仅看到1个X表,实际上关联 x$ksuse , x$ksled , x$kslwt 。