(收藏)ORA-00600的汇总

(收藏)ORA-00600的汇总

ORA-00600一般都是Oracle的内部错误了，这是个让人很头痛的error code，一旦出现这个error code，往往都是问题以升级或者补丁的形式来解决了，当然有一些问题可以通过metalink找到临时的解决方案，不过，即使是这样，我们还是有必要对ORA-00600有一定的了解。这样对我们错误的判断还是很有帮助的，有时知道原因了，可以试试绕过这块来得到最后解决问题的方法。

收罗了一些errorcode的信息，汇集一起，以便以后查找

Ora-600 Base Functionality Description1 vos Component notifier100 vos Debug300 vos Error500 vos Lock700 vos Memory900 vos System Parameters1100 vos System State object1110 vos Generic Linked List management1140 vos Enqueue1180 vos Instance Locks1200 vos User State object1400 vos Async Msgs1700 vos license Key1800 vos Instance Registration1850 vos I/O Services components

2000 Cache Layer Where 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 Description2000 server/rcv Cache Op2100 server/rcv Control File mgmt2200 server/rcv Misc (SCN etc.)2400 server/rcv Buffer Instance Hash Table2600 server/rcv Redo file component2800 server/rcv Db file3000 server/rcv Redo Application3200 server/cache Buffer manager3400 server/rcv Archival & media recovery component3600 server/rcv recovery component3700 server/rcv Thread component3800 server/rcv Compatibility 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.

4000 Transaction Layer Primarily 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 Description4000 server/txn Transaction Undo4100 server/txn Transaction Undo4210 server/txn Transaction Parallel4250 server/txn Transaction List4300 space/spcmgmt Transaction Segment4400 txn/lcltx Transaction Control4450 txn/lcltx distributed transaction control4500 txn/lcltx Transaction Block4600 space/spcmgmt Transaction Table4800 dict/rowcache Query Row Cache4900 space/spcmgmt Transaction Monitor5000 space/spcmgmt Transaction 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 of <; in addition, it may be worth using the dbverify as discussed in <.

6000 Data Layer The 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 Description6000 ram/dataram/analyzeram/index data, analyze command and index related activity7000 ram/object lob related errors8000 ram/data general data access8110 ram/index index related8150 ram/object general 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 of <; in addition, it may be worth using the dbverify as discussed in <.

12000 User/Oracle Interface & SQL Layer Components This 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 sequenceOra-600 Base Functionality Description12200 progint/kpoprogint/opi lob relatederrors at interface level on server side, xa , etc.12300 progint/if OCI interface to coordinating global transactions12400 sqlexec/rowsrc table row source access12600 space/spcmgmt operations associated with tablespace : alter / create / drop operations ; operations associated with create table / cluster12700 sqlexec/rowsrc bad rowid13000 dict/if dictionary access routines associated with kernel compilation13080 ram/index kernel Index creation13080 sqllang/integ constraint mechanism13100 progint/opi archival and Media Recovery component13200 dict/sqlddl alter table mechanism13250 security/audit audit statement processing13300 objsupp/objdata support for handling of object generation and object access14000 dict/sqlddl sequence generation15000 progint/kpo logon to Oracle16000 tools/sqlldr sql 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.

14000 System Dependent Component internal error values This 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 Description14000 osds File access14100 osds Concurrency management;14200 osds Process management;14300 osds Exception-handler or signal handler management14500 osds Memory allocation

