ORA-600

ora-600是Oracle对于一些内部错误的一个统一的错误号（类似的还有ora-7445）。要判断ora-600错误具体的类型，一般要根据其第一个参数来区分。一个ora-600的例子如下： ORA-00600: internal error code, arguments: [15700], [3], [0x1DDE1AAB0], [], [], [], [], []

其中15700代表这个错误的具体类型，这是和并行查询相关的一个内部错误，后面的几个参数则是该错误的一些具体参数，不同类型的错误，参数的意义也不尽相同。

ora-600一共有两大类，一类的错误类型以数字标识，另外一类则以字符串标识。数字表示不同的内核层，而字符串则是具体的函数或者模块名。在Metalink的Doc ID: 175982.1中，oracle列举了这两类错误的详细信息，转录在这里以供需要是查询：

 

 

Ora-600 BaseFunctionalityDescription1Service LayerThe service layer has within it a variety of service
related components which are associated with in memory related activities in the SGA such as, for example : the management of Enqueues,
System Parameters, System state objects (these objects track the use of structures in the SGA by Oracle server processes), etc..
In the main, this layer provides support to allow process communication and provides support for locking and the management of structures to support multiple user processes connecting and interacting within the SGA.

Note : vos – Virtual Operating System provides features to support the functionality above. As the name suggests it provides base functionality in much the same way as is provided by an Operating System.

Ora-600 Base Functionality Description 1vosComponent notifier100vosDebug300vosError500vosLock700vosMemory900vosSystem Parameters1100vosSystem State object1110vosGeneric Linked List management1140vosEnqueue1180vosInstance Locks1200vosUser State object1400vosAsync Msgs1700voslicense Key1800vosInstance Registration1850vosI/O Services components2000Cache LayerWhere errors are generated in this area, it is advisable
to check whether the error is repeatable and whether the error is perhaps associated with recovery or undo type operations; where
this is the case and the error is repeatable, this may suggest some kind of hardware or physical issue with a data file, control
file or log file. The Cache layer is responsible for making the changes to the underlying files and well as managing the related memory structures in the SGA.

Note : rcv indicates recovery. It is important to remember that the Oracle cache layer is effectively going through the same code paths as used by the recovery mechanism.

Ora-600 Base Functionality Description 2000server/rcvCache Op2100server/rcvControl File mgmt2200server/rcvMisc (SCN etc.)2400server/rcvBuffer Instance Hash Table2600server/rcvRedo file component2800server/rcvDb file3000server/rcvRedo Application3200server/cacheBuffer manager3400server/rcvArchival & media recovery component3600server/rcvrecovery component3700server/rcvThread component3800server/rcvCompatibility segment

It is important to consider when the error occurred and the context in which the error was generated. If the error does not reproduce, it may be an in memory issue.

4000Transaction LayerPrimarily the transaction layer is involved with maintaining
structures associated with the management of transactions. As with the cache layer , problems encountered in this layer may indicate some kind of issue at a physical level. Thus it is important to try and repeat the same steps to see if the problem recurs.

Ora-600 Base Functionality Description 4000server/txnTransaction Undo4100server/txnTransaction Undo4210server/txnTransaction Parallel4250server/txnTransaction List4300space/spcmgmtTransaction Segment4400txn/lcltxTransaction Control4450txn/lcltxdistributed transaction control4500txn/lcltxTransaction Block4600space/spcmgmtTransaction Table4800dict/rowcacheQuery Row Cache4900space/spcmgmtTransaction Monitor5000space/spcmgmtTransaction Extent

It is important to try and determine what the object involved in any reproducible problem is. Then
use the analyze command. For more information, please refer to the analyze command as detailed in the context ofNote 28814.1; in addition, it may be worth using the dbverify as discussed inNote 35512.1.

6000Data LayerThe data layer is responsible for maintaining and managing
the data in the database tables and indexes. Issues in this area may indicate some kind of physical issue at the object level and
therefore, it is important to try and isolate the object and then perform an anlayze on the object to validate its structure.

Ora-600 Base Functionality Description 6000ram/data
ram/analyze
ram/indexdata, analyze command and index related activity7000ram/objectlob related errors8000ram/datageneral data access8110ram/indexindex related8150ram/objectgeneral data access

Again, it is important to try and determine what the object involved in any reproducible problem is.
Then use the analyze command. For more information, please refer to the analyze command as detailed in the context ofNote 28814.1; in addition, it may be worth using the dbverify as discussed inNote 35512.1.

12000User/Oracle Interface & SQL Layer ComponentsThis layer governs the user interface with the Oracle
server. Problems generated by this layer usually indicate : some kind of presentation or format error in the data received by the
server, i.e. the client may have sent incomplete information; or there is some kind of issue which indicates that the data is received out of sequence

Ora-600 Base Functionality Description 12200progint/kpo
progint/opilob related
errors at interface level on server side, xa , etc.12300progint/ifOCI interface to coordinating global transactions12400sqlexec/rowsrctable row source access12600space/spcmgmtoperations associated with tablespace : alter / create / drop operations ; operations associated with create table / cluster12700sqlexec/rowsrcbad rowid13000dict/ifdictionary access routines associated with kernel compilation13080ram/indexkernel Index creation13080sqllang/integconstraint mechanism13100progint/opiarchival and Media Recovery component13200dict/sqlddlalter table mechanism13250security/auditaudit statement processing13300objsupp/objdatasupport for handling of object generation and object access14000dict/sqlddlsequence generation15000progint/kpologon to Oracle16000tools/sqlldrsql loader related

You should try and repeat the issue and with the use of sql trace , try and isolate where exactly the issue may be occurring within the application.

14000System Dependent Component internal error valuesThis layer manages interaction with the OS. Effectively
it acts as the glue which allows the Oracle server to interact with the OS. The types of operation which this layer manages are indicated as follows.

