Oracle C Functions
Here is a very useful document for Oracle database internals – it’s a small database of functions which
can assist in evaluating ora-00600/ora-07445 errors by looking up the string usually seen with these
errors.
The files to download can be found at [Link] This is for Linux –
you may be able to tweak it for Windows if you fancy writing batch files.
You can download a zip file and when uncompressed, these are the files downloaded:
The files which would be used are [Link] and [Link]. [Link] can also be used, as shown in the
example below.
The way to use this is to run [Link] with a variable e.g.
./[Link] $1
This can be useful in targeting your triage in the correct direction.
Every time you run [Link], it creates a sqlite database file – [Link] from the csv file.
The last 3 csv files don’t seem to be relevant so ignore them.
Some example cases:
1. [Link] krvxiphd
krvxiphd -- kernel redo recovery extract
2. ./[Link] kcb
kcb -- kernel cache buffers
3. ./[Link] kkqsNPfound
kkqsNPFound -- kernel compile query
4. ./[Link] -w krv #wildcard search
krv recovery
krvarf DBMS_LOGMNR.KRVARF ADD_LOGFILE
krvcp DBMS_LOGMNR.KRVCP COLUMN_PRESENT
krvend DBMS_LOGMNR.KRVEND END_LOGMNR
krvg generation of redo with DDL
krvgdrm DBMS_LOGMNR_INTERNAL.KRVGDRM
krviad11202to112 DBMS_LOGMNR_INTERNAL.AGESPILL_11202TO112
krviad112to11 DBMS_LOGMNR_INTERNAL.AGESPILL_112TO11
krviad121to11204 DBMS_LOGMNR_INTERNAL.AGESPILL_121TO11204
krviad12202to122 DBMS_LOGMNR_INTERNAL.AGESPILL_12202TO122
krviad122to12 DBMS_LOGMNR_INTERNAL.AGESPILL_122TO12
krviad122to12202 DBMS_LOGMNR_INTERNAL.AGESPILL_122TO12202
krvialf DBMS_LOGMNR_SESSION_INT.ADD_LOG_FILE
krviarscn DBMS_LOGMNR_INTERNAL.ADVANCE_READ_SCN
krviats DBMS_LOGMNR_SESSION_INT.ATTACH_SESSION
krviau11204to121 DBMS_LOGMNR_INTERNAL.AGESPILL_11204TO121
krviau11to112 DBMS_LOGMNR_INTERNAL.AGESPILL_11TO112
krviau122to12202 DBMS_LOGMNR_INTERNAL.AGESPILL_122TO12202
krviau12to122 DBMS_LOGMNR_INTERNAL.AGESPILL_12TO122
krvicl DBMS_LOGMNR_INTERNAL.LOGMNR_KRVICL
krvicp DBMS_LOGMNR_SESSION_INT.COLUMN_PRESENT
krvics DBMS_LOGMNR_SESSION_INT.CREATE_SESSION
krvidcd DBMS_LOGMNR_INTERNAL.DUMP_CKPT_DATA
krvidib DBMS_LOGMNR_INTERNAL.KRVIDIB
krvidpd DBMS_LOGMNR_INTERNAL.DUMP_PAGEOUT_DATA
krvidscd DBMS_LOGMNR_INTERNAL.DUMP_STREAMS_CKPT_DATA
krvidss DBMS_LOGMNR_SESSION_INT.DESTROY_SESSION
krvidts DBMS_LOGMNR_SESSION_INT.DETACH_SESSION
krviftsi DBMS_LOGMNR_INTERNAL.LOGMNR_KRVIFTSI
krvigrg DBMS_LOGMNR_INTERNAL.GET_ROOT_GLOBAL_NAME
krvild DBMS_LOGMNR_INTERNAL.LOGMNR_KRVILD
krvilss DBMS_LOGMNR_INTERNAL.LOGMNR_KRVILSS
krvilt DBMS_LOGMNR_INTERNAL.LOGMNR_KRVILT
krvimv DBMS_LOGMNR_SESSION_INT.MINE_VALUE
krvips DBMS_LOGMNR_SESSION_INT.PREPARE_SCN_RANGE
krvirlf DBMS_LOGMNR_SESSION_INT.REMOVE_LOG_FILE
krvirs DBMS_LOGMNR_SESSION_INT.RELEASE_SCN_RANGE
krvisda DBMS_LOGMNR_SESSION_INT.SET_DICT_ATTR
krvislegc DBMS_LOGMNR_INTERNAL.KRVISLEQC
krvisobj DBMS_LOGMNR_INTERNAL.SKIP_OBJ_C
krvisrba DBMS_LOGMNR_INTERNAL.SKIP_RBA
krvissp DBMS_LOGMNR_SESSION_INT.SET_SESSION_PARAMETERS
krvisxid DBMS_LOGMNR_INTERNAL.SKIP_XID
krviuld DBMS_LOGMNR_INTERNAL.LOGMNR_KRVIULD
krviulss DBMS_LOGMNR_INTERNAL.LOGMNR_KRVIULSS
krviult DBMS_LOGMNR_INTERNAL.LOGMNR_KRVIULT
krviusobj DBMS_LOGMNR_INTERNAL.UNSKIP_OBJ_C
krviusrba DBMS_LOGMNR_INTERNAL.UNSKIP_RBA
krviusxid DBMS_LOGMNR_INTERNAL.UNSKIP_XID
krvm mine
krvmv DBMS_LOGMNR.KRVMV MINE_VALUE
krvrgse DBMS_LOGMNR_INTERNAL.KRVRGSE
krvrgse2 DBMS_LOGMNR_INTERNAL.KRVRGSE2
krvrmgb DBMS_LOGMNR_INTERNAL.KRVRMGB
krvrrse DBMS_LOGMNR_INTERNAL.KRVRRSE
krvrrrf DBMS_LOGMNR.KRVRRRF REMOVE_LOGFILE
krvs apply service
krvspd DBMS_LOGMNR_INTERNAL.KRVSPD
krvssf survive failure
krvstart DBMS_LOGMNR.KRVSTART START_LOGMNR
krvt log miner viewer support
krvugaclr DBMS_LOGMNR_INTERNAL.KRVUGACLR
krvugaset DBMS_LOGMNR_INTERNAL.KRVUGASET
krvx extract
5. ./[Link] -w kr #only takes first 2 letters
kra : Kernel Recovery Area Function
krb : Kernel Backup Restore
krbabr : Kernel Backup Restore Auto Block Media Recovery
krbb : Kernel Backup Restore creation of a backuppiece
krbc : Kernel Backup Restore controlfile
krbd : Kernel Backup Restore device control
krbi : Kernel Backup Restore ICD
krbm : Kernel Backup Restore miscellaneous functions
krbr : Kernel Backup Restore restore and recovery
krby : Kernel Backup Restore image copy
krc : Recovery Block Change Tracking
krd_end_rcv : end media recovery
krd_implicit_rcv : IMPLICIT ReCoVery for standby open/activation
krp_check_slave_exit : wait for ksv slaves to exit
krp_slave_apply : main redo apply loop
krp_slave_main : main pmr slave callback