Oracle call stack / function name explanations found on the web Tip: When search for a function, add phrase "executable entry point". Doc ID 416823.1: ktprbeg, kturax, functions associated to transaction rollback. Bug:2437416 kcbbnwa The function which calculates the number of dbwr's is kcbbnwa() Bug:3188544 kksalc kksalc() - ALlocate Compile time memory. k2udio ? Module Notes: k2u.c - Kernel 2 phase commit message Unmarshalling ddfnetCFull ddfnet3Share kksarm Authorize for remote. kksauc KKSA: Authorized to Use this Child? kksscl KKS: scan child list? kksfbc KKS: Find Bound Cursor kkspsc0 opiosq0 opiall0 ARGSUSED */ opikpr opikpr.c - opiodr OPIODR: ORACLE code request driver - route the current request rpidrus RPI: Recursive program handling (unclear) skgmstack skgmstack - call specified function with extra STACK space rpidru RPI: setup memory for the recursive session (unclear) rpiswu2 RPI: SWitch User in recursive sql kprball kprball - execute ALL bundled KPR (RPI) operations */ kkzfrdesc kkzfrf kkzfrsh kkzifr3g spefcmpa spefmccallstd peftrusted psdexsp All Private Routines * rpiswu2 RPI: SWitch User in recursive sql psdextp The only public routine, the actual PSD * pefccal pefcal pfrrun PSDEVN: PL/SQL Interpreter Main Instruction Loop peicnt PL/SQL controlled Execution kkxexe KKX: execute plsql opiexe opiexe - ORACLE Program Interface EXEcute opiall0 ARGSUSED */ kpoal8 kpoal8.c - Kernel Programmatic Oracle ALl Version 8 opiodr OPIODR: ORACLE code request driver - route the current request ttcpip TTCPIP: Two Task Common PIPe read/write opitsk opitsk - Two Task Oracle Side Function Dispatcher opiino opiino - ORACLE Program Interface INitialize Opi opiodr OPIODR: ORACLE code request driver - route the current request opidrv # opidrv - ORACLE Program Interface DRiVer (IGNORE) sou2o # Main Oracle executable entry point main # Standard executable entry point start # C program entry point (IGNORE) Bug No. 5309290 Summary Stack (to Full stack) (to Function List) ------------- ksmasg Callback function for allocating an SGA extent. The SGA is fixed size kghnospc KGH: There is no space available in the heap, signal an error. kghalp KGH: Allocate permanent memory kghssgai kghssgai - SeGmented ALlocation Internal kgghteInit kggmsInitMapService qksshBeginCompile opiprs opiprs - ORACLE Program Interface: PaRSe kksParseChildCursor rpiswu2 RPI: SWitch User in recursive sql kksLoadChild kglobld KGL2: OBject LoaD kglobpn KGL2: OBject PiN heaps and load data pieces kglpim KGL: PIn and load More heaps kglpin KGL: PIN heaps and load data pieces of an object kksfbc KKS: Find Bound Cursor kkspsc0 kksParseCursor opiosq0 opiall0 ARGSUSED */ opikpr opikpr.c - opiodr OPIODR: ORACLE code request driver - route the current request rpidrus RPI: Recursive program handling (unclear) skgmstack skgmstack - call specified function with extra STACK space Bug:1485944 < Function:KSEDMP> dump the process state */ < Function:KSDPCG> Post and check event in the specified event group. Returns TRUE if. an event trace was found, or if < Function:KSDPEC> Post Event and Check trigger condition: A check is made for trigger conditions associated < Function:KSFPEC> ARGSUSED */ < Function:KSFPEC> ARGSUSED */ < Function:kgesec5> UNKNOWN < Function:KGHNOSPC> There is no space available in the heap, signal an error.. < Function:KGHALO> max minimum size of an allocated chunk, 64K minus overhead */. main allocation entry point */ < Function:KSSADF> add object from free list */ < Function:KCBZGS> kcbzgs - get a kcbbf state-object This state object covers local buffer locks (as op < Function:KCBGTCR> Get a block for CR < Function:KTRGTC> ktrgtc - get a read consistent block and call back client. This is faster to use than KTRGET when th < Function:kdiixs1> UNKNOWN < Function:qerixFetchIOTRangeSc>UNKNOWN < Function:qerixFetchIOTRangeSc>UNKNOWN < Function:qersoFetch> UNKNOWN < Function:OPIALL0> ARGSUSED */ < Function:KPOAL8> kpoal8.c - Kernel Programmatic Oracle ALl Version 8. ARGSUSED */ < Function:KPOAL8> kpoal8.c - Kernel Programmatic Oracle ALl Version 8. ARGSUSED */ < Function:OPIODR> opiodr - ORACLE code request driver Copyright (c) 1990, 1995, 1996, 1997 by the Oracle < Function:OPITSK> opitsk - Two Task Oracle Side Functio ksmasg Callback function for allocating an SGA extent. The SGA is fixed size kghnospc KGH: There is no space available in the heap, signal an error. kghalo KGH: main allocation entry point kghxal allocate fixed sized memory kglpnal kglpnal - KGL PiN ALlOcate */ kglpin KGL: PIN heaps and load data pieces of an object kolfgdir KOL File Get DIRectory object, path and FileNames. kolfigl kolflbctx koklcopy KOK Lob COPY. koklcpb2c KOK Lob CoPy Binary data (BFILE/BLOB) into Clob kkxlff2 kkxlcff2 pevm_icd_call_commo pfrrun PSDEVN: PL/SQL Interpreter Main Instruction Loop peicnt PL/SQL controlled Execution kkxexe opiexe opiexe - ORACLE Program Interface EXEcute opiall0 kpoal8 kpoal8.c - Kernel Programmatic Oracle ALl Version 8 opiodr OPIODR: ORACLE code request driver - route the current request kpoodr ttcdrv TTCDRV: called when message received PGOSF67_osnsglw upirtrc kpurcsc KPU Remote Call with ServiceContext, Callbacks kpuexecv8 KPU: Execute V8 kpuexec KPU: Execute OCIStmtExecute OCIStmtExecute - OCI : Execute drsinopen drsxsfetch drgafetch drnafetch drlaftc drepprep perform the document indexing dreb_populate drexpmain PUBLIC FUNCTIONS spefcpfa spefmccallstd pextproc Pefm call EXTernal PROCedure PGOSF233_peftrust psdexsp All Private Routines * rpiswu2 RPI: SWitch User in recursive sql psdextp The only public routine, the actual PSD * pefccal pefcal pevm_FCAL pfrrun PSDEVN: PL/SQL Interpreter Main Instruction Loop peicnt PL/SQL controlled Execution kkxuexe kkxmpexe kgmexwi kgmexec KGM EXECute evapls EVAluate any PLSql function evaopn2 qximeop QXIM Evaluate OPerand qerocisc qerocpStart qerocStart This function creates a collection iterator row-source to iterate rwsstd Start row source rwsstd Start row source qersoStart Start row source selexe SELEXE: prepare context area for fetch opiexe opiexe - ORACLE Program Interface EXEcute kxfxse KXFX: execute kxfxmai server-side main entry point (Bug:4111401 , not needed , the same as above) < Function:qerixFetchIOTRangeSc>UNKNOWN < Function:qerixFetchIOTRangeSc>UNKNOWN < Function:qersoFetch> UNKNOWN < Function:OPIALL0> ARGSUSED */ < Function:KPOAL8> kpoal8.c - Kernel Programmatic Oracle ALl Version 8. ARGSUSED */ < Function:KPOAL8> kpoal8.c - Kernel Programmatic Oracle ALl Version 8. ARGSUSED */ < Function:OPIODR> opiodr - ORACLE code request driver Copyright (c) 1990, 1995, 1996, 1997 by the Oracle < Function:OPITSK> opitsk - Two Task Oracle Side Functio Bug:5584629 Summary Stack (to Full stack) (to Function List) ksedst # KSE: dump the call stack ksedmp # KSE: dump the process state ksddoa # Debug support Do an Action ksdpcg # KSD: Post and check event in the specified event group ksdpec # KSD: Post Event and Check trigger condition PGOSF89__ksfpec kgesev KGE: Signal Error code (with Va_list) kgesec2 qctErr932 qctErrConvertDataType qctodisi qctcopn qctcopn xtyopn XTY: eXpression TYpecheck OPeraNd kkegvl KKE: get a value from an opndef and normalize it for cost estimation kkepsl selectivity of single predicate kkecdn KKE: determine cardinality of a table given single table predicates kkotap KKO: Table Path kkoiqb KKO: Initialize Query Block kkooqb KKO: Optimize Query Block kkoqbc KKO: er... apakkoqb apaqbd DRIVE THE ACCESS PATH ANALYSIS FOR EVERY QUERY BLOCK IN THE COMMAND apadrv DRIVE THE ACCESS PATH SELECTION FOR A SQL COMMAND opitca OPITCA: sets up the context area PGOSF359__kksFull TypeCheck rpiswu2 RPI: SWitch User in recursive sql kksLoadChild kkslod cursor LOaD call-back kglobld KGL2: OBject LoaD kglobpn KGL2: OBject PiN heaps and load data pieces kglpim KGL: PIn and load More heaps kglpin KGL: PIN heaps and load data pieces of an object kxsGetRuntimeLock 1936 kksfbc KKS: Find Bound Cursor opiexe opiexe - ORACLE Program Interface EXEcute kpoal8 kpoal8.c - Kernel Programmatic Oracle ALl Version 8 opiodr OPIODR: ORACLE code request driver - route the current request ttcpip TTCPIP: Two Task Common PIPe read/write opitsk opitsk - Two Task Oracle Side Function Dispatcher opiino opiino - ORACLE Program Interface INitialize Opi opiodr OPIODR: ORACLE code request driver - route the current request opidrv # opidrv - ORACLE Program Interface DRiVer (IGNORE) sou2o # Main Oracle executable entry point opimai_real opimai OracleThreadStart@ Bug:3412924 kmdmai main loop for dispatcher Bug:3249539 ksedmp # KSE: dump the process state ssexhd # ** DUMP ROUTINE - IGNORE stuff above this on the stack ** 0000480C poll ntevpque ntevque nsevwait NS EVent WAIT: wait for event notification on all registered connections; ksnwait ksliwat KSL: Latching: Awaken a wait event kslwaitns kskthbwt kslwait Wait for N centi-seconds or until posted ksuclnwt KSUCLN: Wait for specified time in seconds ksucln KSUCLN: Cleanup detached process ksbrdp KSB: run a detached (background) process opirip # Oracle Program Interface Run Independent Process (IGNORE) opidrv # opidrv - ORACLE Program Interface DRiVer (IGNORE) sou2o # Main Oracle executable entry point main # Standard executable entry point start # C program entry point (IGNORE) Bug:4048683 ksedmp # KSE: dump the process state ksedmp_tracecb ksddoa # Debug support Do an Action ksdpcg # KSD: Post and check event in the specified event group ksdpec # KSD: Post Event and Check trigger condition ksfpec # KSF: Post an event?? kgesev KGE: Signal Error code (with Va_list) ksesec3 ksmnsi Notifier SGA/PGA initialize routine. Actually return a pointer to the kmcnfy KMC: Notification routine kscnfy KSC: Procedure to cause notifications be passed to components. ksmcsg KSM: Memory handling: Create SGA. opistr_real opistr opiodr OPIODR: ORACLE code request driver - route the current request ttcpip TTCPIP: Two Task Common PIPe read/write opitsk opitsk - Two Task Oracle Side Function Dispatcher opiino opiino - ORACLE Program Interface INitialize Opi opiodr OPIODR: ORACLE code request driver - route the current request opidrv # opidrv - ORACLE Program Interface DRiVer (IGNORE) sou2o # Main Oracle executable entry point kghalo KGH: main allocation entry point kghnospc KGH: There is no space available in the heap, signal an error ksddoa # Debug support Do an Action ksdpcg # KSD: Post and check event in the specified event group ksdpec # KSD: Post Event and Check trigger condition PGOSF89__ksfpec kgesev KGE: Signal Error code (with Va_list) tyopn XTY: eXpression TYpecheck OPeraNd kkegvl KKE: get a value from an opndef and normalize it for cost estimation kkepsl selectivity of single predicate kkecdn KKE: determine cardinality of a table given single table predicates kkotap KKO: Table Path kkoiqb KKO: Initialize Query Block kkooqb KKO: Optimize Query Block kkoqbc KKO: er... apakkoqb apaqbd DRIVE THE ACCESS PATH ANALYSIS FOR EVERY QUERY BLOCK IN THE COMMAND apadrv DRIVE THE ACCESS PATH SELECTION FOR A SQL COMMAND opitca OPITCA: sets up the context area PGOSF359__kksFull TypeCheck rpiswu2 RPI: SWitch User in recursive sql kksLoadChild kkslod cursor LOaD call-back kglobld KGL2: OBject LoaD kglobpn KGL2: OBject PiN heaps and load data pieces kglpim KGL: PIn and load More heaps kglpin KGL: PIN heaps and load data pieces of an object kxsGetRuntimeLock 1936 kksfbc KKS: Find Bound Cursor opiexe opiexe - ORACLE Program Interface EXEcute kpoal8 kpoal8.c - Kernel Programmatic Oracle ALl Version 8 opiodr OPIODR: ORACLE code request driver - route the current request ttcpip TTCPIP: Two Task Common PIPe read/write opitsk opitsk - Two Task Oracle Side Function Dispatcher opiino opiino - ORACLE Program Interface INitialize Opi opiodr OPIODR: ORACLE code request driver - route the current request opidrv # opidrv - ORACLE Program Interface DRiVer (IGNORE) sou2o # Main Oracle executable entry point Bug:2097180 * Wait interrupt-ably for the given number of < Function:KSLIWAT> KSL: Latching: Awaken a wait event < Function:KSLWAIT> Wait for N centi-seconds or until posted Arguments: (time_in_10_msecs, reason, id, p1, p2, < Function:KMCCVC> KMC: Create virtual circuit < Function:KMCDRV> kmcdrv - virtual circuit driver */ ARGSUSED */ < Function:NPISNL> npisnl - NPI Set Network Link For a given NPI call, find a physical network link < Function:NPICON0> npicon0 - Network Program Interface CONnnect Connect and log on to an external database. Bug:559734 ksuxds , the session delete routine. Bug:5292290 ktusmasp - Kernel Transaction Undo SMu Add SPace - adding space to a SMU segment ktrsexec - executes resumable function. ktusmasp1r - Kernel Transaction Undo SMu Add SPace resumable ktusm_shrinkoff - Kernel Transaction Undo SMU Shrink Offline Rollback Segs Bug:5439893 kgeriv # KGE Record Internal error code (with Va_list) (IGNORE) kgesiv # KGE Signal Internal error code (with VA_list) (IGNORE) ksesic4 ksqdeli ksqdel release an enqueue */ ksqsod ? Module Notes: Kernel Service enQueues kssxdl KSS: delete SO ignoring all except severe errors. cleans latches kssdch_stage kssdch KSS: delete children of state obj. ksuxds KSU: acquires the ksupol, the so latch protects access to sniper bit kssxdl KSS: delete SO ignoring all except severe errors. cleans latches kssdch_stage kssdch KSS: delete children of state obj. ksudlp KSU: delete process.called when user detaches or during cleanup by PMON kssxdl KSS: delete SO ignoring all except severe errors. cleans latches ksuxdl KSUCLN: Delete state object for PMON ksuxda KSUCLN: Attempt to delete all processes that are marked dead. ksucln KSUCLN: Cleanup detached process ksbrdp KSB: run a detached (background) process Bug:3688894 msqfun Append a function call. kkfsrwn KKFS: append n columns of rwo kkfsq0 KKFS: generate subselects kkfsql kkfdsql: SQL builder for each combined DFO in tree Bug:3412924 nstimexp Expire function - invoked by LTM with these specific arguments nsevwait NS EVent WAIT: wait for event notification on all registered connections; ksliwat KSL: Latching: Awaken a wait event kslwait Wait for N centi-seconds or until posted kmdmai main loop for dispatcher kqlmbpil stands for 'KQLM Background process a Pin Instance Lock' Bug:3671563 ksesic3 # Signal an error kmcmbf KMC: Mark buffer kmcdflu kmcdflu: opikndf1 Kernel routine which sits on top of the SQL*Net driver flush function: opitsk opitsk - Two Task Oracle Side Function Dispatcher opiino opiino - ORACLE Program Interface INitialize Opi opiodr OPIODR: ORACLE code request driver - route the current request Bug:5516917 ksesic2 # KSE: signal an internal error code ksmarfg kghgex KGH: Get a new extent kghfnd KGH: Find a chunk of at least the minimum size kghalo KGH: main allocation entry point kghgex KGH: Get a new extent kghfnd KGH: Find a chunk of at least the minimum size kghalo KGH: main allocation entry point kghgex KGH: Get a new extent kghfnd KGH: Find a chunk of at least the minimum size kghprmalo kghalp KGH: Allocate permanent memory Note:42194.1 [kzulgt and kzulrl: user lock get and release; kzull: user lock latch] User Lock latch is only aquired by two functions,kzulgt to get a lock on a specified user in a given mode, if it fails it does not wait on the latch. The other function is kzulrl which aquires a User Lock latch to release a specified user . Both functions are used by PMON and server processes during certain operations like cleaning dead user processes or dropping a schema user. Bug:3409388 About x$kcbwh and x$kcbsw: ktugct - Block cleanout; consider setting _row_cr=TRUE if majority are immediate CR cleanouts kdifind - Find the leaf block associated with the key Kdstgr Performs full table scan get row. Rows are accessed by a full table scan. Check the number of FULL table scans Kdsgrp Performs get row piece. Typically, row pieces are affected only in case of chained and migrated rows. Row chaining has to be analyzed and fixed. Kdiixs Performs index range scan. Bug:3934729 snstimsane On Unix, when the signal goes off, check to ensure that we`re still nstimexp Expire function - invoked by LTM with these specific arguments. */ ksmupg check if there is any references in session global data to process ksuxds KSU: acquires the ksupol, the so latch protects access to sniper bit ksudel KSU: delete specified user session opidcl cleanup after the sqlnet connection is terminated. Put the cleanup actions kstm2s convert a function mask to a string and return length of string */ ksfhgpioxh ksfhgpioxh - Get Private file I/O conteXt Handle ksusus USER SESSION MIGRATION: The following procedures allow the migration of */ ksline code to initialize wait/post events */ Note:187026.1 kgllkdl: KGL LocK DeLete Bug:3049737 nsbGetBFS: nsbGetBFS() is called to allocate network buffers from either the shared pool or from the process private heap depending on the caller. If the underlying memory allocation call fails (kmnsbm for shared pool, typically malloc for process heap) then nsbGetBFS() returns a failure condition back up through the stack to nsbalc(). nsdo() sees this failure and sets: ... Bug:3249495 The shadow and pmon aborted at kglobcl(). That is the routine to free a structure stored unused-object in library cache. As the customer run shared-pool-flush operation, the call is right. But we don't know why the pointer referred an incorrect address. The shadow may be victim. Bug:2773916 oradebug call ksmlu_setup 1 The '1' is related to the number of _kghdsidx_count. Since we did this, the queries over v$shared_pool_reserved show REQUEST_FAILURES with a value of 3 and Last miss size, max miss size and last failure size are all 63300. multiple executions of the "call ksmlu_setup 1" refreshes the values in v$shared_pool_reserved. We are not sure if this is the right behavior, or if the values are reliable and why since FAILURES column increases why no ora-4031 is registered in the alert.log. Bug:4269779 kxsctf ==> callback for fixed table x$kxscc SR Number 5845856.993 @opidsa - oracle side of program interface array describe @ locals */ @ ARGSUSED */ @Module Summary: @ opidsa - oracle side of program interface array describe @ describe a range of select variables Bug: 1328999 ksqded deadlock detection (ksqded) Using a debugger attach to the shadow process of the gtr session on Screen 3 - ie: the one we have just detached from the transaction on. For support reference the commands below are for 'adb' on Solaris along with text description for better debuggers :-)) Attach to the Oracle shadow (adb $ORACLE_HOME/bin/oracle, 0t< PID>:A) Set a breakpoint on entry to ksqded() (ksqded:b) Ignore SIGALRM signals in the debugger (e:i) Allow the shadow to continue (:c) SR Number 6642098.992 kghgex KGH: Get a new extent kghalf KGH: Non-recoverably allocate a freeable chunk of memory kxsGetFramePage kxsxsi opiexe opiexe - ORACLE Program Interface EXEcute kpoal8 kpoal8.c - Kernel Programmatic Oracle ALl Version 8 opiodr OPIODR: ORACLE code request driver - route the current request ttcpip TTCPIP: Two Task Common PIPe read/write opitsk opitsk - Two Task Oracle Side Function Dispatcher opiino opiino - ORACLE Program Interface INitialize Opi Bug: 3947138 v$sysstat: DBWR make free requests 5 < ---- kcbybl, kcbbioq DBWR free buffers found 892 < ---- kcbyff, kcbbscan DBWR lru scans 5 < ---- kcbyls, kcbbioq . NAME VALUE ---------------------------------------------------------------- ---------- DBWR summed scan depth 896 < ---- kcbysd, kcbbscan DBWR buffers scanned 896 < ---- kcbybs, kcbbscan If _db_block_known_clean_pct is set, kcbbioq takes a different path and doesn't call kcbbscan and hence it doesn't increment the associated statistics. _db_block_known_clean_pct is the percentage of buffers that dbwriter will try to keep clean so that foregrounds can always find a buffer on the LRU list. It is 2% by default and can grow to a maximum of 25% dynamically in an effort to self-tune the cache. If the parameter is set to 0, this self-tuning no longer takes place. Source? ksedst # KSE: dump the call stack ksedmp # KSE: dump the process state ksdxfdmp KSDX: Function: invoked named DuMP ksdxcb # CallBack for sosd layer signal handler (IGNORE) sspuser SSPUSER: handle SIGUSR2 for ORACLE. libc_poll sskgxp_select skgxpiwait skgxpwait skgxpwait - Wait for an asynchronous request to finish. ksxpwait ksliwat KSL: Latching: Awaken a wait event kslwaitns kskthbwt kslwait Wait for N centi-seconds or until posted kwqmncoord ksbrdp KSB: run a detached (background) process Bug 6053354 SQL constraint enforcement (KXCCPTSQ) Bug 3801750 kdiexi Determine whether a row with a particular key value exists kxccres KXCC REStrict constraint enforcement delref Enforce per-row referential actions. delrow Row Procedure used by KXRD to delete or lock a row delexe delete execute Bug 1690808 Function: KTSMG_ICMT Source: ./server/space/spcmgmt/ktsm.c Notes Updated: NO - From O8 Source Function Notes ktsmg_icmt - Insert direct load ComMiT - called by transx code at commit - Called at commit time to finish Insert Direct Load processing - Merge temp segment into table segment OR bump up table [partition] HWMs - If no rows are inserted, does nothing except free cmtctx memory Bug 3476871 ksqcmi KSQ: Change mode ksqgtl KSQ: get an enqueue ksqgel KSQ: get an enqueue ktuServiceNTP ktucmt ktucmt - Kernel Transaction Undo CoMmit Transaction */ ktuabt ktuabt - Kernel Transaction Undo ABorT */ ktcrab KTC: Kernel Transaction Control Real ABort - Abort a transaction. ktccle ksepop perform cleanup when an error frame is being popped */ . < ---------- kgepop kgepop - KGE POP to the current top error frame */ kgesev KGE: Signal Error code (with Va_list) ksesec0 # IGNORE: Signal an error ktmpsm private procedure to post SMON */ < ----------- ------ ktmpst post system monitor process */ ktmnpst ktubsy ktubsy - Kernel Transaction Undo BuSY ktusrs ktusrs - Kernel Transaction Undo Shrink Rollback Segments */ < --------- ktursn ksursn - Kernel Transaction Undo Rollback segment Shrink Numbered. ktursr ktursr - Kernel Transaction Undo Rollback segment Shrink Requested ktmmon KTM: TX Monitor: background timeout action ksbrdp KSB: run a detached (background) process Note:393947.1 krmzgaut, @(that is the function that restores the controlfile and spfile autobackups ) http://www.dbasupport.com/oracle/ora10g/crisis.shtml ksudss "generates a system state dump" Note:343294.1 event:10621. If this event level is 1, then foregrounds will try forever to get the DML lock in kdic_cleanup(). attach to SMON with oradebug and call kidcclean ksesec0 # IGNORE: Signal an error koklierr NAME: koklisdisk - KOK Lob Internal Set DISK part of locator. koklwrite koklwrite - KOK Lob WRITE */ kzaSqlBindLob kzftAuditInit kzftChkAudit insarp insrow Fetch a row for insertion. This is called back by multirow insert Bug 2929556 ksesec1 Recovery operations. Be careful of cross-instance ktecgetsh ktecgetsh - KTE Concurrency - GET Segment Header ktelrwi ktelrwi - Kernel Transaction Extent Loader Redo-less Write qerpxStart QERPX: start opiall0 ARGSUSED */ kpoal8 kpoal8.c - Kernel Programmatic Oracle ALl Version 8 Anjo Kolk: "Oracle Wait Interface: To Wait or Not To Wait" What if we have hit the maximum? » Reset it with dbms_system.kcfrms() "A Brief overview of Mutex a new feature" Compiled by MG Raghavan, Principal Service Deliver Engineer, Solution Support Center, Silicon valley kkspsc0 – Parse Cursor - testing if parent heap 0 is there (did we find the parent SQL statement?) kksfbc – Find Bound Cursor – creation of a new child cursor kkfFindCursorStat- hard parse (inserting a lot of statistics blocks) Bug 1283286 < Function:KGFFDCN> kgffdcn - DisCoNnect from a KGFF instance Each process that obtained a KGFF handle by callin < Function:KSFHNFY> the foreground that starts an instance is responsible for a lot of. headaches since the same process < Function:KSCNFY> NOTIFICATION PROCEDURE: Procedure to cause notifications */. be passed to components.*/ < Function:KSMDPG> Deallocate variable PGA. Just free top PGA heap, the callback will free. the extents to the OSD. Bug 6991167 kghxal Allocate a fixed size piece of shared memory. kglllal kglllal - KGL Load Lock ALlocate */ kglobld KGL2: OBject LoaD kglobpn KGL2: OBject PiN heaps and load data pieces kglpim KGL: PIn and load More heaps kglpin KGL: PIN heaps and load data pieces of an object kkdllpoOpt kkdllpo kkdllpo - KKDL lock and pin by object-id */ kghxcu latch cleanup for the fixed allocator */ kgllcl kgllcl - KGL Latch Clean-up for the load lock latch */ kslilcr invoke latch cleanup routine: */ ksl_cleanup ksuxfl KSU: Find dead processes and cleanup their latches. Called by PMON ksuxda KSUCLN: Attempt to delete all processes that are marked dead. ksucln KSUCLN: Cleanup detached process ksbrdp KSB: run a detached (background) process Bug 6954816 ksfdmp # Call relevant dump routine kgeade kgeade - KGE ADd Error onto the error stack */ opipls opipls.c -- contains opi bundled call executor and skgmstack skgmstack - call specified function with extra STACK space rpidru RPI: setup memory for the recursive session (unclear) rpiswu2 RPI: SWitch User in recursive sql rpidrv RPI: Recursive Program Interface DRiVer psddr0 Null pointer definitions for ttcdrv callback and context. Bug 6712660 kgerinv kgerinv - KGE Record Internal (Named) error (with Va_list) */ kgeasnmierr ktsfunlk ktsfunlk - Kernel Transaction Segment Undo Free List ktsfunlk ktsfunlk - Kernel Transaction Segment Undo Free List ktundo ktundo - Kernel Transaction UNDO ktubko Get undo record to rollback transaction, non-CR only */ ktuabt ktuabt - Kernel Transaction Undo ABorT */ ktcrab KTC: Kernel Transaction Control Real ABort - Abort a transaction. kssxdl KSS: delete SO ignoring all except severe errors. cleans latches kssdch_stage ksuxds KSU: acquires the ksupol, the so latch protects access to sniper bit kssxdl KSS: delete SO ignoring all except severe errors. cleans latches kssdch_stage ksudlp KSU: delete process.called when user detaches or during cleanup by PMON kssxdl KSS: delete SO ignoring all except severe errors. cleans latches ksuxdl KSUCLN: Delete state object for PMON ksuxda KSUCLN: Attempt to delete all processes that are marked dead. ksucln KSUCLN: Cleanup detached process Note:558671.1 Summary Stack (to Full stack) (to Function List) ksedst # KSE: dump the call stack ksedmp # KSE: dump the process state ksddoa # Debug support Do an Action ksdpcg # KSD: Post and check event in the specified event group ksdpec # KSD: Post Event and Check trigger condition PGOSF70_ksfpec 104 kgesev KGE: Signal Error code (with Va_list) ksesec0 # IGNORE: Signal an error kpoblng kpobsv kpobii kpobav opibvg opiexe opiexe - ORACLE Program Interface EXEcute opipls opipls.c — contains opi bundled call executor and support routines opiodr OPIODR: ORACLE code request driver - route the current request PGOSF163_rpidrus skgmstack skgmstack - call specified function with extra STACK space rpidru RPI: setup memory for the recursive session (unclear) rpiswu2 RPI: SWitch User in recursive sql rpidrv RPI: Recursive Program Interface DRiVer psddr0 Null pointer definitions for ttcdrv callback and context. Used in psddrv. psdnal ARGSUSED */ pevm_EXECC pfrinstr_EXECC pfrrun_no_tool pfrrun PSDEVN: PL/SQL Interpreter Main Instruction Loop plsql_run peicnt PL/SQL controlled Execution kkxexe KKX: execute plsql opiexe opiexe - ORACLE Program Interface EXEcute kpoal8 kpoal8.c - Kernel Programmatic Oracle ALl Version 8 opiodr OPIODR: ORACLE code request driver - route the current request ttcpip TTCPIP: Two Task Common PIPe read/write opitsk opitsk - Two Task Oracle Side Function Dispatcher opiino opiino - ORACLE Program Interface INitialize Opi opiodr OPIODR: ORACLE code request driver - route the current request opidrv # opidrv - ORACLE Program Interface DRiVer (IGNORE) sou2o # Main Oracle executable entry point opimai_real main # Standard executable entry point Note:453521.1 ksmlgpalloc ksmlgpalloc - KSM LarGe Pool ALLOCation ksfqbalo ksfqbcre BUFFER MANAGER FUNCS */ ksfqxc ksfqxcrx ksfqxcre ksfqxcre - CREate KSFQ context krbbpc Piece Create. This is the implementation of krbibpc Backup Piece Creation */ pevm_icd_call_comm pfrrun PSDEVN: PL/SQL Interpreter Main Instruction Loop pricar -------------------------------- pricar -------------------------------- */ pricbr PL/SQL Remote Interface - Call Back, Remote prient2 prient2 - common code to run given entrypoint: could be RPC or non-RPC prient prient - Run given (RPC) entrypoint kkxrpc ARGSUSED */ kporpc kporpc.c - The oracle side function to start rpc Note:283019.1 kftr2ah KFT: relative to absolute file number translation with hint atbmod Alter TaBle MODify columns in the table: Bug 4295127 kxfpqsod Queue State Object Delete kssdch_stage kssdch KSS: delete children of state obj. ksuxds KSU: acquires the ksupol, the so latch protects access to sniper bit ksudel KSU: delete specified user session kglpndl kglpndl - KGL PiN DeLete */ kglpnds kglpnds - KGL PiN Delete State object */ kglunp KGL: UNPin heaps of an object kkscls KKS: Close the cursor, user is done with it kghfre KGH: Free a chunk of memory. kghfrh Free heap. Free all the extents allocated in the heap using kghalfrx(). kxttClnUp clean up state object kssdch_stage Bug 5867045 ktudecrustat decrementing undo usage statistics in the resource manager We do this while deleting the transaction state object and with the resource manager enabled Bug 6728740 (ub1) kssobflg 01 KSSOINIT BIT 00000001 /* state object initialized */ (b1) ktadmflg 11 = 17 KTADMFLK BIT 00000001 /* the lock may be held */ KTADMFLH BIT 00000010 /* lock gotten */ Note:577579.1 ktssdt_segs() (Drop Temporary Segments) Bug 4034546 ktdbgn a distributed transaction is initialized Bug 5111335 niotns < < < This is where SQLNET.OUTBOUND_CONNECT_TIMEOUT is implemented IF it has been configured. kpnconn < < < This is where "single-task message" starts/ends Bug 7247076 kkoSwapOk() decides if a swap of inputs is allowed. The logic in kkoSwapOk seems to disallow swap of the leading table if LEADING or ORDERED is specified but does not prevent swap of any subsequent tables in the join order for an ORDERED hint. Hence it returns that it is OK to cost a swap of join inputs for the HASH join involving T3 and then CBO does swap the inputs over. Bug 7281391 kjbmpocr(), this processes an open convert request. Bug 5015462 kgherror KGH: Internal routine for signaling an error kghpir Pin a chunk of space that was specified to be recreatable. At the time a kqrpre KQR: read a parent cache object kkercs Name: kkercs - read column statistics for an object kkehrd Name: kkehrd - get column statistics for a table kkeapr KKE: anaylze predicates for optimization - returns stat ptr kkepsl selectivity of single predicate kkecdn KKE: determine cardinality of a table given single table predicates kkotap KKO: Table Path kkoiqb KKO: Initialize Query Block kkooqb KKO: Optimize Query Block kkoqbc KKO: er... kghfrmrg KGH: Free a chunk, merge with neighbors if free Returns merged chunk. kghfre KGH: Free a chunk of memory. kghfen KGH: Free a portion of a chunk of space at the end of the chunk kghfru Free Unused space in heap. Attempts to free up any unused portions of kkslod cursor LOaD call-back kglobld KGL2: OBject LoaD kglobpn KGL2: OBject PiN heaps and load data pieces kglpim KGL: PIn and load More heaps Bug 1724234 (kghupr) kghupr1 Unpin a chunk chunk of space that was specified to be recreatable Bug 4185704 ksmarfg 'Put in an event="7445 trace name REALFREEDUMP level 10"' integrid.info/memory_latching.pdf ksmarfg() and ksmfrfg() internal functions. are used for realfree heap allocation Tanel Poder "Advanced Oracle Troubleshooting" ksmals kernel service memory allocate stack ksmfrs kernel service memory release stack ksudps dump process state ksmcpg create PGA? ksdhng hanganalyze ksdpec post event check kstpec for KST tracing (X$TRACE) kcbispnd buffer is pinned, especially useful for nested loops and some index range scans qertbFetch qer: table fetch rowsource kdsttgr Data: scan table get rows ktrget Transaction read: get rows kcbgtcr Cache Buffer: get rows kcfrbd Cache File: Read Block from Disk ksfdread Service: file disk read skgfqio OSD: generic file queue IO Bug 2208128 < Function:KQRFRC> This is called back to request that some memory be freed in a cache.. ARGSUSED */ < Function:KGHFRUNP> KGH: Ask client to free unpinned space < Function:KGHFND> KGH: Find a chunk of at least the minimum size < Function:KGHALO> KGH: main allocation entry point < Function:KGHGEX> KGH: Get a new extent < Function:KGHFND> KGH: Find a chunk of at least the minimum size < Function:KGHPMALO> KGH: Find and return a permanent chunk of space < Function:KGHALP> KGH: Allocate permanent memory < Function:KGHSUPMM> (*) PAGE TABLE ROUTINES */. KGHS Unpaged Page table, get More Memory < Function:KGHSSGAI> kghssgai - SeGmented ALlocation Internal * Allocated the requested number of < Function:KKSMCALFREE>kksmcAlFree - KKSM: Conditinally Segmented Array ALLOCATE a. allocate a segmented or non-segmented http://blogs.conus.info/node/15 upicui() function (UPI Change User Id) Bug 5664996 upicui (Change User Id) http://sql.ru/forum/actualthread.aspx?bid=3&tid=457444&pg=1 (Bug 3624062 or 2950517 has similar list) ctcdrv Create Table or Cluster DRiVer. insexe insert execute insidx Insert indexed keys into the indexes after each row is inserted into the insflush insrow Fetch a row for insertion. This is called back by multirow insert kaudfb KAU: Flush any pending bitmap index changes kauupd KAU: update table and modify indexes kauxsin Insert a key into x index segment(s) only kcbema Exam and Maybe Apply kcblio Kernel Cache Buffer Load issue I/O kcblrr Kernel Cache Buffer Load Release all Resources kcblsy Kernel Cache Buffer Load Sync i/o kcocbk Kernel Cache Op CallBacK -- invoke redo callback routine kcramr Apply Media Recovery kddchg perform delete/update CHanGe. kdddel Delete row kdddgb KDD: Kernel Data Delete Get Block kdiblcfls KDIBL conventional flush batch with undo overhead kdiblfls KDIBL: FLuSh batch kdiblovfls KDIBL: flush overlapping batch kdiblread KDIBL: READ kdi entry containing the speciied dml/load item kdiblwrite KDIBL: WRITE a kdi entry kdiins0 inserts the argument key and associated keydata into. the argument b-tree index kdiins inserts the argument key and associated keydata into. the argument b-tree index kdilinle Insert argument key/keydata into an uncompressed leaf block. kdimod modifies the argument key`s row from the argument index according kdisle split the argument leaf block and insert the argument key. kdisnew Allocate a new index block during a split. kdisnewle Allocate and initialize a new leaf block during a split. kdl_copy copies data between two ILOB instances kdoiur Applying rollback records to data blocks kdsgrp Get a Row Piece kdstgr Tablescan Get Row kdumrp KDU: Update multiple row pieces kduovw Kernel Data Update, updates already existing rows kdusru KDU: Single Row Update, main entry kduurp KDU: update row piece kgeasi Raise an error on an ASSERTION failure (IGNORE) kgepop kgepop - KGE POP to the current top error frame kgerem KGE Record Error code (with already-formatted Message) kgerinv KGE Record Internal (Named) error (with Va_list) kgeriv KGE Record Internal error code (with Va_list) (IGNORE) kgesev KGE: Signal Error code (with Va_list) kgesiv KGE Signal Internal error code (with VA_list) kglgob KGL: GeT an Object locked and pinned kglobld KGL2: OBject LoaD kglobpn KGL2: OBject PiN heaps and load data pieces kglpim KGL: PIn and load More heaps kglpin KGL: PIN heaps and load data pieces of an object kjuscv Sync. Convert kksfbc KKS: Find Bound Cursor kkxexe KKX: execute plsql klclil1r Kernel Loader C Level Interface Load 1 Row klcslod load nls data object knahsma Kernel replicatioN Apply Hadb Slave MAin knasgvm Kernel replicatioN Apply Slave Get Valid knaslod Kernel replicatioN Apply Slave LOaD metadata knasm2 Kernel replicatioN Apply Slave Main 2 knaspd Kernel replicatioN Apply Slave Process Dml knaspx Kernel replicatioN Apply Process transaXtion koklcre KOK Lob CREate kokleva KOKL EVAluate kokliclo KOK Lob Internal Create with another LOcator kprball execute ALL bundled KPR (RPI) operations ksbrdp KSB: run a detached (background) process ksddoa Debug support Do an Action ksdpcg KSD: Post and check event in the specified event group ksdpec KSD: Post Event and Check trigger condition ksdxcb CallBack for sosd layer signal handler (IGNORE) ksedmp KSE: dump the process state ksepop perform cleanup when an error frame is being popped ksesec0 IGNORE: Signal an error ksfdmp Call relevant dump routine ksfpec KSF: Post an event kslgetl Get the latch specified by 'id', on behalf of the current session. If 'wait' is FALSE, return ksliwat KSL: Latching: Awaken a wait event kslwait Wait for N centi-seconds or until posted ksqcmi KSQ: Change mode ksqcnv convert an enqueue`s mode ksqcov convert an enqueue`s mode ksqded KSQ: deadlock detection ksqgel KSQ: get an enqueue. Acquire an enqueue on the specified resource with the additional ability to read a lock value. ksqgtl KSQ: get an enqueue kssdch KSS: delete children of state obj. ksursn Kernel Transaction Undo Rollback segment Shrink Numbered. ktaadm Kernel Transaction Access get All DML locks ktagdm KTA: Kernel Transaction Access Get DML lock ktagetp Kernel Transaction Access Get Partition lock ktaifm Kernel Transaction Access Internal Find DML lock ktbgfi general find an itl entry ktbgtl test a lock value, clean or wait as needed to delete it ktcrab KTC: Kernel Transaction Control Real ABort - Abort a transaction. ktcwit KTC: Kernel Tranasction Control: WaIT ktmmon KTM: TX Monitor: background timeout action ktmpsm private procedure to post SMON ktmpst post system monitor process ktrsexec executes resumable function. ktsf_gsp Kernel Transaction Segment Get SPace ktsxterr KTS Find EXtent Error ktuabt Kernel Transaction Undo ABorT. Updating undo segment headers on rollback (ABorT) ktubko Reading rollback blocks to apply undo records ktubnd Kernel transaction Undo BiND ktubsy Kernel Transaction Undo BuSY ktuchg Kernel Transaction Undo Change. Write logs and perform changes. ktucmt Kernel Transaction Undo CoMmit Transaction ktudba Kernel Transaction Undo convert from usn to DBA ktugdl Kernel Transaction Undo Get Ddl Lock Get an 'US' lock in X-mode. If (USC) is passed in, the USC row cache will also be read and the rbs name will be verified. If it does not match, OER(1534) ktugnb Undo segment header to Get Next undo Block ktugusc Kernel Transaction Undo Get Undo Segment kturdb Kernel Transaction Undo segment Redo Data Block. ktursr Kernel Transaction Undo Rollback segment Shrink Requested ktusmasp1r Kernel Transaction Undo SMu Add SPace resumable ktusmasp Kernel Transaction Undo SMu Add SPace - adding space to a SMU segment ktusm_shrinkoff Kernel Transaction Undo SMU Shrink Offline Rollback Segs. This routine shrinks offlined rollback segments. It walks through all rollback segments, for each offlined rollback segs, if the rollback seg belongs to this tablespace, shrinks it. If it gets 'extsize' # of blocks, it returns TRUE, otherwise, it returns FALSE. ktusrs Kernel Transaction Undo Shrink Rollback Segments kwqitmmsgs Kernel OLTP Queues Interface Time Monitor MeSsaGeS. kwqitptm Kernel OLTP Queues Interface Perform Time Management. kxcbcri CReate Index containing everything in the current workspace kxcbcti KXCB Convert To Index kxcbdel Delete the entry with a given key from the skip list kxccres KXCC REStrict constraint enforcement kxcwsub Decrement a workspace counter. Delete the counter if the count reaches 0 kxfpgsg KXFP: Get Server Group (coordinator) kxfpqidqr KXFP: Queue Internal DeQueue queue Reference kxfpqrsod KXFP: Queue Ref State Object Delete kxfpqsod KXFP: Queue State Object Delete kxfpqsrls KXFP: Query Slave ReLeaSe kxfprdp Run Detached Process kxfprienq KXFP: queue Ref Internal ENQueue message kxfrAllocSlaves Allocate Slaves kxfralo KXFR: ALlOcate rowid ranges and slave processes kxfxcp1 KXFX: open, parse, bind 1 set of slaves kxibDoFinish do finish processing for a specified index kxibFinish kxib Finish index maintenance processing nldatxt put current date/time into string nstimexp expire function - invoked by ltm with these specific arguments. opidrv ORACLE Program Interface DRiVer (IGNORE) opiexe ORACLE Program Interface EXEcute opifch oracle side of the fetch interface opifcr OPIFCH: fetch callback - fetch a row opiino ORACLE Program Interface INitialize Opi opiodr OPIODR: ORACLE code request driver - route the current request opirip Oracle Program Interface Run Independent Process (IGNORE). opitsk Two Task Oracle Side Function Dispatcher peicnt PL/SQL controlled Execution pfrrun PSDEVN: PL/SQL Interpreter Main Instruction Loop psddr0 Null pointer definitions for ttcdrv callback and context. Used in psddrv. qerupFetch QERUP: Update Row source FetCH rpidru RPI: setup memory for the recursive session (unclear) rpidrus RPI: Recursive program handling (unclear) rpidrv RPI: Recursive Program Interface DRiVer rpiswu2 RPI: SWitch User in recursive sql rwsfcd RWSIMA: fetch from row source skgmstack call specified function with extra STACK space. sou2o Main Oracle executable entry point IGNORE this in call stacks ssexhd DUMP ROUTINE - IGNORE stuff above this on the stack sspuser handle SIGUSR2 for ORACLE. ttcpip Two Task Common PIPe read/write updaul UPDate Attempt Update of all rows or Lock all rows updexe update execute updpcr UPDate Perform Constraint operations for each Row updated updrow Row Procedure used by KXRD to update or lock a row http://sql.ru/forum/actualthread.aspx?tid=457444&pg=2 kgherror KGH: Internal routine for signaling an error kghfrmrg KGH: Free a chunk, merge with neighbors if free Returns merged chunk. kghfre KGH: Free a chunk of memory. kghfrh Free heap. Free all the extents allocated in the heap using kghalfrx(). kgldafr kgldafr - KGL data block FRee */ kglobfr kglobfr - KGL OBject FRee all heaps (except data block 0`s) of an object */ kglobf0 kglobf0 - KGL OBject Free heap/data block 0 of an object */ kglhdiv kglhdiv - KGL object HanDle InValidate all read-only dependents kglhdi kglhdi - KGL HanDle Invalidate all read-only dependents of an object, kqlmbpil kqlmbpil - KQLM Background process a Pin Instance Lock */ kqlmba kqlmba - KQLM Background interrupt Action */ ksbcti call timeout/interrupts */ kgllccl kgllccl - KGL Latch Clean-up CLean */ kgllcu kgllcu - KGL Latch Clean-Up for the library cache and pin latches */ kslcln0 Convenient cleanup subroutine for kslcln(): kslcln Invoke the latch cleanup procedure of the latch or free all latches acquired kqlnfy KQL: KQL NotiFY kscnfy KSC: Procedure to cause notifications be passed to components. ksmshu Oracle instance is about to be SHUt down. Do final checks on SGA. drepprep perform the document indexing evapls EVAluate any PLSql function kcmclscn check Lamport SCN kcsadj1 adjust SCN kgesinv KGE Signal Internal (Named) error (with VA_list) kghalo KGH: main allocation entry point kghalp KGH: Allocate permanent memory kghfnd KGH: Find a chunk of at least the minimum size kghfrunp KGH: Ask client to free unpinned space kghfrx Free extent. This is called when a heap is unpinned to request that it kghgex KGH: Get a new extent kghnospc KGH: There is no space available in the heap kghpmalo KGH: Find and return a permanent chunk of space kghxal Allocate a fixed size piece of shared memory. kglhpd KGL HeaP Deallocate kglobcl KGL OBject CLear all tables kglpnal KGL PiN ALlOcate kglpnc KGL: PiN heaps and load data pieces of a Cursor object kglpndl KGL PiN DeLete kglrfcl KGL ReFerence CLear kgmexec KGM EXECute kkmpost POST PROCESSING kksalx ALlocate 'size' bytes from the eXecution-time heap kkscls KKS: Close the cursor, user is done with it kkspfda Multiple context area management kkssbt KKS: set bind types kksscl KKS: scan child list? koklcopy KOK Lob COPY. koklcpb2c KOK Lob CoPy Binary data (BFILE/BLOB) into Clob kolfgdir KOL File Get DIRectory object, path and FileNames. kpuexec KPU: Execute kpuexecv8 KPU: Execute V8 kpurcsc KPU Remote Call with ServiceContext, Callbacks kqdgtc return an open and parsed cursor for the given statement kqldprr KQLD Parent Referential constraint Read kqllod KQL: database object load kqlsadd kqlsadd - KQLS ADD a new element to a subordinate set kqlslod KQLS: Load all subordinate set elements for a given heap kslcll KSL: Clean up after a given latch kslcllt Clean up after a given latch kslilcr invoke latch cleanup routine: ksmapg KSM: Callback function for allocating a PGA extent, calls OSD to alloc ksmasg Callback function for allocating an SGA extent. kssxdl KSS: delete SO ignoring all except severe errors. cleans latches ksucln KSUCLN: Cleanup detached process ksudlc delete call ksudlp KSU: delete process.called when user detaches or during cleanup by PMON ksuxda KSUCLN: Attempt to delete all processes that are marked dead. ksuxdl KSUCLN: Delete state object for PMON ksuxfl KSU: Find dead processes and cleanup their latches. Called by PMON kxfpbgpc Get Permanent Chunks kxfpbgtc Buffer Allocation Get Chunk kxfpnfy KXFP: NotiFY (component notifier) kxfxse KXFX: execute kxstcls Trace cursor closing opicca ORACLE Program Interface: Clear Context Area opiclo ORACLE Program Interface: CLOse cursor opiprs ORACLE Program Interface: PaRSe opitca OPITCA: sets up the context area pextproc Pefm call EXTernal PROCedure qerocStart This function creates a collection iterator row-source to iterate qkadrv QKADRV: allocate query structures qkajoi QKAJOI: Query Kernel Allocation: JOIn processing qximeop QXIM Evaluate OPerand rpicls RPI: Recursive Program Interface CLoSe selexe SELEXE: prepare context area for fetch xtyinpr XTY Insert Numeric PRecision operator Bug 6598850 kcbzfb kcbzfb - format block kcbzgb kcbzgb - Get cr/read/rec Buffer with dba/class. kcbzcb kcbzcb - (maybe) Clone the buffer ktbgfc Ktbgfc - flush cleanout to disk. Bug 4141766 kclbla RELEASE PROCESSING */ kjbrpread pred read request at master kjbmpocr master< -client (receive) process open convert request kjmpmsg process the message kjmsm lmS Main action callback ksbrdp KSB: run a detached (background) process kgefec kgefec - KGE Fatal Error Code */ kjmsm lmS Main action callback ksbrdp KSB: run a detached (background) process Bug 3920014 kcbzfb_3 /* loop over buffers in LRU-AUX list followed by LRU-MAIN list */ while(1) . . /* also make sure that the next buffer that this points to ** is the head of the cold list. If a hot buffer were to stray ** into the cold portion of the LRU, it would prevent foregrounds ** from ever scanning beyond it to look for free buffers */ KSEORAASSERTNM4((b->kcbbhrpl.ksglknxt == wsd->cold_kcbwds), OERINM("kcbzfb_3"), kseprg(b), ksenrg(b->kcbbhlpf), kseprg(wsd->cold_kcbwds), kseprg(b->kcbbhrpl.ksglknxt)); . goto exit_loop; From all the above I susspect its either a hot buffer had gotten into the cold portion of the LRU or the buffer AUX list did not have the aux bit set. Note:389621.1 It is sometimes possible to tell that bloom filters are being used because of the presence of qerblRop in the stack or because there are memory chunks in the trace with the label 'qesblFilter_seg'. Bug 4670138 ktussto Kernel Transaction Snap Shot Too Old. kturbk Kernel Transaction Undo Roll BacK ktrgcm ktrgcm - common CR read code ktrget KTR GET a read consistent block. Bug 5494543 kffmLoad - Kernel Files File Map Load extent pointers into a map /* Validate that the source data and locked flag are not corrupted. The * data from the ASM instance must not have the locked flag set. */ KSEORAASSERTNM6(kfxpCheck(xpd) && !bit(xpd->flags_kfxp, KFXPF_LOCKED), OERINM("kffmLoad_2"), Bug 6876956 We try to kill the process by calling ksuklms() kdapgmveq which is in charge of acquiring a JI enqueue to avoid a possible deadlock situation when refreshing a materialized view when doing other concurrent operations(fixed in bug 3352838). Bug 7252590 dbslrn Log/db files ReName: adbdrv Alter DataBase DRiVer: http://www.oralife.cn/html/2008/429_gc-cr-buffer-busy.html http://www.itpub.net/thread-1229973-1-1.html Kdifbk: Fetches the single index row matching the argument key. Kdusru: Updates the single row piece. Kdifind: Finds the appropriate index block to store the key. Kdstgr :Performs full table scan get row. Rows are accessed by a full table scan. Check the number of FULL table scans Kdsgrp :Performs get row piece. Typically, row pieces are affected only in case of chained and migrated rows. Row chaining has to be analyzed and fixed. Kdiixs :Performs index range scan. Kdifxs :Fetches the next or previous row in the index scan. Kdifbk :Fetches the single index row matching the agreement key. Ktugct :Block cleanout. Bug 9001892 kclcls LOCAL PROCEDURE DEFINITIONS kclgclks kcbzib KCB: input buffer - reads a block from disk into a buffer kcbgtcr KCB: Get a block for CR ktrget Ktrget - get a read consistent block */ kdifbk KDI: fetches the single index row matching the argument key. qerix Fetch By Logical Rowid qergiFetch QERGR: FETCH procedure of PX Granule Iterator Row source Rowid qersoFetch QERSO: Fetch from a sort row source qervwFetch View row source - fetch qercoFetch count row source - fetch opifch2 program interface oracle fetch - main routine opiefn0 opipls opipls.c -- contains opi bundled call executor and support routines opiodr OPIODR: ORACLE code request driver - route the current request rpidrus RPI: Recursive program handling (unclear) skgmstack skgmstack - call specified function with extra STACK space rpidru RPI: setup memory for the recursive session (unclear) rpiswu2 RPI: SWitch User in recursive sql rpidrv RPI: Recursive Program Interface DRiVer psddr0 Null pointer definitions for ttcdrv callback and context. Used in psddrv. psdnal ARGSUSED */ pevm_EXECC pfrinstr_EXECC pfrrun_no_tool fast interpretation loop. http://www.jlcomp.demon.co.uk/buffer_usage.html rem ktu undo segments rem kd data layer rem kdi data layer - indexes rem kts Space management rem kte Extent management rem rem A few guesses of details: rem ktuwh01: ktugus Undo segment header to start transaction Get Undo Segment ?? rem ktuwh03: ktugnb Undo segment header to Get Next undo Block rem ktuwh02: ktugus Get Undo Segment header for commit rem ktuwh20: ktuabt Updating undo segment headers on rollback (ABorT) rem ktuwh23: ktubko Reading rollback blocks to apply undo records rem ktuwh24: ktubko Reading rollback blocks to apply undo records rem rem kdowh00: kdoiur Applying rollback records to data blocks ?? rem kduwh01: kdusru Single row-piece update rem kddwh01: kdddel Delete row checks of the segment header block for the extent map (kteinicnt perhaps) and high water mark (kteinpscan perhaps), followed by a couple of extra checks of the extent map (kteinmap) calls to kdstgr are getting rows from blocks read by tablescan (Tablescan Get Row, perhaps) Note 76636.1 nscon: got NSPTCN packet <-- a CONNECT packet is rxed nscon: sending NSPTRF packet <-- a REFUSE packet is sent Bug 354913 kxsqgb The value of bind buffer descriptor is determined in kxsqgb. Bug 5477391 kxibDoFinish kxibDoFinish - do finish processing for a specified index kxibFinish kxibFinish - kxib Finish index maintenance processing Bug 6723340 If a user session wants to perform direct reads of an object then we need to be sure that all dirty blocks of the object are flushed to disk before the direct reads can begin. The user session calls kcbcbo() for this, which if "_db_fast_obj_ckpt" is true (default) then a fast object checkpoint is initiated (kcbo_ckpt_obj). Bug 6085312 Almost nothing indicates what qkaBloomFiltersTraverse is, but bug 5766718 indicates that a "parallel query using bloom filters." Note 403584.1 If "opilof" is referenced in the stack, the error is happening at session logoff. Bug 5134663 Function kcropn {kcrf} kcropn - open on-line logfile. Subroutine for kcroio() and kcrfoc(). Note the slightly different handling when KCROLGEN is passed in flags. This is because the open log member must be able to do two I/O requests at once. Function kcroio {kcrf} LOG FILE I/O ROUTINES * kcroio: Open online log for I/O This opens online log number lno described by the control file record pointed to by lep. iop points to an unused i/o structure. This struct Bug 8421852 ktaiam KTA: Kernel Transaction Access Internal Allocate DML lock. ktagetp ktagetp - Kernel Transaction Access Get Partition lock Bug 5573238 Check out the code in kghxrg_retain /* If the type is freeable and the chunk is small then we will allocate * chunks from the heap of type permanent in batches. This avoids * fragmentation caused by lots of small allocations in a heap. * * Additionally, don't batch heap descriptors and free lists where the * is not the top sga heap since the top SGA heap is the only heap with * LRU lists. */ #define KGHXBATCH 250 /* allocations smaller than this are batched */ if (( bit(chunkflags, KGHACMASK) != KGHACFREE || xfr->kghxfsiz > KGHXBATCH || bit(xfrflg, KGHXFHEAP)) && (heap == kgsmtsga(kgsmgsga(gp)) || KGHISNEW(heap))) { if (!bit(xfrflg, KGHXFNORC)) Bug 5970348: ENHANCEMENT REQUEST TO USE THE TABLESPACE READ-ONLY SCN FOR BLOCKS' COMMIT SCN Fact that delayed block cleanout occours we can see in uploaded errorstack dump -> function ktbgcl1 on list - ----------------------------------------------- ktrget -> ktrgcm -> ktbgcl1 -> ktugct -> kturbt Function kturbk {ktur} kturbk - Kernel transaction Undo Roll BacK This is for CR only. Read t he undo record (CRX) pointed by the uba and call ktundo to actually b acks out the change. Function kturbt {ktu} kturbt - Kernel Transactrion Undo Roll Back To (time scn) */ Routine to roll a transaction back so that "time" is */ in range on the block. */ Function ktugct {ktu} ktugct - Kernel Transaction Undo Get Commit Times */ This routine will return the commit times for transaction ids i n */ a data block`s itl. It uses ktbisr and ktbisn to scan t he block and */ Function ktbgcl1 UNKNOWN-FUNCTION / MODULE {} ktbgcl1 - KTB General CLean 1 DESCRIPTION: Performs ITL cleanout for read consistency and for current blocks. For read consistency (KTB_CR), always cleanout until the CR scan time For current (KTB_CUR), Function ktrgcm {ktr} ktrgcm - common CR read code Function ktrget {ktr} Ktrget - get a read consistent block Bug 6182944 log_buffer is calculated complexly in kcrflb Bug 278365 ktcrcm: Function to commit a transaction by entering a system commit number into the undo segment transaction table. Allow caller to supply a distributed synchronized SCN. Bug 3046909 kgicli(), to delete an instantation object, but the operation fails with the ORA-7445. Then the process tries to dump the instantation object calling kgidmp() a cursor is being closed (opicls()) Bug 8507754 kqlidpfgr - KQL Invalidate all DePendent objects with Finer GRained stuff Bug 9322994 kqlidpc (Invalidate all DePendent objects) Note:1076022.1 client sending packet (nsbasic_bsd) to the server and waits to receive packet back (nsbasic_brc) NSPTCN connect packet, NSPTRS resend, NSPTRD redirect Bug 2763070 kxscrem { // OCI handles for remote exec Note 9949948.8 ksfdrwat0 () <<< Spin point DSI302DataManagmnt\Les14 Cleanout at commit time is attempted by function kcbnlc when the transaction, after committing, deletes its List of Blocks SOs (ktldbl). For each block found in the transaction’s BL State Object, the Oracle server tries a «no-logging cleanout» by calling kcbnlc unction that does the actual fast cleanout (ktbdbc) Note 273425.1 "kctmttrcalc" calculates the correct FAST_START_MTTR_TARGET value every 30 seconds. event 16054 get gap sequence code path: kcrrggs() Bug 7041947 nsevfnt => NS EVent From NT: NS <- NT event translation. nsevwait => NS EVent WAIT: wait for event notification on all Bug 5634093 In ktrgcm(), following comment is described. /* Invariant is that dscn <= envscn <= min(crscn,envsch) so the call to ktrIntersect must return true. However, we may need to decrease envsch if the crscn of the block is smaller. Bug 3577772: Can't allow RowCR for user-supplied buffers (e.g. PQ). */ Note 1229793.1 invalidation window(kglobitm) Bug 9640714 ksbabs KSB: Background process: Action based server ksbrdp KSB: run a detached (background) process Bug 10121751 kksumc KKS: UnMap shared Cursor Bug 5390762 kdbcpss when compressing the block into the temporary memory it has trashed the header of the temp space (kdbcpss fills from end of block backwards and the header is overwritten by row data). Bug 5401176 the block is compressed by kdbcpss (or kdb4cpss). Bug 8332315 kdbcpss() to do the compression for data, and kdxcps() for indexes . Bug 691622 get the length of a row (kdrgtl) Bug 12368481 Oracle is performing a parallel recovery (kcrpdv) Bug 10134268 kxfpbalo Buffer Allocation - Allocate Buffer * kxfprialo KXFP: queue Ref Internal ALlOcate kxfpgqr KXFP: Get Queue Reference (slave) kxfxsur KXFX: reset slave uga space ... kxfxsp KXFX: open, parse, bind entire dfo kxfxmai KXFX: slave process main entry point kxfprdp KXFP: Run Detached Process Bug 9327524 If we cannot find space to extend an SMU undo segment then we look steal space from offline undo segments. ktusm_shrinkoff currently has this basic flow: USN=0 while (get dc_rollback_segments row cache entry for this USN) { if USN is OFFLINE and SMU etc { get US enqueue for USN (ktugdl) check / do shrinking if we got space all done / return } USN++; } until it finds the first offline segment, and then it waits for US for that segment. Bug 9955368 kglsec KGL: Signal Error Code kglpnal kglpnal - KGL PiN ALlOcate */ kglpin KGL: PIN heaps and load data pieces of an object kkdllk0 kqlunac kqluna - KQL UNAuthenticate dependents of an object */ kqlunac kqluna - KQL UNAuthenticate dependents of an object */ grapgp2 grapgp gradrv GRAnt/revoke Driver opiexe opiexe - ORACLE Program Interface EXEcute opiosq0 opipls opipls.c -- contains opi bundled call executor and support routines opiodr OPIODR: ORACLE code request driver - route the current request PGOSF141_rpidrus skgmstack skgmstack - call specified function with extra STACK space rpiswu2 RPI: SWitch User in recursive sql rpidrv RPI: Recursive Program Interface DRiVer psddr0 Null pointer definitions for ttcdrv callback and context. Used in psddrv. psdnal ARGSUSED */ pevm_EXIM pfrinstr_EXIM pfrrun_no_tool fast interpretation loop. pfrrun PSDEVN: PL/SQL Interpreter Main Instruction Loop plsql_run single entry point for top level pfrrun and penrun. peicnt PL/SQL controlled Execution kkxexe KKX: execute plsql opiexe opiexe - ORACLE Program Interface EXEcute opiall0 ARGSUSED */ opikpr opikpr.c - opiodr OPIODR: ORACLE code request driver - route the current request PGOSF141_rpidrus skgmstack skgmstack - call specified function with extra STACK space rpiswu2 RPI: SWitch User in recursive sql kprball kprball - execute ALL bundled KPR (RPI) operations */ kkxsexr kkxsexr -- KXXS EXecute with Returning binds kkxsexe kkxsexe - KKXS EXEcute a cursor */ Bug 9240685 "Cursor close all" is an OCCA action which invokes kpoclsa() on the server. kpoclsa() tries to map and close the list of cursors given to it. Bug 12602090 kteinxtt : KTE INformation - eXTent ktspmlhwm : Move the Low High Water Mark. Called when a range of blocks is formatted ktspfmtrng : Format one range or less of data blocks. L1 is released on return. ktspfsall : ? ktspfsrch : KTSP First Level bitmap block Search ktspscan_bmb : ktspscan_bmb ktspgsp_cbk1 ktspgsp_cbk kdtgsp : table/cluster insert - get space It's no wonder kteinxtt takes a long time to travel very long extent map chains. unfortenately session hold segment header in PR mode. So calling kteinxtt by ktspmlhwm frequently could be a cause of segment header contention. Bug 10057951 kqreqd enqueue delete */ kqrprl release enqueue */ Bug 13068185 ksfdread1 read random access file in sync mode kcfrbd Read Buffers from Database: kcbzib KCB: input buffer - reads a block from disk into a buffer kcbgcur KCB: Get a block in current mode. ktspgfblk3 ktspstchg1 ktspstchg kdoiur declare local objects */ kcoubk kcoubk - Kernel Cache Op Undo callBacK -- invoke undo callback routine */ Bug 10031349 ktsmg_seg ktsmg_seg - KTS MerGe Segments ktatmerge_segs kxttMerge ktsmg_icmt ktsmg_icmt - Insert direct load ComMiT - called by transx code at commit ktcifc ktcifc - Idl Flush Contexts ktucmt ktucmt - Kernel Transaction Undo CoMmit Transaction */ ktpcmt ktpcmt - Kernel Transaction Parallel CoMmiT parallel transaction ktcrcm KTC: Kernel Transaction Control Real CoMmit qes3tExecSQL qerleStart subsr1 subsr1 - evaluate SUBquery; Single Row subquery method 1 subsr3 subsr3 - evaluate SUBquery; Single Row subquery method 3 evaopn2 evaluate operand evaopn2 evaluate operand evasub evaopn2 evaluate operand upderh Evaluate right hand side expressions in order to get update values. upduaw get the values of the update columns */ Bug 12917858 ktspgsp_main Get Space for inserts koklicbf koklicbf - KOK Lob Internal Create with contents of the BuFfer */ Bug 12621788 ktbgcur Kernel Transaction Block GET kdifind At any given moment, each possible key has a unique ASSOCIATED BLOCK at a kdiexi kdiexi determines whether a row with a particular key value exists in kxccexi kxccexi - use kxci array to call kdiexi for a partitioned(?) index Bug 10324526 kcoapl NAME: kcoapl - Kernel Cache Op APpLy kcbapl kcrfw_redo_gen kcbchg1_main kcbchg ktbconv ktbconv - Kernel Transaction Block CONVert Bug 10074510 kdiulk kdiulk undoes leaf key operations. kcoubk kcoubk - Kernel Cache Op Undo callBacK -- invoke undo callback routine */ ktundo ktundo - Kernel Transaction UNDO ktubko Get undo record to rollback transaction, non-CR only */ ktuabt ktuabt - Kernel Transaction Undo ABorT */ ktcrab KTC: Kernel Transaction Control Real ABort - Abort a transaction. ktcsod KTC: Transaction Control: STATE OBJECT PROCEDURE VECTOR DEFINITION Bug 8732731 evaadd EVAluate ADDition qeruaRowProcedure qerghFetch rwsfcd RWSIMA: fetch from row source qeruaFetch Union ALL row source Fetch Bug 5112093 kcbzfs kcbzfs - free kcbbf state object kcbrls ? Module Notes: Kernal Cache Buffer management Implementation kturax KTUR: Kernel Transaction Undo Recover Active Transaction Bug 3490914 kclalc KCLALC - Allocate and initialize Lock Context kclebs Escalate Buffer State. This routine attempts to make a shared current kddlkr ? Module Notes: Delete rows Bug 715595 atbpre() is trying to find out if there are any rows in the partition being dropped. It does this by calling kdqemp() Bug 3575538 qerjoFetch Fetch from join row source Bug 8993052 qercbiQBCompare - key comparison routine that uses queue buffers smbput SMBIMA: put a record into the memory buffer. sorput SOR: SORt PUT: Insert record into sort Bug 13245023 kzuial kzuial - KZU Internal ALter user or role Bug 182447 (also see http://www.ixora.com.au/notes/log_buffer_usage.htm) kcrfsseq (current log seq. number) written under kcrfal by kcrfnl kcrfsfbb (base disk blk #) written under kcrfal by kcrfwi [LGWR] kcrfsfi (index of current block being filled) written under kcrfal by kcrfwr & kcrfwi [LGWR] kcrfshsb (highest block that needs to be synced) Bug 9105319 kslwaitctx Waits for an event until the specified time elapses or a post occurs. kslwait Wait for N centi-seconds or until posted kmgs_sleep_wait This function should be used in kmgs whenever immediate mode memory is requested from auto-sga. kmgs_create_request Creates and waits for a memory resize request involving a requestor kmgs_immediate_req immediate mode request interface function Bug kxfpbFreeChunkBG which is a background timeout action waiting for the "Child parallel query alloc buffer" latch held by P1122 Bug 10167333 KKSCSAUC 0x00002000 /* auth. check mismatch */ KKSCSTRN 0x00020000 /* translation mismatch */ Bug 10274265 we set the user defined graduated length (kxsusrgl) when we initialize the UGA, ie. the variable is not set if we set event 10503 in the session In 10.1 we set the variable when initializing the cursor via kxspoac() -> kxsggbs(). Bug 3594510 kksald Kernel Kompile Shared Auxiliary Load Function Bug 13507662 'cr request retry', (internal symbol kcbevcr), is not a normal wait event. Bug 5678485 In kcrrrfscda(), we call kcrrrfshdi() to retrieve the last-written AL record, then save the AL seq# to rfxlsa. When primary db gets rfxlsa from standby, it displays it in v$archive_dest_status. In kcrrrfscda(), we call kcrrpa() to prod ARCH to do archival Bug 950154 #define KCRFSFTOP 0x01 /* Thread OPen */ #define KCRFSFRGO 0x02 /* Redo Generation Ok */ #define KCRFSFBAD 0x04 /* single process died in BAD state flag. */ #define KCRFSFSAR 0x08 /* log switch for space Stuck on ARchiver */ #define KCRFSFRBA 0x10 /* RBA capture Ok */ #define KCRFSFSCL 0x20 /* log switch for space Stuck on CLearing */ Bug 14691835 qertbFetchByRowID using underlying row source, fetch by rowid or cluster key. qergiFetch QERGR: FETCH procedure of PX Granule Iterator Row source qerjotFetch Row Source: join - tunneling fetch Bug 3544665 #define NSEACCESSDENIED NSEBASE+16 /* 12546 */ /* * NSEACCESSDENIED: connect operation failed because access was denied * to some object. For example, an NSLISTEN operation will fail with * this error if the adderss is "(ADDRESS=(PROTOCOL=tcp)(PORT=50))" and * the caller is not superuser. */ Bug 2571842 NAME KCRA - Kernel Cache Redo Application/Access FUNCTION Operations for applying redo as part of recovery. /* ** If the controlfile contains an acid and the REDO file header ** contains an acid then the two acids are required to be the same. ** The controlfile acid takes precendence. */ if (mx->kcrmxacid && fx->kcrfxacid && (mx->kcrmxacid != fx->kcrfxacid)) { /* "activation identifier mismatch in archive log %s" */ ksesec1(OER(16067), ksesrgl(name)); } ub4 kcrmxacid; /* Database ACtivation ID. ** The REDO log file header ACID must match the ** database ACID in order for the REDO log to be ** applied. */ D16333_07.PPT ktaiam Kernel Transaction Access, Internal Allocate DML lock ksqgtl Get an enqueue ksqcmi General Get/Convert function (Change Mode Internal) ksipget Get a group lock kjusuc Synchronous upconvert Bug 4861157 ksesin # KSE: signal an internal error (named) ksisie ksires named assert with a string */ ksiget debugging aids */ kqrbpr background process parent object resource - do a bunch of things */ kqrbgl background get instance lock */ Bug 206292 (Product Version 7.0.15) the 3rd arg to ksiget is 0 which means there was no BAST for the request from ksbcic. Bug 13737746 KRR_LOGBUF_FREE 0x1 /* lbuf is on the free list */ This means that the buffer is free when it is expected to be in use or processed. Bug 7234231 Function evareo {evar2v} evareo - EVAluate RElational Operator Compare two operands of relat ional expression. After compare, branch on operator type ( ">", "< ", ">=", "<=", "==", "!=" ) and return TRUE or FALSE. Function expepr {expima} expepr evaluates the argument predicate. It returns the result of the evaluation. If the operator`s ODFFNEARG flag is set (currently only fo r OPTLNN), don`t evaluate the operands. Function expeal {expima} expeal evaluates its argument AND-list. It returns TRUE if argument is true; FALSE if argument is false; and UNKNOWN if argument is unknown. Function rwsfcd {rwsima} RWSIMA: fetch from row source http://books.google.com/books?id=cDy2_QoQplEC&pg=PA46&lpg=PA46#v=onepage&q&f=false the slgdt() function in the orageneric library. This function essentially gets the system time. ... to encrypt the text by calling the kzsrenc() function in the oracommon library. This function basically performs DES key scheduling using the lncgks() function and then uses the lncecb() function to output the cipher text using DES in ECB mode. ... The user creates a copy of their own password hash using the lncupw() function in the oracore library. This hash is then used as the key to decrypt the AUTH_SESSKEY by calling the kzsrdec() function. The server decrypts the AUTH_PASSWORD with the secret number used as the key by calling the kzsrdep() function in the oracommon library Doc ID 783721.1 There are indeed a fixed number of slots for v$session_longops, determined by ksulomux_. Operations on each array are protected by separate "longop free list parent" latches ( controlled by _num_longop_child_latches parameter ). The max number of longop slots is "hardcoded" into Oracle using ksulomx_ variable: Bug 6648515 kcrf_commit_force () << Now WAIT occurs here as kcrfsy () << kcrfsy tells the commit to WAIT Doc ID 453540.1 kxhfWrite: hash-join is spilling to disk Doc ID 1513623.1 memory allocation type "pmuccst: adt/record" is used when Oracle needs to allocate memory for a local variable in PL/SQL code. Doc ID 1315884.1 memory allocation type "pl/sql vc2" is used when Oracle needs to allocate memory for a local variable in PL/SQL code. http://www.ixora.com.au/newsletter/2001_02.htm In kghupr the shared pool latch is taken to unpin a recreatable chunk of memory and add it to the head of one of the shared pool LRU lists. In kglic the library cache hash chains and segmented arrays are scanned Bug 4238390 kglsim_upd_newhp inform simulator about creation of new kgl heap kglobpn KGL2: OBject PiN heaps and load data pieces Bug 2245199 KCRRNSMAXASYNCBLK (Maximum value of async in log_archive_dest_n) Bug 3066549 ksmvpz (PGA variable size) ksmppz (peak variable PGA size) Bug 3198855 kcbkllrba kcbkllrba - Find Lowest Low RBA on checkpoint queues kctrcp kctrcp - Kernel Cache Thread Record Checkpoint Progress kcvcca kcvcca: Checkpoint Check Action ksbcti call timeout/interrupts */ ksbabs KSB: Background process: Action based server Bug 10080007 kprbbin kprbbin - number of BINd variables */ qertrcDumpRow - Tracing row source fetch method qertrcDoActionsRowP qerpxFetch QERPX: fetch qertrcFetch qerstFetch Statistics row source Fetch ... qerltFetch Query Execution Row source Load Table - Fetch http://externaltable.blogspot.ca/2014/11/life-of-oracle-io-tracing-logical-and.html kcbzvb Invoked after Oracle has read a given block Note: this function is used both for reads in the buffer cache and for direct reads kskthbwt Kernel service Kompile thread begin wait. This function is called at the start of an Oracle wait event. kslwtbctx is its parent function call and marks the start of a wait event. kskthewt Kernel service Kompile thread end wait. This function is called at the end of an Oracle wait event. kslwtectx is its parent function call marking the end of a wait event. The suffix "ewt" most likely stands for "end wait". Bug 14149386 lnxmin Functions to construct, destruct, and manipulate krbbs structures. */ ldxdyf msqopnws msqfun Append a function call. */ Bug 9666605 kghalp() invokes kghalf() only if flag KGHDSALOF is set --- (point 1) With event 10049 set step 1) method kglobpn() sets flag KGLDAALN of heap0 of child cursor step 2) with flag KGLDAALN set, flag KGHHFALGN gets set during heap init step 3) finding flag KGLDAALN set, the heap init routine sets heap descriptor (kghds) flag KGHDSFALGN step 4) if flag KGHDSFALGN is set, kghds flag KGHDSALOF does not gets set step 5) If Flag KGHDSALOF is NOT set, kghalp() doesn't invoke kghalf() the opposite would be point (1) if event 10049 is set , kghalp() won't invoke kghalf() Bug 12945376 ksuprc push recursive call k2send server end transaction - 2PC state machine xctctl XaCTion Commit Top Level Transaction in a transaction tree xctcom_with_options kpoltxen kpoltxen - KPO Local TransaXtion ENd transaction driver kpotxen KPOTX: OCI Transaction interface - 2-phase ENd transaction Bug 13552950 kollgsz finds the size of a locator locator originally comes from qertbFetch. Bug 10403522 kollgsz - KOLL Get the SiZe of the input lob locator ORA-07445 [kprball()+681] (Doc ID 742092.1) The KPRB - Kernel PRogrammatic interface Bundled operations. Bug 26378908 : PERIODICALLY CREATE PDB USING DBLINK CAUSES ORA-600 [25010] ON STANDBY krtchk check consistency (with control file) kcfbsy Background SYnchronization of SGA and control file kcfcsy Cross instance SYnc ksbciccb ksbmsg call cpu count changed callbacks Bug 12932744 : INSTANCE CRASH WITH ORA-600 KRCCACP_BADFILE krccacp() Advance the Checkpoint krccckp() Checkpoint krcptmo() CTWR Time out action - this is the main loop. ksbcti() Call timeout interrrupt. ksbabs() Start a bacground process krcpabs() I am CTWR Bug 23302275 : MMON REPORTS ORA-7445 KOCBEG kocbeg KOC: BEGin transaction sskgxp_select Block waiting for data on ports specified by the sports kslwaitns kskthbwt THread Begin WaiT kslwait Wait for N centi-seconds or until posted ksxprcv receive side async request completion notification kjctr_rksxp Receive messages from KSXP kjctrcv kjcsrmg Poll for reconfig. Return 0 if reconfig occurred - meaning that kgxgipc kjmsm Bug 3674549 kjucue signal error ksqsgn MISCELLANEOUS: Procedure to register database namefor */ kcfcmb |* CREATE/MOUNT DATABASE CODE *| kcfmdb Mount DataBase http://blogs.conus.info/node/53 Elfread Tue, 07/27/2010 - 03:03 — dennis https://web.archive.org/web/20260209211358/http://www.dbstyle.net/oracle-%E5%86%85%E9%83%A8%E5%87%BD%E6%95%B0%E5%90%8D%E6%95%B4%E7%90%86.html