[20240618]Oracle C functions annotations.txt

[20240618]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 --//例子: $ ./lookup.awk kgllkal kgllkal : kernel generic library cache management library cache lock allocate --//如果是windows系统,如果安装awk了.可以使用如下: D:\tools\ora_functions-master>awk -f lookup.awk kgllkal kgllkal : kernel generic library cache management library cache lock allocate --//我开始以为我直接使用grep直接查询functions.csv文件,实际情况按照层次组织该文件.通过例子说明: D:\tools\ora_functions-master>grep -i  kgllkal functions.csv kgllkal|allocate --//仅仅看到allocate.实际上看lookup.awk 代码,执行如下 D:\tools\ora_functions-master>grep -E "^k\||^kg\||^kgl\||^kgllk\||^kgllkal" functions.csv k|kernel kg|generic kgl|library cache management kgllk|library cache lock kgllkal|allocate --//拚接起来就是如下内容: D:\tools\ora_functions-master>grep -E "^k\||^kg\||^kgl\||^kgllk\||^kgllkal" functions.csv| cut -f2 -d"|" | paste -sd" " kernel generic library cache management library cache lock allocate D:\tools\ora_functions-master>awk -f lookup.awk  -h Usage: ./lookup.awk [-w] <function> <function> = full function name, or part of a function name when used with -w. -w = wildcard, lookup all functions start with <function> --//可以使用-w参数,模糊查询,不过无法使用前缀模糊查询.这个由于函数的组织结构决定的. D:\tools\ora_functions-master>awk -f lookup.awk -w kgllk kgllk : kernel generic library cache management library cache lock kgllkdl : kernel generic library cache management library cache lock delete kgllkds : kernel generic library cache management library cache lock delete state object kgllkal : kernel generic library cache management library cache lock allocate (kgllk)a : kernel generic library cache management library cache lock ?? (kgllk)d : kernel generic library cache management library cache lock ?? --//最后两个为不完整的信息,注意结尾出现的??. D:\tools\ora_functions-master>awk -f lookup.awk  kgllka (kgllk)a : kernel generic library cache management library cache lock ?? --//提示括号内的内容可以查询到kgllk. --//另外注意函数的大小写. $ ./lookup.awk -w kglget kglget : kernel generic library cache management get a lock on an object $ ./lookup.awk -w kglGetMutex kglGetMutex : kernel generic library cache management get mutex --//前者没有找到kglGetMutex. --//如果pstack的执行结果.例子: SCOTT@book> select count(*) from emp,emp,dba_objects,dba_objects ; $ pstack 54305 #0  0x0000000009726543 in qersoFetch () #1  0x000000000970b15d in qerjotFetch () #2  0x000000000256715f in qergsFetch () #3  0x00000000095b5776 in opifch2 () #4  0x0000000001ba5c5d in kpoal8 () #5  0x00000000095bbdad in opiodr () #6  0x00000000097a629f in ttcpip () #7  0x000000000186470e in opitsk () #8  0x0000000001869235 in opiino () #9  0x00000000095bbdad in opiodr () #10 0x00000000018607ac in opidrv () #11 0x0000000001e3a48f in sou2o () #12 0x0000000000a29265 in opimai_real () #13 0x0000000001e407ad in ssthrdmain () #14 0x0000000000a291d1 in main () --//在http://orafun.info/stack/,copy and paste上面内容,显示如下: Parsed stack: Discovered stack type: gdb/pstack stack Parsed gdb/pstack stack: #0 0x0000000009726543 in qersoFetch ()             query execute rowsource sort fetch from from a sort row source #1 0x000000000970b15d in qerjotFetch ()            query execute rowsource nested loop outer join tunneling fetch #2 0x000000000256715f in qergsFetch ()             query execute rowsource group by sort fetch #3 0x00000000095b5776 in opifch2 ()                oracle program interface oracle side of the fetch interface main routine #4 0x0000000001ba5c5d in kpoal8 ()                 kernel programmatic interface oracle V8 bundled execution #5 0x00000000095bbdad in opiodr ()                 oracle program interface oracle code request driver, route the current request #6 0x00000000097a629f in ttcpip ()                 two task common pipe read/write #7 0x000000000186470e in opitsk ()                 oracle program interface two task function dispatcher #8 0x0000000001869235 in opiino ()                 oracle program interface initialize opi #9 0x00000000095bbdad in opiodr ()                 oracle program interface oracle code request driver, route the current request #10 0x00000000018607ac in opidrv ()                oracle program interface route current request driver, entry side into two task interface #11 0x0000000001e3a48f in sou2o ()                 main oracle executable entry point #12 0x0000000000a29265 in opimai_real ()           oracle program interface main real oracle start point #13 0x0000000001e407ad in ssthrdmain ()            operating system dependent system main for every thread in a threaded oracle #14 0x0000000000a291d1 in main ()                  (non oracle)general c starting function --//如果本地操作可以执行如下: D:\tools\ora_functions-master>awk "{print $4}" a.txt | tr -d "\r" | xargs -iQ awk -f lookup.awk Q" qersoFetch : query execute rowsource sort fetch from from a sort row source qerjotFetch : query execute rowsource nested loop outer join tunneling fetch qergsFetch : query execute rowsource group by sort fetch opifch2 : oracle program interface oracle side of the fetch interface main routine kpoal8 : kernel programmatic interface oracle V8 bundled execution opiodr : oracle program interface oracle code request driver, route the current request ttcpip : two task common pipe read/write opitsk : oracle program interface two task function dispatcher opiino : oracle program interface initialize opi opiodr : oracle program interface oracle code request driver, route the current request opidrv : oracle program interface route current request driver, entry side into two task interface sou2o : main oracle executable entry point. reads environment var ORACLE_SPAWNED_PROCESS. opimai_real : oracle program interface main real oracle start point ssthrdmain : operating system dependent system main for every thread in a threaded oracle main : (non oracle)general c starting function --//如果是跟踪文件里面记录的stack信息,可以执行如下: kglLock()+1406<-kglget()+293<-qostobkglcrt1()+498<-qostobkglcrt()+248<-qostobkglcrt2()+412<-qospsis()+2511<-qospPostProcessIStats()+2765<-qerltFetch()+1544<-qerstFetch()+449<-insdlexe()+364<-insExecStmtExecIniEngine()+1810<-insexe()+2283<-atbugi_update_global_indexes()+1656<-atbFMdrop()+3088<-atbdrv()+7719 --//另外保存文件b.txt,执行如下: D:\tools\ora_functions-master>cat b.txt | tr "<-" " \n"  | sed "s/().*$//"| tr -d "\r" | xargs -iQ awk -f lookup.awk Q kglLock : kernel generic library cache management library cache lock kglget : kernel generic library cache management get a lock on an object (qos)tobkglcrt1 : query optimizer statistics ?? (qos)tobkglcrt : query optimizer statistics ?? (qos)tobkglcrt2 : query optimizer statistics ?? qospsis : query optimizer statistics DBMS_STATS.SET_INDEX_STATS_CALLOUT (qos)pPostProcessIStats : query optimizer statistics ?? qerltFetch : query execute rowsource load table fetch qerstFetch : query execute rowsource statistics row source fetch insdlexe : insert direct load execute (ins)ExecStmtExecIniEngine : insert ?? insexe : insert execute (atb)ugi_update_global_indexes : alter table ?? (atb)FMdrop : alter table ?? atbdrv : alter table driver