15000 security/dac,security/logonsecurity/ldap local 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 file15100 dict/sqlddl this component manages operations associated with creating, compiling (altering), renaming, invalidating, and dropping procedures, functions, and packages.15160 optim/cbo cost based optimizer layer is used to determine optimal path to the data based on statistical information available on the relevant tables and indexes.15190 optim/cbo cost 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.15200 dict/shrdcurs used to in creating sharable context area associated with shared cursors15230 dict/sqlddl manages the compilation of triggers15260 dict/dictlkupdict/libcache dictionary lookup and library cache access15400 server/drv manages alter system and alter session operations15410 progint/if manages compilation of pl/sql packages and procedures15500 dict/dictlkup performs dictionary lookup to ensure semantics are correct15550 sqlexec/execsvcsqlexec/rowsrc hash join execution management;parallel row source management15600 sqlexec/pq component provides support for Parallel Query operation15620 repl/snapshots manages the creation of snapshot or materialized views as well as related snapshot / MV operations15640 repl/defrdrpc layer containing various functions for examining the deferred transaction queue and retrieving information15660 jobqs/jobq manages the operation of the Job queue background processes15670 sqlexec/pq component provides support for Parallel Query operation15700 sqlexec/pq component provides support for Parallel Query operation; specifically mechanism for starting up and shutting down query slaves15800 sqlexec/pq component provides support for Parallel Query operation15810 sqlexec/pq component provides support for Parallel Query operation; specifically functions for creating mechanisms through which Query co-ordinator can communicate with PQ slaves;15820 sqlexec/pq component provides support for Parallel Query operation15850 sqlexec/execsvc component provides support for the execution of SQL statements15860 sqlexec/pq component provides support for Parallel Query operation16000 loader sql Loader direct load operation;16150 loader this layer is used for ‘C’ level call outs to direct loader operation;16200 dict/libcache this 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;16230 dict/libcache this component is responsible for managing access to remote objects as part of library Cache operation;16300 mts/mts this component relates to MTS (Multi Threaded Server) operation16400 dict/sqlddl this layer contains functionality which allows tables to be loaded / truncated and their definitions to be modified. This is part of dictionary operation;16450 dict/libcache this layer layer provides support for multi-instance access to the library cache; this functionality is applicable therefore to OPS environments;16500 dict/rowcache this layer provides support to load / cache Oracle’s dictionary in memory in the library cache;16550 sqlexec/fixedtab this component maps data structures maintained in the Oracle code to fixed tables such that they can be queried using the SQL layer;16600 dict/libcache this layer performs management of data structures within the library cache;16651 dict/libcache this layer performs management of dictionary related information within library Cache;16701 dict/libcache this layer provides library Cache support to support database creation and forms part of the bootstrap process;17000 dict/libcache this 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;17090 generic/vos this layer implementations error management operations: signalling errors, catching errors, recovering from errors, setting error frames, etc.;17100 generic/vos Heap 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.17200 dict/libcache this component deals with loading remote library objects into the local library cache with information from the remote database.17250 dict/libcache more library cache errors ; functionality for handling pipe operation associated with dbms_pipe17270 dict/instmgmt this 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;17300 generic/vos manages certain types of memory allocation structure. This functionality is an extension of the Heap manager.17500 generic/vos relates 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;17625 dict/libcache additional library Cache supporting functions17990 plsql plsql ’standard’ package related issues18000 txn/lcltx transaction and savepoint management operations19000 optim/cbo cost based optimizer related operations20000 ram/index bitmap index and index related errors.20400 ram/partnmap operations on partition related objects20500 server/rcv server recovery related operation21000 repl/defrdrpc,repl/snapshot,repl/trigger replication related features23000 oltp/qs AQ related errors.24000 dict/libcache operations associated with managing stored outlines25000 server/rcv tablespace management operations

Internal Errors Categorised by mnemonic

The following table details mnemonics error stems which are possible. If you have encountered : ora-600[kkjsrj:1] for example, you should look down the Error Mnemonic column (errors in alphabetical order) until you find the matching stem. In this case, kkj indicates that something unexpected has occurred in job queue operation.