Ora-600 Base Functionality Description 14000osdsFile access14100osdsConcurrency management;14200osdsProcess management;14300osdsException-handler or signal handler management14500osdsMemory allocation15000security/dac,
security/logon
security/ldaplocal user access validation; challenge / response activity for
remote access validation; auditing operation; any activities associated with granting and revoking of privileges; validation of password with external password file15100dict/sqlddlthis component manages operations associated with creating, compiling (altering), renaming, invalidating, and dropping procedures, functions, and packages.15160optim/cbocost based optimizer layer is used to determine optimal path to the data based on statistical information available on the relevant tables and indexes.15190optim/cbocost based optimizer layer. Used in the generation of a new index to determine how the index should be created. Should it be constructed from the table data or from another index.15200dict/shrdcursused to in creating sharable context area associated with shared cursors15230dict/sqlddlmanages the compilation of triggers15260dict/dictlkup
dict/libcachedictionary lookup and library cache access15400server/drvmanages alter system and alter session operations15410progint/ifmanages compilation of pl/sql packages and procedures15500dict/dictlkupperforms dictionary lookup to ensure semantics are correct15550sqlexec/execsvc
sqlexec/rowsrchash join execution management;
parallel row source management15600sqlexec/pqcomponent provides support for Parallel Query operation15620repl/snapshotsmanages the creation of snapshot or materialized views as well as related snapshot / MV operations15640repl/defrdrpclayer containing various functions for examining the deferred transaction queue and retrieving information15660jobqs/jobqmanages the operation of the Job queue background processes15670sqlexec/pqcomponent provides support for Parallel Query operation15700sqlexec/pqcomponent provides support for Parallel Query operation; specifically mechanism for starting up and shutting down query slaves15800sqlexec/pqcomponent provides support for Parallel Query operation15810sqlexec/pqcomponent provides support for Parallel Query operation; specifically functions for creating mechanisms through which Query co-ordinator can communicate with PQ slaves;15820sqlexec/pqcomponent provides support for Parallel Query operation15850sqlexec/execsvccomponent provides support for the execution of SQL statements15860sqlexec/pqcomponent provides support for Parallel Query operation16000loadersql Loader direct load operation;16150loaderthis layer is used for ‘C’ level call outs to direct loader operation;16200dict/libcachethis is part of library Cache operation. Amongst other things it manages the dependency of SQL objects and tracks who is permitted to access these objects;16230dict/libcachethis component is responsible for managing access to remote objects as part of library Cache operation;16300mts/mtsthis component relates to MTS (Multi Threaded Server) operation16400dict/sqlddlthis layer contains functionality which allows tables to be loaded / truncated and their definitions to be modified. This is part of dictionary operation;16450dict/libcachethis layer layer provides support for multi-instance access to the library cache; this functionality is applicable therefore to OPS environments;16500dict/rowcachethis layer provides support to load / cache Oracle’s dictionary in memory in the library cache;16550sqlexec/fixedtabthis component maps data structures maintained in the Oracle code to fixed tables such that they can be queried using the SQL layer;16600dict/libcachethis layer performs management of data structures within the library cache;16651dict/libcachethis layer performs management of dictionary related information within library Cache;16701dict/libcachethis layer provides library Cache support to support database creation and forms part of the bootstrap process;17000dict/libcachethis is the main library Cache manager. This Layer maintains the in memory representation of cached sql statements together will all the necessary support that this demands;17090generic/vosthis layer implementations error management operations: signalling errors, catching errors, recovering from errors, setting error frames, etc.;17100generic/vosHeap manager. The Heap manager manages the storage of internal
data in an orderly and consistent manner. There can be many heaps serving various purposes; and heaps within heaps. Common examples
are the SGA heap, UGA heap and the PGA heap. Within a Heap there are consistency markers which aim to ensure that the Heap is always in a consistent state. Heaps are use extensively and are in memory structures – not on disk.17200dict/libcachethis component deals with loading remote library objects into the local library cache with information from the remote database.17250dict/libcachemore library cache errors ; functionality for handling pipe operation associated with dbms_pipe17270dict/instmgmtthis component manages instantiations of procedures, functions,
packages, and cursors in a session. This provides a means to keep track of what has been loaded in the event of process death;17300generic/vosmanages certain types of memory allocation structure. This functionality is an extension of the Heap manager.17500generic/vosrelates to various I/O operations. These relate to async i/o operation, direct i/o operation and the management of writing buffers from the buffer cache by potentially a number of database writer processes;17625dict/libcacheadditional library Cache supporting functions17990plsqlplsql ‘standard’ package related issues18000txn/lcltxtransaction and savepoint management operations19000optim/cbocost based optimizer related operations20000ram/indexbitmap index and index related errors.20400ram/partnmapoperations on partition related objects20500server/rcvserver recovery related operation21000repl/defrdrpc,
repl/snapshot,
repl/triggerreplication related features23000oltp/qsAQ related errors.24000dict/libcacheoperations associated with managing stored outlines25000server/rcvtablespace management operations

 

 

