[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 。