Error Mnemonic(s) Functionality Descriptionain ainp ram/index ain - alter index; ainp - alter index partition management operationapacb optim/rbo used by optimizer in connect by processingatb atbi atbo ctc ctci cvw dict/sqlddl alter table , create table (IOT) or cluster operations as well as create view related operations (with constraint handling functionality)dbsdrv sqllang/parse alter / create database operationddfnet progint/distrib various distributed operations on remote dictionarydelexe sqlexec/dmldrv manages the delete statement operationdix ram/index manages drop index or validate index operationdtb dict/sqlddl manages drop table operationevaa2g evah2p evaa2g dbproc/sqlfunc various 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/expreval handles expression evaluation with respect to two operands being equivalentgra security/dac manages the granting and revoking of privilege rights to a usergslcsq plsldap support for operations with an LDAP serverinsexe sqlexec/dmldrv handles the insert statement operationjox progint/opi functionality associated with the Java compiler and with the Java runtime environment within the Serverk2c k2d progint/distrib support 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 k2l txn/disttx support for the 2 phase commit protocol protocol and the coordination of the various states in managing the distributed transactionk2r k2s k2sp progint/distrib k2r - 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/disttx handles distributed recovery operationkad cartserv/picklercs handles OCIAnyData implementationkau ram/data manages 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 cache manages Oracle’s buffer cache operation as well as operations used by capabilities such as direct load, has clusters , etc.kcc kcf rcv manages and coordinates operations on the control file(s)kcit context/trigger internal trigger functionalitykck rcv compatibility related checks associated with the compatible parameterkcl cache background lck process which manages locking in a RAC or parallel server multiple instance environmentkco kcq kcra kcrf kcrfr kcrfw kcrp kcrr kcs kct kcv rcv various buffer cache operation such as quiesce operation , managing fast start IO target, parallel recovery operation , etc.kd ram/data support for row level dependency checking and some log miner operationskda ram/analyze manages the analyze command and collection of statisticskdbl kdc kdd ram/data support for direct load operation, cluster space management and deleting rowskdg ram/analyze gathers 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 kdk ram/index support of the creation of indexes on tables an IOTs and index look upkdl kdlt ram/object lob and temporary lob managementkdo ram/data operations on data such as inserting a row piece or deleting a row piecekdrp ram/analyze underlying support for operations provided by the dbms_repair packagekds kdt kdu ram/data operations on data such as retrieving a row and updating existing row datakdv kdx ram/index functionality for dumping index and managing index blockskfh kfp kft rcv support for writing to file header and transportable tablespace operationskgaj kgam kgan kgas kgat kgav kgaz argusdbg/argusdbg support for Java Debug Wire Protocol (JDWP) and debugging faciliteskgbt kgg kgh kghs kghx kgkp vos kgbt - 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/libcache generic library cache operationkgm kgmt ilms support for inter language method services - or calling one language from anotherkgrq kgsk kgski kgsn kgss vos support for priority queue and scheduling; capabilities for Numa support; Service State object managerkgupa kgupb kgupd0 kgupf kgupg kgupi kgupl kgupm kgupp kgupt kgupx kguq2 kguu vos Service 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 vos inter 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 kjx ccl/dlm dlm related functionality ; associated with RAC or parallel server operationkjxgf kjxgg kjxgm kjxgn kjxgna kjxgr ccl/cgs provides communication & synchronisation associated with GMS or OPS related functionality as well as name service and OPS Instance Membership Recovery Facilitykjxt ccl/dlm DLM request message managementkjzc kjzd kjzf kjzg kjzm ccl/diag support for diagnosibility amongst OPS related serviceskkb dict/sqlddl support for operatoins which load/change table definitionskkbl kkbn kkbo objsupp/objddl support for tables with lobs , nested tables and varrays as well as columns with objectskkdc kkdl kkdo dict/dictlkup support for constraints, dictionary lookup and dictionary support for objectskke optim/cbo query engine cost engine; provides support functions that provide cost estimates for queries under a number of different circumstanceskkfd sqlexec/pq support for performing parallel query operationkkfi optim/cbo optimizer support for matching of expressions against functional ndexeskkfr kkfs sqlexec/pq support for rowid range handling as well as for building parallel query query operationskkj jobqs/jobq job queue operationkkkd kkki dict/dbsched resource manager related support. Additionally, provides underlying functions provided by dbms_resource_manager and dbms_resource_manager_privs packageskklr dict/sqlddl provides 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/dictlkup provides various semantic checking functionskkn ram/analyze support for the analyze commandkko kkocri optim/cbo Cost 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/partnmap support for mapping predicate keys expressions to equivalent partitionskkpo kkpoc kkpod dict/partn support for creation and modification of partitioned objectskkqg kkqs kkqs1 kkqs2 kkqs3 kkqu kkqv kkqw optim/vwsubq query rewrite operationkks kksa kksh kksl kksm dict/shrdcurs support for managing shared cursors/ shared sqlkkt dict/sqlddl support for creating, altering and dropping trigger definitions as well as handling the trigger operationkkxa repl/defrdrpc underlying support for dbms_defer_query package operationskkxb dict/sqlddl library cache interface for external tableskkxl dict/plsicds underlying support for the dbms_lob packagekkxm progint/opi support for inter language method serviceskkxs dict/plsicds underlying support for the dbms_sys_sql packagekkxt repl/trigger support for replication internal trigger operationkkxwtp progint/opi entry point into the plsql compilerkky drv support for alter system/session commandskkz kkzd kkzf kkzg kkzi kkzj kkzl kkzo kkzp kkzq kkzr kkzu kkzv repl/snapshot support for snapshots or Materialized View validation and operationkla klc klcli klx tools/sqlldr support for direct path sql loader operationkmc kmcp kmd kmm kmr mts/mts support 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/apply replication apply operation associated with Oracle streamskncc repl/repcache support for replication related information stored and maintained in library cachekncd knce repl/defrdrpc replication related enqueue and dequeue of transction data as well as other queue related operationskncog repl/repcache support for loading replicaiton object group information into library cachekni repl/trigger support for replication internal trigger operationknip knip2 knipi knipl knipr knipu knipu2 knipx repl/intpkg support for replication internal package operation.kno repl/repobj support for replication objectsknp knpc knpcb knpcd knpqc knps repl/defrdrpc operations assocaied with propagating transactions to a remote node and coordination of this activity.knst repl/stats replication statistics collectionknt kntg kntx repl/trigger support for replication internal trigger operationkoc objmgmt/objcache support for managing ADTs objects in the OOCI heapkod objmgmt/datamgr support for persistent storage for objects : for read/write objects, to manage object IDs, and to manage object concurrency and recovery.koh objmgmt/objcache object heap manager provides memory allocation services for objectskoi objmgmt/objmgr support for object typeskoka objsupp/objdata support for reading images, inserting images, updating images, and deleting images based on object references (REFs).kokb kokb2 objsupp/objsql support for nested table objectskokc objmgmt/objcache support for pinning , unpinning and freeing objectskokd objsupp/datadrv driver on the server side for managing objectskoke koke2 koki objsupp/objsql support for managing objectskokl objsupp/objdata lob accesskokl2 objsupp/objsql lob DML and programmatic interface supportkokl3 objsupp/objdata object temporary LOB supportkokle kokm objsupp/objsql object SQL evaluation functionskokn objsupp/objname naming support for objectskoko objsupp/objsup support functions to allow oci/rpi to communicate with Object Management Subsystem (OMS).kokq koks koks2 koks3 koksr objsupp/objsql query optimisation for objects , semantic checking and semantic rewrite operationskokt kokt2 kokt3 objsupp/objddl object compilation type managerkoku kokv objsupp/objsql support for unparse object operators and object view supportkol kolb kole kolf kolo objmgmt/objmgr support for object Lob buffering , object lob evaluation and object Language/runtime functions for Opaque typeskope2 kopi2 kopo kopp2 kopu koputil kopz objmgmt/pickler 8.1 engine implementation, implementation of image ops for 8.1+ image format together with various pickler related support functionskos objsupp/objsup object Stream interfaces for images/objectskot kot2 kotg objmgmt/typemgr support for dynamic type operations to create, delete, and update types.koxs koxx objmgmt/objmgt object generic image Stream routines and miscellaneous generic object functionskpcp kpcxlt progint/kpc Kernel programmatic connection pooling and kernel programmatic common type XLT translation routineskpki progint/kpki kernel programatic interface supportkpls cartserv/corecs support for string formatting operationskpn progint/kpn support for server to server communicationkpoal8 kpoaq kpob kpodny kpodp kpods kpokgt kpolob kpolon kpon progint/kpo support for programmatic operationskpor progint/opi support for streaming protocol used by replicationkposc progint/kpo support for scrollable cursorskpotc progint/opi oracle side support functions for setting up trusted external procedure callbackskpotx kpov progint/kpo support for managing local and distributed transaction coordination.kpp2 kpp3 sqllang/parse kpp2 - parse routines for dimensions;kpp3 - parse support for create/alter/drop summary statementskprb kprc progint/rpi support for executing sql efficiently on the Oracle server side as well as for copying data types during rpi operationskptsc progint/twotask callback functions provided to all streaming operation as part of replication functionalitykpu kpuc kpucp progint/kpu Oracle kernel side programmatic user interface, cursor management functions and client side connection pooling supportkqan kqap kqas argusdbg/argusdbg server-side notifiers and callbacks for debug operations.kql kqld kqlp dict/libcache SQL Library Cache manager - manages the sharing of sql statements in the shared poolkqr dict/rowcache row 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 rcv Backup 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/vwr krvg - 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 ksut vos support for various kernel associated capabilitiesksx sqlexec/execsvc support for query execution associated with temporary tablesksxa ksxp ksxr vos support for various kernel associated capabilities in relation to OPS or RAC operationkta space/spcmgmt support for DML locks and temporary tables associated with table accessktb ktbt ktc txn/lcltx transaction 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/spcmgmt support 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/lcltx flashback supportktfb ktfd ktft ktm space/spcmgmt ktfb - 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/lcltx ktp - 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 kttm space/spcmgmt support for checking and verifying space usagektu ktuc ktur ktusm txn/lcltx internal management of undo and rollback segmentskwqa kwqi kwqic kwqid kwqie kwqit kwqj kwqm kwqn kwqo kwqp kwqs kwqu kwqx oltp/qs support 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/re rules engine evaluationkxcc kxcd kxcs sqllang/integ constraint processingkxdr sqlexec/dmldrv DML driver entrypointkxfp kxfpb kxfq kxfr kxfx sqlexec/pq parallel query supportkxhf kxib sqlexec/execsvc khhf- support for hash join file and memory management; kxib - index buffering operationskxs dict/instmgmt support for executing shared cursorskxti kxto kxtr dbproc/trigger support for trigger operationkxtt ram/partnmap support for temporary table operationskxwph ram/data support for managing attributes of the segment of a table / cluster / table-partitionkza security/audit support for auditing operationskzar security/dac support for application auditingkzck security/crypto encryption supportkzd security/dac support for dictionary access by security related functionskzec security/dbencryption support inserting and retrieving encrypted objects into and out of the databasekzfa kzft security/audit support for fine grained auditingkzia security/logon identification and authentication operationskzp kzra kzrt kzs kzu kzup security/dac security related operations associated with privilegesmsqima msqimb sqlexec/sqlgen support for generating sql statmentsncodef npi npil npixfr progint/npi support for managing remote network connection from within the server itselfoba sqllang/outbufal operator buffer allocate for various types of operators : concatenate, decode, NVL, etc. the list is extensive.ocik progint/oci OCI oracle server functionsopiaba opidrv opidsa opidsc opidsi opiexe opifch opiino opilng opipar opipls opirip opitsk opix progint/opi OPI 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/objmgr support for C langauge interfaces to user-defined types (UDTs)orp objmgmt/pickler oracle’s external pickler / opaque type interfacespesblt pfri pfrsqc plsql/cox pesblt - pl/sql built in interpreter; pfri - pl/sql runtime; pfrsqc - pl/sql callbacks for array sql and dml with returningpiht plsql/gen/utl support for pl/sql implementation of utl_packagepirg plsql/cli/utl_raw support for pl/sql implementation of utl_raw packagepism plsql/cli/utl_smtp support for pl/sql implementation of utl_smtp packagepitcb plsql/cli/utl_tcp support for pl/sql implementation of utl_tcp packagepiur plsql/gen/utl_url support for pl/sql implementation of utl_url packageplio plsql/pkg pl/sql object instantiationplslm plsql/cox support for NCOMP processingplsm pmuc pmuo pmux objmgmt/pol support for pl/sql handling of collectionsprifold priold plsql/cox support to allow rpc forwarding to an older releaseprm sqllang/param parameter handling associated with sql layerprsa prsc prssz sqllang/parse prsa - parser for alter cluster command; prsc - parser for create database command; prssz - support for parse context to be savedpsdbnd psdevn progint/dbpsd psdbnd - support for managing bind variables; psdevn - support for pl/sql debuggerpsdicd progint/plsicds small number of ICD to allow pl/sql to call into ‘C’ sourcepsdmsc psdpgi progint/dbpsd psdmsc - pl/sql system dependent miscellaneous functions ; psdpgi - support for opening and closing cursors in pl/sqlpsf plsql/pls pl/sql service related functions for instantiating called pl/sql unit in library cacheqbadrv qbaopn sqllang/qrybufal provides allocation of buffer and control structures in query executionqcdl qcdo dict/dictlkup qcdl - query compile semantic analysis; qcdo - query compile dictionary support for objectsqci dict/shrdcurs support for SQL language parser and semantic analyserqcop qcpi qcpi3 qcpi4 qcpi5 sqllang/parse support for query compilation parse phaseqcs qcs2 qcs3 qcsji qcso dict/dictlkup support for semantic analysis by SQL compilerqct qcto sqllang/typeconv qct - query compile type check operations; qcto - query compile type check operatorsqcu sqllang/parse various utilities provided for sql compilationqecdrv sqllang/qryedchk driver 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 qerxt sqlexec/rowsrc row 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/execsvc run time support for sql executionqkacon qkadrv qkajoi qkatab qke qkk qkn qkna qkne sqlexec/rwsalloc SQL query dynamic structure allocation routinesqks3t sqlexec/execsvc query execution service associated with temp table transformationqksmm qksmms qksop sqllang/compsvc qksmm - memory management services for the SQL compiler; qksmms - memory management simulation services for the SQL compiler; qksop - query compilation service for operand processingqkswc sqlexec/execsvc support for temp table transformation associated for with clause.qmf xmlsupp/util support for ftp server; implements processing of ftp commandsqmr qmrb qmrs xmlsupp/resolver support hierarchical resolverqms xmlsupp/data support for storage and retrieval of XOBsqmurs xmlsupp/uri support for handling URIsqmx qmxsax xmlsupp/data qmx - xml support; qmxsax - support for handling sax processingqmxtc xmlsupp/sqlsupp support for ddl and other operators related to the sql XML supportqmxtgx xmlsupp support for transformation : ADT -> XMLqmxtsk xmlsupp/sqlsupp XMLType support functionsqsme summgmt/dict summary management expression processingqsmka qsmkz dict/dictlkup qsmka - 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/dict qsmp - 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/advsvr summary management advisorqxdid objsupp/objddl support for domain index ddl operationsqxidm objsupp/objsql support for extensible index dml operationsqxidp objsupp/objddl support for domain index ddl partition operationsqxim objsupp/objsql extensible indexing support for objectsqxitex qxopc qxope objsupp/objddl qxitex - support for create / drop indextype; qxope - execution time support for operator callbacks; qxope - execution time support for operator DDLqxopq qxuag qxxm objsupp/objsql qxopq - support for queries with user-defined operators; qxuag - support for user defined aggregate processing; qxxm - queries involving external tablesrfmon rfra rfrdb rfrla rfrm rfrxpt drs implements 9i data guard broker monitorrnm dict/sqlddl manages rename statement operationrpi progint/rpi recursive procedure interface which handles the the environment setup where multiple recursize statements are executed from one top level statementrwoima sqlexec/rwoprnds row operand operationsrwsima sqlexec/rowsrc row source implementation/retrieval according to the defining querysdbima sqlexec/sort manages and performs sort operationselexe sqlexec/dmldrv handles the operation of select statement executionskgm osds platform specific memory management rountines interfacing with O.S. allocation functionssmbima sor sqlexec/sort manages and performs sort operationsqn dict/sqlddl support for parsing references to sequencessrdima srsima stsima sqlexec/sort manages and performs sort operationtbsdrv space/spcmgmt operations for executing create / alter / drop tablespace and related supporting functionsttcclr ttcdrv ttcdty ttcrxh ttcx2y progint/twotask two 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 upsexe sqlexec/dmldrv support 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/vwsubq view optimisation related functionalityxct txn/lcltx support for the management of transactions and savepoint operationsxpl sqlexec/expplan support for the explain plan commandxty sqllang/typeconv type checking functionszlke security/ols/intext label security error handling component.

===============================================================

Inthirties关注Oracle数据库 维护，优化，安全，备份，恢复，迁移，故障处理

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。