Error Mnemonic(s)FunctionalityDescriptionain ainp ram/indexain – alter index; ainp - alter index partition management operationapacb optim/rboused by optimizer in connect by processingatb atbi atbo ctc ctci cvw dict/sqlddlalter table , create table (IOT) or cluster operations as well as create view related operations (with constraint handling functionality)dbsdrvsqllang/parsealter / create database operationddfnet progint/distribvarious distributed operations on remote dictionarydelexe sqlexec/dmldrvmanages the delete statement operationdix ram/indexmanages drop index or validate index operationdtb dict/sqlddlmanages drop table operationevaa2g evah2p evaa2g dbproc/sqlfuncvarious functions involves in evaluating operand outcomes such
as : addition , average, OR operator, bites AND , bites OR, concatenation, as well as Oracle related functions : count(), dump() , etc. The list is extensive.expcmo expgon dbproc/exprevalhandles expression evaluation with respect to two operands being equivalentgra security/dacmanages the granting and revoking of privilege rights to a usergslcsq plsldapsupport for operations with an LDAP serverin***e sqlexec/dmldrvhandles the insert statement operationjox progint/opifunctionality associated with the Java compiler and with the Java runtime environment within the Serverk2c k2d progint/distribsupport for database to database operation in distributed environements as well as providing, with respect to the 2-phase commit protocol, a globally unique Database idk2g k2ltxn/disttxsupport for the 2 phase commit protocol protocol and the coordination of the various states in managing the distributed transactionk2r k2s k2sp progint/distribk2r – user interface for managing distributed transactions and
combining distributed results ; k2s – handles logging on, starting a transaction, ending a transaction and recovering a transaction; k2sp – management of savepoints in a distributed environment.k2v txn/disttxhandles distributed recovery operationkad cartserv/picklercshandles OCIAnyData implementationkau ram/datamanages the modification of indexes for inserts, updates and delete operations for IOTs as well as modification of indexes for IOTskcb kcbb kcbk kcbl kcbs kcbt kcbw kcbz cachemanages Oracle’s buffer cache operation as well as operations used by capabilities such as direct load, has clusters , etc.kcc kcf rcvmanages and coordinates operations on the control file(s)kcit context/triggerinternal trigger functionalitykck rcvcompatibility related checks associated with the compatible parameterkcl cachebackground lck process which manages locking in a RAC or parallel server multiple instance environmentkco kcq kcra kcrf kcrfr kcrfw kcrp kcrr kcs kct kcv rcvvarious buffer cache operation such as quiesce operation , managing fast start IO target, parallel recovery operation , etc.kd ram/datasupport for row level dependency checking and some log miner operationskda ram/analyzemanages the analyze command and collection of statisticskdbl kdc kdd ram/datasupport for direct load operation, cluster space management and deleting rowskdg ram/analyzegathers information about the underlying data and is used by the analyze commandkdi kdibc3 kdibco kdibh kdibl kdibo kdibq kdibr kdic kdici kdii kdil kdir kdis kdiss kdit kdkram/indexsupport of the creation of indexes on tables an IOTs and index look upkdl kdlt ram/objectlob and temporary lob managementkdo ram/dataoperations on data such as inserting a row piece or deleting a row piecekdrp ram/analyzeunderlying support for operations provided by the dbms_repair packagekds kdt kdu ram/dataoperations on data such as retrieving a row and updating existing row datakdv kdx ram/indexfunctionality for dumping index and managing index blockskfc kfd kfg asmsupport for ASM file and disk operationskfh kfp kft rcvsupport for writing to file header and transportable tablespace operationskgaj kgam kgan kgas kgat kgav kgaz argusdbg/argusdbgsupport for Java Debug Wire Protocol (JDWP) and debugging faciliteskgbt kgg kgh kghs kghx kgkpvoskgbt – support for BTree operations; kgg – generic lists processing;
kgh – Heap Manager : managing the internal structures withing the SGA / UGA / PGA and ensures their integrity; kghs – Heap manager with Stream support; kghx – fixed sized shared memory manager; kgkp – generic services scheduling policieskgl kgl2 kgl3 kgla kglp kglr kgls dict/libcachegeneric library cache operationkgm kgmt ilmssupport for inter language method services – or calling one language from anotherkgrq kgsk kgski kgsn kgss vossupport for priority queue and scheduling; capabilities for Numa support; Service State object managerkgupa kgupb kgupd0 kgupf kgupg kgupi kgupl kgupm kgupp kgupt kgupx kguq2 kguuvosService related activities activities associated with for Process
monitor (PMON); spawning or creating of background processes; debugging; managing process address space; managing the background processes; etc.kgxp vosinter process communication related functionskjak kjat kjb kjbl kjbm kjbr kjcc kjcs kjctc kjcts kjcv kjdd kjdm kjdr kjdx kjfc kjfm kjfs kjfz kjg kji kjl kjm kjp kjr kjs kjt kju kjxccl/dlmdlm related functionality ; associated with RAC or parallel server operationkjxgf kjxgg kjxgm kjxgn kjxgna kjxgr ccl/cgsprovides communication & synchronisation associated with GMS or OPS related functionality as well as name service and OPS Instance Membership Recovery Facilitykjxt ccl/dlmDLM request message managementkjzc kjzd kjzf kjzg kjzm ccl/diagsupport for diagnosibility amongst OPS related serviceskkb dict/sqlddlsupport for operatoins which load/change table definitionskkbl kkbn kkbo objsupp/objddlsupport for tables with lobs , nested tables and varrays as well as columns with objectskkdc kkdl kkdo dict/dictlkupsupport for constraints, dictionary lookup and dictionary support for objectskke optim/cboquery engine cost engine; provides support functions that provide cost estimates for queries under a number of different circumstanceskkfd sqlexec/pqsupport for performing parallel query operationkkfi optim/cbooptimizer support for matching of expressions against functional ndexeskkfr kkfs sqlexec/pqsupport for rowid range handling as well as for building parallel query query operationskkj jobqs/jobqjob queue operationkkkd kkki dict/dbschedresource manager related support. Additionally, provides underlying functions provided by dbms_resource_manager and dbms_resource_manager_privs packageskklr dict/sqlddlprovides functions used to manipulate LOGGING and/or RECOVERABLE attributes of an object (non-partitioned table or index or partitions of a partitioned table or index)kkm kkmi dict/dictlkupprovides various semantic checking functionskkn ram/analyzesupport for the analyze commandkko kkocri optim/cboCost based Optimizer operation : generates alternative execution
plans in order to find the optimal / quickest access to the data. Also , support to determine cost and applicability of scanning a given index in trying to create or rebuild an index or a partition thereofkkpam kkpap ram/partnmapsupport for mapping predicate keys expressions to equivalent partitionskkpo kkpoc kkpod dict/partnsupport for creation and modification of partitioned objectskkqg kkqs kkqs1 kkqs2 kkqs3 kkqu kkqv kkqw optim/vwsubqquery rewrite operationkks kksa kksh kksl kksm dict/shrdcurssupport for managing shared cursors/ shared sqlkkt dict/sqlddlsupport for creating, altering and dropping trigger definitions as well as handling the trigger operationkkxa repl/defrdrpcunderlying support for dbms_defer_query package operationskkxb dict/sqlddllibrary cache interface for external tableskkxl dict/plsicdsunderlying support for the dbms_lob packagekkxm progint/opisupport for inter language method serviceskkxs dict/plsicdsunderlying support for the dbms_sys_sql packagekkxt repl/triggersupport for replication internal trigger operationkkxwtp progint/opientry point into the plsql compilerkky drvsupport for alter system/session commandskkz kkzd kkzf kkzg kkzi kkzj kkzl kkzo kkzp kkzq kkzr kkzu kkzvrepl/snapshotsupport for snapshots or Materialized View validation and operationkla klc klcli klx tools/sqlldrsupport for direct path sql loader operationkmc kmcp kmd kmm kmr mts/mtssupport for Multi Threaded server operation (MTS) : manange and
operate the virtual circuit mechanism, handle the dispatching of massages, administer shared servers and for collecting and maintaining statistics associated with MTSknac knafh knaha knahc knahf knahs repl/applyreplication apply operation associated with Oracle streamskncc repl/repcachesupport for replication related information stored and maintained in library cachekncd knce repl/defrdrpcreplication related enqueue and dequeue of transction data as well as other queue related operationskncog repl/repcachesupport for loading replicaiton object group information into library cachekni repl/triggersupport for replication internal trigger operationknip knip2 knipi knipl knipr knipu knipu2 knipx repl/intpkgsupport for replication internal package operation.kno repl/repobjsupport for replication objectsknp knpc knpcb knpcd knpqc knps repl/defrdrpcoperations assocaied with propagating transactions to a remote node and coordination of this activity.knst repl/statsreplication statistics collectionknt kntg kntx repl/triggersupport for replication internal trigger operationkoc objmgmt/objcachesupport for managing ADTs objects in the OOCI heapkod objmgmt/datamgrsupport for persistent storage for objects : for read/write objects, to manage object IDs, and to manage object concurrency and recovery.koh objmgmt/objcacheobject heap manager provides memory allocation services for objectskoi objmgmt/objmgrsupport for object typeskoka objsupp/objdatasupport for reading images, inserting images, updating images, and deleting images based on object references (REFs).kokb kokb2 objsupp/objsqlsupport for nested table objectskokc objmgmt/objcachesupport for pinning , unpinning and freeing objectskokd objsupp/datadrvdriver on the server side for managing objectskoke koke2 koki objsupp/objsqlsupport for managing objectskokl objsupp/objdatalob accesskokl2 objsupp/objsqllob DML and programmatic interface supportkokl3 objsupp/objdataobject temporary LOB supportkokle kokm objsupp/objsqlobject SQL evaluation functionskokn objsupp/objnamenaming support for objectskoko objsupp/objsupsupport functions to allow oci/rpi to communicate with Object Management Subsystem (OMS).kokq koks koks2 koks3 koksr objsupp/objsqlquery optimisation for objects , semantic checking and semantic rewrite operationskokt kokt2 kokt3 objsupp/objddlobject compilation type managerkoku kokv objsupp/objsqlsupport for unparse object operators and object view supportkol kolb kole kolf kolo objmgmt/objmgrsupport for object Lob buffering , object lob evaluation and object Language/runtime functions for Opaque typeskope2 kopi2 kopo kopp2 kopu koputil kopzobjmgmt/pickler8.1 engine implementation, implementation of image ops for 8.1+ image format together with various pickler related support functionskos objsupp/objsupobject Stream interfaces for images/objectskot kot2 kotg objmgmt/typemgrsupport for dynamic type operations to create, delete, and update types.koxs koxx objmgmt/objmgtobject generic image Stream routines and miscellaneous generic object functionskpcp kpcxlt progint/kpcKernel programmatic connection pooling and kernel programmatic common type XLT translation routineskpki progint/kpkikernel programatic interface supportkpls cartserv/corecssupport for string formatting operationskpn progint/kpnsupport for server to server communicationkpoal8 kpoaq kpob kpodny kpodp kpods kpokgt kpolob kpolon kponprogint/kposupport for programmatic operationskpor progint/opisupport for streaming protocol used by replicationkposc progint/kposupport for scrollable cursorskpotc progint/opioracle side support functions for setting up trusted external procedure callbackskpotx kpov progint/kposupport for managing local and distributed transaction coordination.kpp2 kpp3 sqllang/parsekpp2 – parse routines for dimensions;
kpp3 – parse support for create/alter/drop summary statementskprb kprc progint/rpisupport for executing sql efficiently on the Oracle server side as well as for copying data types during rpi operationskptsc progint/twotaskcallback functions provided to all streaming operation as part of replication functionalitykpu kpuc kpucp progint/kpuOracle kernel side programmatic user interface, cursor management functions and client side connection pooling supportkqan kqap kqas argusdbg/argusdbgserver-side notifiers and callbacks for debug operations.kql kqld kqlp dict/libcacheSQL Library Cache manager – manages the sharing of sql statements in the shared poolkqr dict/rowcacherow cache management. The row cache consists of a set of facilities to provide fast access to table definitions and locking capabilities.krbi krbx krby krcr krd krpi rcvBackup and recovery related operations :
krbi
- dbms_backup_restore package underlying support.; krbx - proxy copy controller; krby – image copy; krcr – Recovery Controlfile Redo; krd – Recover Datafiles (Media & Standby Recovery); krpi – support for the package : dbms_pitrkrvg krvt rcv/vwrkrvg – support for generation of redo associated with DDL; krvt – support for redo log miner viewer (also known as log miner)ksa ksdp ksdx kse ksfd ksfh ksfq ksfv ksi ksim ksk ksl ksm ksmd ksmg ksn ksp kspt ksq ksr kss ksst ksu ksutvossupport for various kernel associated capabilitiesksxsqlexec/execsvcsupport for query execution associated with temporary tablesksxa ksxp ksxr vossupport for various kernel associated capabilities in relation to OPS or RAC operationkta space/spcmgmtsupport for DML locks and temporary tables associated with table accessktb ktbt ktc txn/lcltxtransaction control operations at the block level : locking block, allocating space within the block , freeing up space, etc.ktec ktef ktehw ktein ktel kteop kteu space/spcmgmtsupport for extent management operations :
ktec
- extent concurrency operations; ktef – extent format; ktehw – extent high water mark operations; ktein – extent information operations; ktel – extent support for sql loader; kteop – extent operations : add extent to segment, delete extent, resize extent, etc. kteu – redo support for operations changing segment header / extent mapktf txn/lcltxflashback supportktfb ktfd ktft ktm space/spcmgmtktfb – support for bitmapped space manipulation of files/tablespaces; ktfd – dictionary-based extent management; ktft – support for temporary file manipulation; ktm – SMON operationktp ktpr ktr ktri txn/lcltxktp – support for parallel transaction operation; ktpr – support
for parallel transaction recovery; ktr – kernel transaction read consistency;
ktri – support for dbms_resumable packagektsa ktsap ktsau ktsb ktscbr ktsf ktsfx ktsi ktsm ktsp ktss ktst ktsx ktt kttmspace/spcmgmtsupport for checking and verifying space usagektu ktuc ktur ktusm txn/lcltxinternal management of undo and rollback segmentskwqa kwqi kwqic kwqid kwqie kwqit kwqj kwqm kwqn kwqo kwqp kwqs kwqu kwqxoltp/qssupport for advanced queuing :
kwqa
- advanced queue administration; kwqi – support for AQ PL/SQL trusted callouts; kwqic – common AQ support functions; kwqid – AQ
dequeue support; kwqie – AQ enqueu support ; kwqit – time management operation ; kwqj – job queue scheduler for propagation; kwqm
- Multiconsumer queue IOT support; kwqn – queue notifier; kwqo – AQ support for checking instType checking options; kwqp – queueing propagation; kwqs – statistics handling; kwqu – handles lob data. ; kwqx – support for handling transformationskwrc kwre oltp/rerules engine evaluationkxcc kxcd kxcs sqllang/integconstraint processingkxdrsqlexec/dmldrvDML driver entrypointkxfp kxfpb kxfq kxfr kxfx sqlexec/pqparallel query supportkxhf kxib sqlexec/execsvckhhf- support for hash join file and memory management; kxib – index buffering operationskxs dict/instmgmtsupport for executing shared cursorskxti kxto kxtr dbproc/triggersupport for trigger operationkxtt ram/partnmapsupport for temporary table operationskxwph ram/datasupport for managing attributes of the segment of a table / cluster / table-partitionkza security/auditsupport for auditing operationskzar security/dacsupport for application auditingkzck security/cryptoencryption supportkzd security/dacsupport for dictionary access by security related functionskzec security/dbencryptionsupport inserting and retrieving encrypted objects into and out of the databasekzfa kzft security/auditsupport for fine grained auditingkzia security/logonidentification and authentication operationskzp kzra kzrt kzs kzu kzup security/dacsecurity related operations associated with privilegesmsqima msqimb sqlexec/sqlgensupport for generating sql statmentsncodef npi npil npixfr progint/npisupport for managing remote network connection from within the server itselfoba sqllang/outbufaloperator buffer allocate for various types of operators : concatenate, decode, NVL, etc. the list is extensive.ocik progint/ociOCI oracle server functionsopiaba opidrv opidsa opidsc opidsi opiexe opifch opiino opilng opipar opipls opirip opitsk opixprogint/opiOPI Oracle server functions – these are at the top of the server stack and are called indirectly by ythe client in order to server the client request.orlr objmgmt/objmgrsupport for C langauge interfaces to user-defined types (UDTs)orp objmgmt/pickleroracle’s external pickler / opaque type interfacespesblt pfri pfrsqc plsql/coxpesblt – pl/sql built in interpreter; pfri – pl/sql runtime; pfrsqc – pl/sql callbacks for array sql and dml with returningpiht plsql/gen/utlsupport for pl/sql implementation of utl_http packagepirg plsql/cli/utl_rawsupport for pl/sql implementation of utl_raw packagepism plsql/cli/utl_smtpsupport for pl/sql implementation of utl_smtp packagepitcb plsql/cli/utl_tcpsupport for pl/sql implementation of utl_tcp packagepiur plsql/gen/utl_urlsupport for pl/sql implementation of utl_url packageplio plsql/pkgpl/sql object instantiationplslm plsql/coxsupport for NCOMP processingplsm pmuc pmuo pmux objmgmt/polsupport for pl/sql handling of collectionsprifold priold plsql/coxsupport to allow rpc forwarding to an older releaseprm sqllang/paramparameter handling associated with sql layerprsa prsc prssz sqllang/parseprsa – parser for alter cluster command; prsc – parser for create database command; prssz – support for parse context to be savedpsdbnd psdevn progint/dbpsdpsdbnd – support for managing bind variables; psdevn – support for pl/sql debuggerpsdicd progint/plsicdssmall number of ICD to allow pl/sql to call into ‘C’ sourcepsdmsc psdpgi progint/dbpsdpsdmsc – pl/sql system dependent miscellaneous functions ; psdpgi – support for opening and closing cursors in pl/sqlpsf plsql/plspl/sql service related functions for instantiating called pl/sql unit in library cacheqbadrv qbaopn sqllang/qrybufalprovides allocation of buffer and control structures in query executionqcdl qcdo dict/dictlkupqcdl – query compile semantic analysis; qcdo – query compile dictionary support for objectsqci dict/shrdcurssupport for SQL language parser and semantic analyserqcop qcpi qcpi3 qcpi4 qcpi5 sqllang/parsesupport for query compilation parse phaseqcs qcs2 qcs3 qcsji qcso dict/dictlkupsupport for semantic analysis by SQL compilerqct qcto sqllang/typeconvqct – query compile type check operations; qcto - query compile type check operatorsqcu sqllang/parsevarious utilities provided for sql compilationqecdrv sqllang/qryedchkdriver performing high level checks on sql language query capabilitiesqerae qerba qerbc qerbi qerbm qerbo qerbt qerbu qerbx qercb qercbi qerco
qerdl qerep qerff qerfi qerfl qerfu qerfx qergi qergr qergs qerhc qerhj qeril qerim qerix qerjm qerjo qerle qerli qerlt qerns qeroc qeroi qerpa qerpf qerpx qerrm qerse qerso qersq qerst qertb qertq qerua qerup qerus qervw qerwn qerxtsqlexec/rowsrcrow source operators :
qerae – row source
(And-Equal) implementation; qerba – Bitmap Index AND row source; qerbc – bitmap index compaction row source; qerbi – bitmap index
creation row source; qerbm – QERB Minus row source; qerbo – Bitmap Index OR row source; qerbt – bitmap convert row source; qerbu – Bitmap Index Unlimited-OR row source; qerbx – bitmap index access row source; qercb – row source: connect by; qercbi – support
for connect by; qerco – count row source; qerdl – row source delete; qerep – explosion row source; qerff – row source fifo buffer;
qerfi – first row row source; qerfl – filter row source definition; qerfu – row source: for update; qerfx – fixed table row source; qergi – granule iterator row source; qergr – group by rollup row source; qergs – group by sort row source; qerhc – row
sources hash clusters; qerhj – row source Hash Join; qeril – In-list row source; qerim – Index Maintenance row source; qerix – Index row source; qerjo – row source: join; qerle – linear execution row source implementation; qerli – parallel create
index; qerlt – row source populate Table; qerns – group by No Sort row source; qeroc – object collection iterator row source; qeroi – extensible indexing query component; qerpa – partition row sources; qerpf – query execution row source: prefetch;
qerpx – row source: parallelizer; qerrm – remote row source; qerse – row source: set implementation; qerso – sort row source; qersq
- row source for sequence number; qerst – query execution row sources: statistics; qertb – table row source; qertq – table queue row source; qerua – row source : union-All;
qerup – update row source; qerus – upsert row source ; qervw – view row source; qerwn – WINDOW row source; qerxt – external table fetch row sourceqes3t qesa qesji qesl qesmm qesmmc sqlexec/execsvcrun time support for sql executionqkacon qkadrv qkajoi qkatab qke qkk qkn qkna qkne sqlexec/rwsallocSQL query dynamic structure allocation routinesqks3t sqlexec/execsvcquery execution service associated with temp table transformationqksmm qksmms qksop sqllang/compsvcqksmm - memory management services for the SQL compiler; qksmms – memory management simulation services for the SQL compiler; qksop – query compilation service for operand processingqkswc sqlexec/execsvcsupport for temp table transformation associated for with clause.qmf xmlsupp/utilsupport for ftp server; implements processing of ftp commandsqmr qmrb qmrs xmlsupp/resolversupport hierarchical resolverqms xmlsupp/datasupport for storage and retrieval of XOBsqmurs xmlsupp/urisupport for handling URIsqmx qmxsax xmlsupp/dataqmx – xml support; qmxsax – support for handling sax processingqmxtc xmlsupp/sqlsuppsupport for ddl and other operators related to the sql XML supportqmxtgx xmlsuppsupport for transformation : ADT -> XMLqmxtsk xmlsupp/sqlsuppXMLType support functionsqsme summgmt/dictsummary management expression processingqsmka qsmkz dict/dictlkupqsmka – support to analyze request in order to determine whether a summary could be created that would be useful; qsmkz – support for create/alter summary semantic analysisqsmp qsmq qsmqcsm qsmqutl summgmt/dictqsmp – summary management partition processing; qsmq – summary
management dictionary access; qsmqcsm – support for create / drop / alter summary and related dimension operations; qsmqutl – support for summariesqsms summgmt/advsvrsummary management advisorqxdid objsupp/objddlsupport for domain index ddl operationsqxidm objsupp/objsqlsupport for extensible index dml operationsqxidp objsupp/objddlsupport for domain index ddl partition operationsqxim objsupp/objsqlextensible indexing support for objectsqxitex qxopc qxope objsupp/objddlqxitex – support for create / drop indextype; qxope – execution time support for operator callbacks; qxope – execution time support for operator DDLqxopq qxuag qxxm objsupp/objsqlqxopq – support for queries with user-defined operators; qxuag – support for user defined aggregate processing; qxxm – queries involving external tablesrfmon rfra rfrdb rfrla rfrm rfrxpt drsimplements 9i data guard broker monitorrnm dict/sqlddlmanages rename statement operationrpi progint/rpirecursive procedure interface which handles the the environment setup where multiple recursize statements are executed from one top level statementrwoima sqlexec/rwoprndsrow operand operationsrwsima sqlexec/rowsrcrow source implementation/retrieval according to the defining querysdbima sqlexec/sortmanages and performs sort operationselexe sqlexec/dmldrvhandles the operation of select statement executionskgm osdsplatform specific memory management rountines interfacing with O.S. allocation functionssmbima sor sqlexec/sortmanages and performs sort operationsqn dict/sqlddlsupport for parsing references to sequencessrdima srsima stsima sqlexec/sortmanages and performs sort operationtbsdrv space/spcmgmtoperations for executing create / alter / drop tablespace and related supporting functionsttcclr ttcdrv ttcdty ttcrxh ttcx2y progint/twotasktwo task common layer which provides high level interaction and
negotiation functions for Oracle client when communicating with the server. It also provides important function of converting client side data / data types into equivalent on the server and vice versauixexe ujiexe updexe up***e sqlexec/dmldrvsupport for : index maintenance operations, the execution of the
update statement and associated actions connected with update as well as the upsert command which combines the operations of update and insertvop optim/vwsubqview optimisation related functionalityxct txn/lcltxsupport for the management of transactions and savepoint operationsxpl sqlexec/expplansupport for the explain plan commandxty sqllang/typeconvtype checking functionszlke security/ols/intextlabel security error handling component

 

