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