Scribd
Upload
84 views

Oracle Functions

This document provides a summary of functions that can assist in evaluating Oracle ora-00600/ora-07445 errors by looking up error strings. It describes files that can be downloaded containing a database of these functions and how to use the files to search for information about specific error codes or strings. The files allow users to search a local SQLite database generated from the function descriptions to aid in troubleshooting Oracle errors.

Uploaded by

dmdunlap
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
84 views

Oracle Functions

This document provides a summary of functions that can assist in evaluating Oracle ora-00600/ora-07445 errors by looking up error strings. It describes files that can be downloaded containing a database of these functions and how to use the files to search for information about specific error codes or strings. The files allow users to search a local SQLite database generated from the function descriptions to aid in troubleshooting Oracle errors.

Uploaded by

dmdunlap
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

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 https://gitlab.com/FritsHoogland/ora_functions. 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 functions.csv and sf.sh. lookup.awk can also be used, as shown in the
example below.

The way to use this is to run sf.sh with a variable e.g.


./sf.sh $1

This can be useful in targeting your triage in the correct direction.

Every time you run sf.sh, it creates a sqlite database file – functions.db from the csv file.

The last 3 csv files don’t seem to be relevant so ignore them.

Some example cases:

1. sf.sh krvxiphd
krvxiphd -- kernel redo recovery extract

2. ./sf.sh kcb
kcb -- kernel cache buffers

3. ./sf.sh kkqsNPfound
kkqsNPFound -- kernel compile query
4. ./sf.sh -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. ./lookup.awk -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

You might also like