三. 其他参数说明

在MOS 的文档： [ID28929.1] 上有说明。

ORA-600[2662] Block SCN is ahead of Current SCN [ID 28929.1]

http://blog.csdn.net/tianlesoftware/article/details/6106130

Oracle DB 服务器 系统时间修改问题 与 SCN 关系的深入研究

http://blog.csdn.net/tianlesoftware/article/details/6163859

ORA-600 各个参数的格式和说明如下：

ERROR:

ORA-600 [2662] [a] [b] [c] [d] [e]

ARGUMENTS:

Arg [a] Current SCN WRAP

Arg [b] Current SCN BASE

Arg [c] dependent SCN WRAP

Arg [d] dependent SCN BASE

Arg [e] Where present this is the DBA wherethe dependent SCN came from.

注意，这里的DBA 指的是Data Block Address. 相关说明，参考我的Blog：

Oracle rdba和 dba 说明

http://blog.csdn.net/tianlesoftware/article/details/6529346

From kcrf.h:

Ifthe SCN comes from the recent or current SCN then a dba of zero is saved. If itcomes from undo$ because the undo segment is not available then the undosegment number is saved, which looks like a block from file 0. If the SCN isfor a media recovery redo (i.e. block number == 0 in change vector), then thedba is for block 0 of the relevant datafile. If it is from another database fora distributed transaction then dba is DBAINF(). If it comes from a TX lock thenthe dba is really usn<<16+slot.

在MOS 的文档：[ID 365536.1] 里提到了SCN 与SCN WRAP，SCN BASE这两个参数的关系。

SCN value is storedinternally as :

（1）SCN_wrap

（2）SCN_base

Wheneverthe SCN is incremented, the BASE component is incremented first unil it reachesit maximum. Once the BASE reaches the maximum value allowed, it is initializedto zero again after incrementing the WRAP by 1.

--开始时WRAP 为0，即SCN_WRP=0.当BASE增长到最大值后，SCN_BAS变为0. 同时SCN_WRP增长到1

Using this logic, we cancalculate the timestamp of the SCN as follows:

(SCN_WRP* 4294967296) + SCN_BAS should give us the SCN in the number format

--SCN 的计算公式，这里我们看出SCN 是根据SCN_BAS计算出来的。和系统时间是没有关系的。 只是方便我们来进行操作，如闪回恢复，而将SCN 和 系统时间每隔5分钟进行一次映射。 映射完后，由SMON进程将映射关系写入SMON_SCN_TIME表。 可以把SCN 看成是Oracle内部的时间。

To get the time/date for an SCN value in9i, use the following example:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

-- (a) Get the current SCN base.

SQL>select max(scn_bas) SCN_BASE fromsmon_scn_time;

1603342197

--(b) Get the complete SCN and thetimestamp.

SQL> alter session setNLS_DATE_FORMAT='DD-MON-YY HH:MI:SS';

SQL> select time_dp TIMESTAMP,scn_wrp*4294967296+SCN_bas SCN from smon_scn_time where scn_bas='1603342197';

TIMESTAMP SCN

------------------ ----------

28-JUL-06 05:31:08 8252235517813

现在来看下这5个参数之间的关系。

ARGUMENTS:

Arg [a] Current SCN WRAP

Arg [b] Current SCN BASE

Arg [c] dependent SCNWRAP

Arg [d] dependent SCN BASE

Arg [e] Where present this is the DBA wherethe dependent SCN came from.

根据SCN WRAP 和 SCN BASE，我们可以计算出当前SCN 对应的timestamp。

对与depent SCN 和 current SCN 关系，咨询了一下dbsnake。给出的回复如下：

当一个库是clean shutdown的时候，Oracle一定会做full checkpoint，把所有的dirty block都写回各自的datafile，同时把当前的SCN作为checkpoint SCN写回到各个datafile的datafile header中。也就是说，如果一个库是clean shutdown，那么这个库不可能有一个数据块的块里的SCN（Oracle的一个数据块里的SCN有三种，分别是块头的SCN，CSC和ITL中记录的commit SCN）比刚才写回的checkpoint SCN要大。

当一个库启动时，Oracle会做一系列的校验，其中有一个检查就是Oracle会去检查system表空间下的某些块，如果Oracle发现这些块里的SCN要比这个库当前的current SCN（实际上，启库时的current SCN就来源于shutdown时记录在datafileheader中的checkpoint SCN）要大的时候，就表明这个库是有问题了，

此时Oracle就会报跟SCN相关的一系列错误，ORA-600[2662]只是其中的一种。对于ORA-600[2662]这种情况，dependent SCN实际上就是Oracle发现有问题的system表空间下的某些块里的SCN，这个SCN可能是这个块里ITL中记录的commit SCN，也有可能是CSC (cleanout SCN)。

根据dbsnake 的说明，这个dependent SCN 是某个数据块里的SCN. 正常情况下，这个SCN 是要小于current SCN的，当dependent SCN 大于current SCN 就会报相关的错误。instance failure 和physical corruption 都可能会造成这个问题。

 

Error Mnemonic(s)FunctionalityDescriptionain ainp ram/indexain – alter index; ainp - alter index partition management operationapacb optim/rboused by optimizer in connect by processingatb atbi atbo ctc ctci cvw dict/sqlddlalter table , create table (IOT) or cluster operations as well as create view related operations (with constraint handling functionality)dbsdrvsqllang/parsealter / create database operationddfnet progint/distribvarious distributed operations on remote dictionarydelexe sqlexec/dmldrvmanages the delete statement operationdix ram/indexmanages drop index or validate index operation dtb dict/sqlddlmanages drop table operationevaa2g evah2p evaa2g dbproc/sqlfuncvarious functions involves in evaluating operand outcomes such
as : addition , average, OR operator, bites AND , bites OR, concatenation, as well as Oracle related functions : count(), dump() , etc. The list is extensive.expcmo expgon dbproc/exprevalhandles expression evaluation with respect to two operands being equivalentgra security/dacmanages the granting and revoking of privilege rights to a usergslcsq plsldapsupport for operations with an LDAP serverin***e sqlexec/dmldrvhandles the insert statement operationjox progint/opifunctionality associated with the Java compiler and with the Java runtime environment within the Serverk2c k2d progint/distribsupport for database to database operation in distributed environements as well as providing, with respect to the 2-phase commit protocol, a globally unique Database idk2g k2ltxn/disttxsupport for the 2 phase commit protocol protocol and the coordination of the various states in managing the distributed transactionk2r k2s k2sp progint/distribk2r – user interface for managing distributed transactions and
combining distributed results ; k2s – handles logging on, starting a transaction, ending a transaction and recovering a transaction; k2sp – management of savepoints in a distributed environment.k2v txn/disttxhandles distributed recovery operationkad cartserv/picklercshandles OCIAnyData implementation kau ram/datamanages the modification of indexes for inserts, updates and delete operations for IOTs as well as modification of indexes for IOTskcb kcbb kcbk kcbl kcbs kcbt kcbw kcbz cachemanages Oracle’s buffer cache operation as well as operations used by capabilities such as direct load, has clusters , etc.kcc kcf rcvmanages and coordinates operations on the control file(s)kcit context/triggerinternal trigger functionality kck rcvcompatibility related checks associated with the compatible parameterkcl cachebackground lck process which manages locking in a RAC or parallel server multiple instance environmentkco kcq kcra kcrf kcrfr kcrfw kcrp kcrr kcs kct kcvrcvvarious buffer cache operation such as quiesce operation , managing fast start IO target, parallel recovery operation , etc.kd ram/datasupport for row level dependency checking and some log miner operationskda ram/analyzemanages the analyze command and collection of statisticskdbl kdc kdd ram/datasupport for direct load operation, cluster space management and deleting rowskdg ram/analyzegathers information about the underlying data and is used by the analyze commandkdi kdibc3 kdibco kdibh kdibl kdibo kdibq kdibr kdic kdici kdii kdil kdir kdis kdiss kdit kdkram/indexsupport of the creation of indexes on tables an IOTs and index look up kdl kdlt ram/objectlob and temporary lob managementkdo ram/dataoperations on data such as inserting a row piece or deleting a row piecekdrp ram/analyzeunderlying support for operations provided by the dbms_repair packagekds kdt kdu ram/dataoperations on data such as retrieving a row and updating existing row datakdv kdx ram/indexfunctionality for dumping index and managing index blockskfc kfd kfg asmsupport for ASM file and disk operationskfh kfp kft rcvsupport for writing to file header and transportable tablespace operationskgaj kgam kgan kgas kgat kgav kgaz argusdbg/argusdbgsupport for Java Debug Wire Protocol (JDWP) and debugging faciliteskgbt kgg kgh kghs kghx kgkpvoskgbt – support for BTree operations; kgg – generic lists processing;
kgh – Heap Manager : managing the internal structures withing the SGA / UGA / PGA and ensures their integrity; kghs – Heap manager with Stream support; kghx – fixed sized shared memory manager; kgkp – generic services scheduling policieskgl kgl2 kgl3 kgla kglp kglr kgls dict/libcachegeneric library cache operation kgm kgmt ilmssupport for inter language method services – or calling one language from anotherkgrq kgsk kgski kgsn kgss vossupport for priority queue and scheduling; capabilities for Numa support; Service State object managerkgupa kgupb kgupd0 kgupf kgupg kgupi kgupl kgupm kgupp kgupt kgupx kguq2 kguuvosService related activities activities associated with for Process
monitor (PMON); spawning or creating of background processes; debugging; managing process address space; managing the background processes; etc.kgxp vosinter process communication related functionskjak kjat kjb kjbl kjbm kjbr kjcc kjcs kjctc kjcts kjcv kjdd kjdm kjdr kjdx kjfc kjfm kjfs kjfz kjg kji kjl kjm kjp kjr kjs kjt kju kjxccl/dlmdlm related functionality ; associated with RAC or parallel server operationkjxgf kjxgg kjxgm kjxgn kjxgna kjxgr ccl/cgsprovides communication & synchronisation associated with GMS or OPS related functionality as well as name service and OPS Instance Membership Recovery Facilitykjxt ccl/dlmDLM request message managementkjzc kjzd kjzf kjzg kjzm ccl/diagsupport for diagnosibility amongst OPS related serviceskkb dict/sqlddlsupport for operatoins which load/change table definitionskkbl kkbn kkbo objsupp/objddlsupport for tables with lobs , nested tables and varrays as well as columns with objectskkdc kkdl kkdo dict/dictlkupsupport for constraints, dictionary lookup and dictionary support for objectskke optim/cboquery engine cost engine; provides support functions that provide cost estimates for queries under a number of different circumstanceskkfd sqlexec/pqsupport for performing parallel query operationkkfi optim/cbooptimizer support for matching of expressions against functional ndexeskkfr kkfs sqlexec/pqsupport for rowid range handling as well as for building parallel query query operationskkj jobqs/jobqjob queue operationkkkd kkki dict/dbschedresource manager related support. Additionally, provides underlying functions provided by dbms_resource_manager and dbms_resource_manager_privs packageskklr dict/sqlddlprovides functions used to manipulate LOGGING and/or RECOVERABLE attributes of an object (non-partitioned table or index or partitions of a partitioned table or index)kkm kkmi dict/dictlkupprovides various semantic checking functions kkn ram/analyzesupport for the analyze commandkko kkocri optim/cboCost based Optimizer operation : generates alternative execution
plans in order to find the optimal / quickest access to the data. Also , support to determine cost and applicability of scanning a given index in trying to create or rebuild an index or a partition thereofkkpam kkpap ram/partnmapsupport for mapping predicate keys expressions to equivalent partitionskkpo kkpoc kkpod dict/partnsupport for creation and modification of partitioned objectskkqg kkqs kkqs1 kkqs2 kkqs3 kkqu kkqv kkqw optim/vwsubqquery rewrite operation kks kksa kksh kksl kksm dict/shrdcurssupport for managing shared cursors/ shared sqlkkt dict/sqlddlsupport for creating, altering and dropping trigger definitions as well as handling the trigger operationkkxa repl/defrdrpcunderlying support for dbms_defer_query package operationskkxb dict/sqlddllibrary cache interface for external tables kkxl dict/plsicdsunderlying support for the dbms_lob packagekkxm progint/opisupport for inter language method serviceskkxs dict/plsicdsunderlying support for the dbms_sys_sql package kkxt repl/triggersupport for replication internal trigger operationkkxwtp progint/opientry point into the plsql compilerkky drvsupport for alter system/session commandskkz kkzd kkzf kkzg kkzi kkzj kkzl kkzo kkzp kkzq kkzr kkzu kkzvrepl/snapshotsupport for snapshots or Materialized View validation and operationkla klc klcli klx tools/sqlldrsupport for direct path sql loader operationkmc kmcp kmd kmm kmr mts/mtssupport for Multi Threaded server operation (MTS) : manange and
operate the virtual circuit mechanism, handle the dispatching of massages, administer shared servers and for collecting and maintaining statistics associated with MTSknac knafh knaha knahc knahf knahs repl/applyreplication apply operation associated with Oracle streamskncc repl/repcachesupport for replication related information stored and maintained in library cachekncd knce repl/defrdrpcreplication related enqueue and dequeue of transction data as well as other queue related operationskncog repl/repcachesupport for loading replicaiton object group information into library cachekni repl/triggersupport for replication internal trigger operationknip knip2 knipi knipl knipr knipu knipu2 knipx repl/intpkgsupport for replication internal package operation. kno repl/repobjsupport for replication objects knp knpc knpcb knpcd knpqc knps repl/defrdrpcoperations assocaied with propagating transactions to a remote node and coordination of this activity.knst repl/statsreplication statistics collectionknt kntg kntx repl/triggersupport for replication internal trigger operationkoc objmgmt/objcachesupport for managing ADTs objects in the OOCI heapkod objmgmt/datamgrsupport for persistent storage for objects : for read/write objects, to manage object IDs, and to manage object concurrency and recovery.koh objmgmt/objcacheobject heap manager provides memory allocation services for objectskoi objmgmt/objmgrsupport for object typeskoka objsupp/objdatasupport for reading images, inserting images, updating images, and deleting images based on object references (REFs).kokb kokb2 objsupp/objsqlsupport for nested table objectskokc objmgmt/objcachesupport for pinning , unpinning and freeing objectskokd objsupp/datadrvdriver on the server side for managing objectskoke koke2 koki objsupp/objsqlsupport for managing objectskokl objsupp/objdatalob accesskokl2 objsupp/objsqllob DML and programmatic interface supportkokl3 objsupp/objdataobject temporary LOB supportkokle kokm objsupp/objsqlobject SQL evaluation functionskokn objsupp/objnamenaming support for objectskoko objsupp/objsupsupport functions to allow oci/rpi to communicate with Object Management Subsystem (OMS).kokq koks koks2 koks3 koksr objsupp/objsqlquery optimisation for objects , semantic checking and semantic rewrite operationskokt kokt2 kokt3 objsupp/objddlobject compilation type managerkoku kokv objsupp/objsqlsupport for unparse object operators and object view supportkol kolb kole kolf kolo objmgmt/objmgrsupport for object Lob buffering , object lob evaluation and object Language/runtime functions for Opaque typeskope2 kopi2 kopo kopp2 kopu koputil kopzobjmgmt/pickler8.1 engine implementation, implementation of image ops for 8.1+ image format together with various pickler related support functionskos objsupp/objsupobject Stream interfaces for images/objectskot kot2 kotg objmgmt/typemgrsupport for dynamic type operations to create, delete, and update types.koxs koxx objmgmt/objmgtobject generic image Stream routines and miscellaneous generic object functionskpcp kpcxlt progint/kpcKernel programmatic connection pooling and kernel programmatic common type XLT translation routineskpki progint/kpkikernel programatic interface supportkpls cartserv/corecssupport for string formatting operationskpn progint/kpnsupport for server to server communication kpoal8 kpoaq kpob kpodny kpodp kpods kpokgt kpolob kpolon kponprogint/kposupport for programmatic operations kpor progint/opisupport for streaming protocol used by replicationkposc progint/kposupport for scrollable cursorskpotc progint/opioracle side support functions for setting up trusted external procedure callbackskpotx kpov progint/kposupport for managing local and distributed transaction coordination.kpp2 kpp3 sqllang/parsekpp2 – parse routines for dimensions;
kpp3 – parse support for create/alter/drop summary statementskprb kprc progint/rpisupport for executing sql efficiently on the Oracle server side as well as for copying data types during rpi operationskptsc progint/twotaskcallback functions provided to all streaming operation as part of replication functionalitykpu kpuc kpucp progint/kpuOracle kernel side programmatic user interface, cursor management functions and client side connection pooling supportkqan kqap kqas argusdbg/argusdbgserver-side notifiers and callbacks for debug operations. kql kqld kqlp dict/libcacheSQL Library Cache manager – manages the sharing of sql statements in the shared poolkqr dict/rowcacherow cache management. The row cache consists of a set of facilities to provide fast access to table definitions and locking capabilities.krbi krbx krby krcr krd krpi rcvBackup and recovery related operations :
krbi
- dbms_backup_restore package underlying support.; krbx - proxy copy controller; krby – image copy; krcr – Recovery Controlfile Redo; krd – Recover Datafiles (Media & Standby Recovery); krpi – support for the package : dbms_pitrkrvg krvt rcv/vwrkrvg – support for generation of redo associated with DDL; krvt – support for redo log miner viewer (also known as log miner)ksa ksdp ksdx kse ksfd ksfh ksfq ksfv ksi ksim ksk ksl ksm ksmd ksmg ksn ksp kspt ksq ksr kss ksst ksu ksutvossupport for various kernel associated capabilitiesksxsqlexec/execsvcsupport for query execution associated with temporary tablesksxa ksxp ksxr vossupport for various kernel associated capabilities in relation to OPS or RAC operationkta space/spcmgmtsupport for DML locks and temporary tables associated with table accessktb ktbt ktc txn/lcltxtransaction control operations at the block level : locking block, allocating space within the block , freeing up space, etc.ktec ktef ktehw ktein ktel kteop kteu space/spcmgmtsupport for extent management operations :
ktec
- extent concurrency operations; ktef – extent format; ktehw – extent high water mark operations; ktein – extent information operations; ktel – extent support for sql loader; kteop – extent operations : add extent to segment, delete extent, resize extent, etc. kteu – redo support for operations changing segment header / extent mapktf txn/lcltxflashback supportktfb ktfd ktft ktm space/spcmgmtktfb – support for bitmapped space manipulation of files/tablespaces; ktfd – dictionary-based extent management; ktft – support for temporary file manipulation; ktm – SMON operationktp ktpr ktr ktri txn/lcltxktp – support for parallel transaction operation; ktpr – support
for parallel transaction recovery; ktr – kernel transaction read consistency;
ktri – support for dbms_resumable packagektsa ktsap ktsau ktsb ktscbr ktsf ktsfx ktsi ktsm ktsp ktss ktst ktsx ktt kttmspace/spcmgmtsupport for checking and verifying space usagektu ktuc ktur ktusm txn/lcltxinternal management of undo and rollback segmentskwqa kwqi kwqic kwqid kwqie kwqit kwqj kwqm kwqn kwqo kwqp kwqs kwqu kwqxoltp/qssupport for advanced queuing :
kwqa
- advanced queue administration; kwqi – support for AQ PL/SQL trusted callouts; kwqic – common AQ support functions; kwqid – AQ
dequeue support; kwqie – AQ enqueu support ; kwqit – time management operation ; kwqj – job queue scheduler for propagation; kwqm
- Multiconsumer queue IOT support; kwqn – queue notifier; kwqo – AQ support for checking instType checking options; kwqp – queueing propagation; kwqs – statistics handling; kwqu – handles lob data. ; kwqx – support for handling transformationskwrc kwre oltp/rerules engine evaluationkxcc kxcd kxcs sqllang/integconstraint processingkxdrsqlexec/dmldrvDML driver entrypoint kxfp kxfpb kxfq kxfr kxfx sqlexec/pqparallel query supportkxhf kxib sqlexec/execsvckhhf- support for hash join file and memory management; kxib – index buffering operationskxs dict/instmgmtsupport for executing shared cursorskxti kxto kxtr dbproc/triggersupport for trigger operationkxtt ram/partnmapsupport for temporary table operationskxwph ram/datasupport for managing attributes of the segment of a table / cluster / table-partitionkza security/auditsupport for auditing operations kzar security/dacsupport for application auditingkzck security/cryptoencryption supportkzd security/dacsupport for dictionary access by security related functions kzec security/dbencryptionsupport inserting and retrieving encrypted objects into and out of the databasekzfa kzft security/auditsupport for fine grained auditingkzia security/logonidentification and authentication operationskzp kzra kzrt kzs kzu kzup security/dacsecurity related operations associated with privileges msqima msqimb sqlexec/sqlgensupport for generating sql statmentsncodef npi npil npixfr progint/npisupport for managing remote network connection from within the server itselfoba sqllang/outbufaloperator buffer allocate for various types of operators : concatenate, decode, NVL, etc. the list is extensive.ocik progint/ociOCI oracle server functionsopiaba opidrv opidsa opidsc opidsi opiexe opifch opiino opilng opipar opipls opirip opitsk opixprogint/opiOPI Oracle server functions – these are at the top of the server stack and are called indirectly by ythe client in order to server the client request.orlr objmgmt/objmgrsupport for C langauge interfaces to user-defined types (UDTs) orp objmgmt/pickleroracle’s external pickler / opaque type interfacespesblt pfri pfrsqc plsql/coxpesblt – pl/sql built in interpreter; pfri – pl/sql runtime; pfrsqc – pl/sql callbacks for array sql and dml with returningpiht plsql/gen/utlsupport for pl/sql implementation of utl_http packagepirg plsql/cli/utl_rawsupport for pl/sql implementation of utl_raw packagepism plsql/cli/utl_smtpsupport for pl/sql implementation of utl_smtp packagepitcb plsql/cli/utl_tcpsupport for pl/sql implementation of utl_tcp packagepiur plsql/gen/utl_urlsupport for pl/sql implementation of utl_url packageplio plsql/pkgpl/sql object instantiation plslm plsql/coxsupport for NCOMP processingplsm pmuc pmuo pmux objmgmt/polsupport for pl/sql handling of collectionsprifold priold plsql/coxsupport to allow rpc forwarding to an older release prm sqllang/paramparameter handling associated with sql layerprsa prsc prssz sqllang/parseprsa – parser for alter cluster command; prsc – parser for create database command; prssz – support for parse context to be savedpsdbnd psdevn progint/dbpsdpsdbnd – support for managing bind variables; psdevn – support for pl/sql debuggerpsdicd progint/plsicdssmall number of ICD to allow pl/sql to call into ‘C’ sourcepsdmsc psdpgi progint/dbpsdpsdmsc – pl/sql system dependent miscellaneous functions ; psdpgi – support for opening and closing cursors in pl/sqlpsf plsql/plspl/sql service related functions for instantiating called pl/sql unit in library cacheqbadrv qbaopn sqllang/qrybufalprovides allocation of buffer and control structures in query executionqcdl qcdo dict/dictlkupqcdl – query compile semantic analysis; qcdo – query compile dictionary support for objectsqci dict/shrdcurssupport for SQL language parser and semantic analyserqcop qcpi qcpi3 qcpi4 qcpi5 sqllang/parsesupport for query compilation parse phaseqcs qcs2 qcs3 qcsji qcso dict/dictlkupsupport for semantic analysis by SQL compilerqct qcto sqllang/typeconvqct – query compile type check operations; qcto - query compile type check operatorsqcu sqllang/parsevarious utilities provided for sql compilationqecdrv sqllang/qryedchkdriver performing high level checks on sql language query capabilitiesqerae qerba qerbc qerbi qerbm qerbo qerbt qerbu qerbx qercb qercbi qerco
qerdl qerep qerff qerfi qerfl qerfu qerfx qergi qergr qergs qerhc qerhj qeril qerim qerix qerjm qerjo qerle qerli qerlt qerns qeroc qeroi qerpa qerpf qerpx qerrm qerse qerso qersq qerst qertb qertq qerua qerup qerus qervw qerwn qerxtsqlexec/rowsrcrow source operators :
qerae – row source
(And-Equal) implementation; qerba – Bitmap Index AND row source; qerbc – bitmap index compaction row source; qerbi – bitmap index
creation row source; qerbm – QERB Minus row source; qerbo – Bitmap Index OR row source; qerbt – bitmap convert row source; qerbu – Bitmap Index Unlimited-OR row source; qerbx – bitmap index access row source; qercb – row source: connect by; qercbi – support
for connect by; qerco – count row source; qerdl – row source delete; qerep – explosion row source; qerff – row source fifo buffer;
qerfi – first row row source; qerfl – filter row source definition; qerfu – row source: for update; qerfx – fixed table row source; qergi – granule iterator row source; qergr – group by rollup row source; qergs – group by sort row source; qerhc – row
sources hash clusters; qerhj – row source Hash Join; qeril – In-list row source; qerim – Index Maintenance row source; qerix – Index row source; qerjo – row source: join; qerle – linear execution row source implementation; qerli – parallel create
index; qerlt – row source populate Table; qerns – group by No Sort row source; qeroc – object collection iterator row source; qeroi – extensible indexing query component; qerpa – partition row sources; qerpf – query execution row source: prefetch;
qerpx – row source: parallelizer; qerrm – remote row source; qerse – row source: set implementation; qerso – sort row source; qersq
- row source for sequence number; qerst – query execution row sources: statistics; qertb – table row source; qertq – table queue row source; qerua – row source : union-All;
qerup – update row source; qerus – upsert row source ; qervw – view row source; qerwn – WINDOW row source; qerxt – external table fetch row sourceqes3t qesa qesji qesl qesmm qesmmc sqlexec/execsvcrun time support for sql executionqkacon qkadrv qkajoi qkatab qke qkk qkn qkna qkne sqlexec/rwsallocSQL query dynamic structure allocation routinesqks3t sqlexec/execsvcquery execution service associated with temp table transformationqksmm qksmms qksop sqllang/compsvcqksmm - memory management services for the SQL compiler; qksmms – memory management simulation services for the SQL compiler; qksop – query compilation service for operand processingqkswc sqlexec/execsvcsupport for temp table transformation associated for with clause.qmf xmlsupp/utilsupport for ftp server; implements processing of ftp commandsqmr qmrb qmrs xmlsupp/resolversupport hierarchical resolver qms xmlsupp/datasupport for storage and retrieval of XOBsqmurs xmlsupp/urisupport for handling URIsqmx qmxsax xmlsupp/dataqmx – xml support; qmxsax – support for handling sax processingqmxtc xmlsupp/sqlsuppsupport for ddl and other operators related to the sql XML supportqmxtgx xmlsuppsupport for transformation : ADT -> XMLqmxtsk xmlsupp/sqlsuppXMLType support functions qsme summgmt/dictsummary management expression processingqsmka qsmkz dict/dictlkupqsmka – support to analyze request in order to determine whether a summary could be created that would be useful; qsmkz – support for create/alter summary semantic analysisqsmp qsmq qsmqcsm qsmqutl summgmt/dictqsmp – summary management partition processing; qsmq – summary
management dictionary access; qsmqcsm – support for create / drop / alter summary and related dimension operations; qsmqutl – support for summariesqsms summgmt/advsvrsummary management advisorqxdid objsupp/objddlsupport for domain index ddl operationsqxidm objsupp/objsqlsupport for extensible index dml operationsqxidp objsupp/objddlsupport for domain index ddl partition operationsqxim objsupp/objsqlextensible indexing support for objectsqxitex qxopc qxope objsupp/objddlqxitex – support for create / drop indextype; qxope – execution time support for operator callbacks; qxope – execution time support for operator DDLqxopq qxuag qxxm objsupp/objsqlqxopq – support for queries with user-defined operators; qxuag – support for user defined aggregate processing; qxxm – queries involving external tablesrfmon rfra rfrdb rfrla rfrm rfrxpt drsimplements 9i data guard broker monitor rnm dict/sqlddlmanages rename statement operationrpi progint/rpirecursive procedure interface which handles the the environment setup where multiple recursize statements are executed from one top level statementrwoima sqlexec/rwoprndsrow operand operationsrwsima sqlexec/rowsrcrow source implementation/retrieval according to the defining querysdbima sqlexec/sortmanages and performs sort operationselexe sqlexec/dmldrvhandles the operation of select statement executionskgm osdsplatform. specific memory management rountines interfacing with O.S. allocation functionssmbima sor sqlexec/sortmanages and performs sort operationsqn dict/sqlddlsupport for parsing references to sequencessrdima srsima stsima sqlexec/sortmanages and performs sort operationtbsdrv space/spcmgmtoperations for executing create / alter / drop tablespace and related supporting functionsttcclr ttcdrv ttcdty ttcrxh ttcx2y progint/twotasktwo task common layer which provides high level interaction and
negotiation functions for Oracle client when communicating with the server. It also provides important function of converting client side data / data types into equivalent on the server and vice versauixexe ujiexe updexe up***e sqlexec/dmldrvsupport for : index maintenance operations, the execution of the
update statement and associated actions connected with update as well as the upsert command which combines the operations of update and insertvop optim/vwsubqview optimisation related functionalityxct txn/lcltxsupport for the management of transactions and savepoint operationsxpl sqlexec/expplansupport for the explain plan commandxty sqllang/typeconvtype checking functionszlke security/ols/intextlabel security error handling component