Shulou(Shulou.com)05/31 Report--

This article mainly explains "the analysis of the meaning of each parameter of ORA-600 in the database". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "the analysis of the meaning of the parameters of ORA-600 in the database".

one。 Overview of ORA-600

ORA-600 is a big headache. For example:

ORA-00600:internal error code, arguments: [4194], [43], [46], []

This is a reminder of a failure of undo damage.

two。 The first parameter states

The definitions on the [ID 175982.1] document fall into two categories:

(1) the first parameter is a number which reflects the source componentor layer the error is connected with; or

(2) the first parameter is a mnemonic which indicates the source modulewhere the error originated. This type of internal error is now used inpreference to an internal error number.

2.1 Internal Errors Categorised by numberrange (numeric type)

Thefollowing table provides an indication of internal error codes used in theOracle server. Thus, if ora-600 [X] is encountered, it is possible to glean somehigh level background information: the error in generated in the Y layer whichindicates that there may be a problem with Z.

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 1 vos Component notifier 100 vos Debug 300 vos Error 500 vos Lock 700 vos Memory 900 vos System Parameters 1100 vos System State object 1110 vos Generic Linked List management 1140 vos Enqueue 1180 vos Instance Locks 1200 vos User State object 1400 vos Async Msgs 1700 vos license Key 1800 vos Instance Registration 1850 vos I/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 2000 server/rcv Cache Op 2100 server/rcv Control File mgmt 2200 server/rcv Misc (SCN etc.) 2400 server/rcv Buffer Instance Hash Table 2600 server/rcv Redo file component 2800 server/rcv Db file 3000 server/rcv Redo Application 3200 server/cache Buffer manager 3400 server/rcv Archival & media recovery component 3600 server/rcv recovery component 3700 server/rcv Thread component 3800 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.

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 4000 server/txn Transaction Undo 4100 server/txn Transaction Undo 4210 server/txn Transaction Parallel 4250 server/txn Transaction List 4300 space/spcmgmt Transaction Segment 4400 txn/lcltx Transaction Control 4450 txn/lcltx distributed transaction control 4500 txn/lcltx Transaction Block 4600 space/spcmgmt Transaction Table 4800 dict/rowcache Query Row Cache 4900 space/spcmgmt Transaction Monitor 5000 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 Note 28814.1; in addition, it may be worth using the dbverify as discussed in Note 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 6000 ram/data ram/analyze ram/index data, analyze command and index related activity 7000 ram/object lob related errors 8000 ram/data general data access 8110 ram/index index related 8150 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 Note 28814.1; in addition, it may be worth using the dbverify as discussed in Note 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 12200 progint/kpo progint/opi lob related errors at interface level on server side, xa, etc. 12300 progint/if OCI interface to coordinating global transactions 12400 sqlexec/rowsrc table row source access 12600 space/spcmgmt operations associated with tablespace: alter / create / drop operations Operations associated with create table / cluster 12700 sqlexec/rowsrc bad rowid 13000 dict/if dictionary access routines associated with kernel compilation 13080 ram/index kernel Index creation 13080 sqllang/integ constraint mechanism 13100 progint/opi archival and Media Recovery component 13200 dict/sqlddl alter table mechanism 13250 security/audit audit statement processing 13300 objsupp/objdata support for handling of object generation and object access 14000 dict/sqlddl sequence generation 15000 progint/kpo logon to Oracle 16000 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.

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 14000 osds File access 14100 osds Concurrency management; 14200 osds Process management; 14300 osds Exception-handler or signal handler management 14500 osds Memory 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 iUnip o operation, direct iUnip 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 operations2.2 Internal Errors Categorised by mnemonic (string type)

Thefollowing table details mnemonics error stems which are possible. If you haveencountered: ora-600 [kkjsrj:1] for example, you should look down the ErrorMnemonic column (errors in alphabetical order) until you find the matchingstem. In this case, kkj indicates that something unexpected has occurred in jobqueue operation.

Error Mnemonic (s) FunctionalityDescriptionain ainpram/indexain-alter index; ainp-alter index partition management operationapacboptim/rboused by optimizer in connect by processingatb atbi atbo ctc ctci cvwdict/sqlddlalter table, create table (IOT) or cluster operations as well as create view related operations (with constraint handling functionality) dbsdrvsqllang/parsealter / create database operationddfnetprogint/distribvarious distributed operations on remote dictionarydelexesqlexec/dmldrvmanages the delete statement operationdixram/indexmanages drop index or validate index operationdtbdict/sqlddlmanages drop table operationevaa2g evah3p evaa2gdbproc/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 expgondbproc/exprevalhandles expression evaluation with respect to two operands being equivalentgrasecurity/dacmanages the granting and revoking of privilege rights to a usergslcsqplsldapsupport for operations with an LDAP serverinsexesqlexec/dmldrvhandles the insert statement operationjoxprogint/opifunctionality associated with the Java compiler and with the Java runtime environment within the Serverk2c k2dprogint/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 k2spprogint/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 ina distributed environment.k2vtxn/disttxhandles distributed recovery operationkadcartserv/picklercshandles OCIAnyData implementationkauram/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 kcbzcachemanages Oracle's buffer cache operation as well as operations used by capabilities such as direct load, has clusters, etc.kcc kcfrcvmanages and coordinates operations on the control file (s) kcitcontext/triggerinternal trigger functionalitykckrcvcompatibility related checks associated with the compatible parameterkclcachebackground lck process which manages locking ina 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.kdram/datasupport for row level dependency checking and some log miner operationskdaram/analyzemanages the analyze command and collection of statisticskdbl kdc kddram/datasupport for direct load operation Cluster space management and deleting rowskdgram/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 kdltram/objectlob and temporary lob managementkdoram/dataoperations on data such as inserting a row piece or deleting a row piecekdrpram/analyzeunderlying support for operations provided by the dbms_repair packagekds kdt kduram/dataoperations on data such as retrieving a row and updating existing row datakdv kdxram/indexfunctionality for dumping index and managing index blockskfc kfd kfgasmsupport for ASM file and disk operationskfh kfp Kftrcvsupport for writing to file header and transportable tablespace operationskgaj kgam kgan kgas kgat kgav kgazargusdbg/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 kglsdict/libcachegeneric library cache operationkgm kgmtilmssupport for inter language method services-or calling one language from anotherkgrq kgsk kgski kgsn kgssvossupport 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.kgxpvosinter 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 kjxgrccl/cgsprovides communication & synchronisation associated with GMS or OPS related functionality as well as name service and OPS Instance Membership Recovery Facilitykjxtccl/dlmDLM request message managementkjzc kjzd kjzf kjzg kjzmccl/diagsupport for diagnosibility amongst OPS related serviceskkbdict/sqlddlsupport for operatoins which load/change table definitionskkbl kkbn kkboobjsupp/objddlsupport for tables with lobs, nested tables and varrays as well as columns with objectskkdc kkdl kkdodict/dictlkupsupport for constraints, dictionary lookup and dictionary support for objectskkeoptim/cboquery engine cost engine Provides support functions that provide cost estimates for queries under a number of different circumstanceskkfdsqlexec/pqsupport for performing parallel query operationkkfioptim/cbooptimizer support for matching of expressions against functional ndexeskkfr kkfssqlexec/pqsupport for rowid range handling as well as for building parallel query query operationskkjjobqs/jobqjob queue operationkkkd kkkidict/dbschedresource manager related support. Additionally, provides underlying functions provided by dbms_resource_manager and dbms_resource_manager_privs packageskklrdict/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 kkmidict/dictlkupprovides various semantic checking functionskknram/analyzesupport for the analyze commandkko kkocrioptim/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 kkpapram/partnmapsupport for mapping predicate keys expressions to equivalent partitionskkpo kkpoc kkpoddict/partnsupport for creation and modification of partitioned objectskkqg kkqs kkqs1 kkqs2 kkqs3 kkqu kkqv kkqwoptim/vwsubqquery rewrite operationkks kksa kksh kksl kksmdict/shrdcurssupport for managing shared cursors/ shared sqlkktdict/sqlddlsupport for creating Altering and dropping trigger definitions as well as handling the trigger operationkkxarepl/defrdrpcunderlying support for dbms_defer_query package operationskkxbdict/sqlddllibrary cache interface for external tableskkxldict/plsicdsunderlying support for the dbms_lob packagekkxmprogint/opisupport for inter language method serviceskkxsdict/plsicdsunderlying support for the dbms_sys_sql packagekkxtrepl/triggersupport for replication internal trigger operationkkxwtpprogint/opientry point into the plsql compilerkkydrvsupport 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 klxtools/sqlldrsupport for direct path sql loader operationkmc kmcp kmd kmm kmrmts/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 knahsrepl/applyreplication apply operation associated with Oracle streamsknccrepl/repcachesupport for replication related information stored and maintained in library cachekncd kncerepl/defrdrpcreplication related enqueue and dequeue of transction data as well as other queue related operationskncogrepl/repcachesupport for loading replicaiton object group information into library cacheknirepl/triggersupport for replication internal trigger operationknip knip2 knipi knipl knipr knipu knipu2 knipxrepl/intpkgsupport for replication internal package operation.knorepl/repobjsupport for replication objectsknp knpc knpcb knpcd knpqc knpsrepl/defrdrpcoperations assocaied with propagating transactions to a remote node and coordination of this activity.knstrepl/statsreplication statistics collectionknt kntg Kntxrepl/triggersupport for replication internal trigger operationkocobjmgmt/objcachesupport for managing ADTs objects in the OOCI heapkodobjmgmt/datamgrsupport for persistent storage for objects: for read/write objects To manage object IDs, and to manage object concurrency and recovery.kohobjmgmt/objcacheobject heap manager provides memory allocation services for objectskoiobjmgmt/objmgrsupport for object typeskokaobjsupp/objdatasupport for reading images, inserting images, updating images, and deleting images based on object references (REFs). Kokb kokb2objsupp/objsqlsupport for nested table objectskokcobjmgmt/objcachesupport for pinning Unpinning and freeing objectskokdobjsupp/datadrvdriver on the server side for managing objectskoke koke2 kokiobjsupp/objsqlsupport for managing objectskoklobjsupp/objdatalob accesskokl2objsupp/objsqllob DML and programmatic interface supportkokl3objsupp/objdataobject temporary LOB supportkokle kokmobjsupp/objsqlobject SQL evaluation functionskoknobjsupp/objnamenaming support for objectskokoobjsupp/objsupsupport functions to allow oci/rpi to communicate with Object Management Subsystem (OMS). Kokq koks koks2 koks3 koksrobjsupp/objsqlquery optimisation for objects, semantic checking and semantic rewrite operationskokt kokt2 kokt3objsupp/objddlobject compilation type managerkoku kokvobjsupp/objsqlsupport for unparse object operators and object view supportkol kolb kole kolf koloobjmgmt/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 functionskosobjsupp/objsupobject Stream interfaces for images/objectskot kot2 kotgobjmgmt/typemgrsupport for dynamic type operations to create, delete And update types.koxs koxxobjmgmt/objmgtobject generic image Stream routines and miscellaneous generic object functionskpcp kpcxltprogint/kpcKernel programmatic connection pooling and kernel programmatic common type XLT translation routineskpkiprogint/kpkikernel programatic interface supportkplscartserv/corecssupport for string formatting operationskpnprogint/kpnsupport for server to server communicationkpoal8 kpoaq kpob kpodny kpodp kpods kpokgt kpolob kpolon kponprogint/kposupport for programmatic operationskporprogint/opisupport for streaming protocol used by replicationkposcprogint/kposupport for scrollable cursorskpotcprogint/opioracle side support functions for setting up trusted external procedure callbackskpotx kpovprogint/kposupport for managing local and distributed transaction coordination.kpp2 kpp3sqllang/parsekpp2-parse routines for dimensions

Kpp3-parse support for create/alter/drop summary statementskprb kprcprogint/rpisupport for executing sql efficiently on the Oracle server side as well as for copying data types during rpi operationskptscprogint/twotaskcallback functions provided to all streaming operation as part of replication functionalitykpu kpuc kpucpprogint/kpuOracle kernel side programmatic user interface, cursor management functions and client side connection pooling supportkqan kqap kqasargusdbg/argusdbgserver-side notifiers and callbacks for debug operations.kql kqld kqlpdict/libcacheSQL Library Cache manager-manages the sharing of sql statements in the shared poolkqrdict/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 krpircvBackup 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 krvtrcv/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 ksxrvossupport for various kernel associated capabilities in relation to OPS or RAC operationktaspace/spcmgmtsupport for DML locks and temporary tables associated with table accessktb ktbt ktctxn/lcltxtransaction control operations at the block level: locking block, allocating space within the block, freeing up space, etc.ktec ktef ktehw ktein ktel kteop kteuspace/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 mapktftxn/lcltxflashback supportktfb ktfd ktft ktmspace/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 ktritxn/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 ktusmtxn/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 kwreoltp/rerules engine evaluationkxcc kxcd kxcssqllang/integconstraint processingkxdrsqlexec/dmldrvDML driver entrypointkxfp kxfpb kxfq kxfr kxfxsqlexec/pqparallel query supportkxhf kxibsqlexec/execsvckhhf- support for hash join file and memory management Kxib-index buffering operationskxsdict/instmgmtsupport for executing shared cursorskxti kxto kxtrdbproc/triggersupport for trigger operationkxttram/partnmapsupport for temporary table operationskxwphram/datasupport for managing attributes of the segment of a table / cluster / table-partitionkzasecurity/auditsupport for auditing operationskzarsecurity/dacsupport for application auditingkzcksecurity/cryptoencryption supportkzdsecurity/dacsupport for dictionary access by security related functionskzecsecurity/dbencryptionsupport inserting and retrieving encrypted objects into and out of the databasekzfa kzftsecurity/auditsupport for fine grained auditingkziasecurity/logonidentification and authentication operationskzp kzra kzrt kzs kzu kzupsecurity/dacsecurity related operations associated with privilegesmsqima msqimbsqlexec/sqlgensupport for generating sql statmentsncodef npi npil npixfrprogint/npisupport for managing remote network connection from within the Server itselfobasqllang/outbufaloperator buffer allocate for various types of operators: concatenate Decode, NVL, etc. The list is extensive.ocikprogint/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.orlrobjmgmt/objmgrsupport for C langauge interfaces to user-defined types (UDTs) orpobjmgmt/pickleroracle's external pickler / opaque type interfacespesblt pfri pfrsqcplsql/coxpesblt-pl/sql built in interpreter Pfri-pl/sql runtime Pfrsqc-pl/sql callbacks for array sql and dml with returningpihtplsql/gen/utlsupport for pl/sql implementation of utl_http packagepirgplsql/cli/utl_rawsupport for pl/sql implementation of utl_raw packagepismplsql/cli/utl_smtpsupport for pl/sql implementation of utl_smtp packagepitcbplsql/cli/utl_tcpsupport for pl/sql implementation of utl_tcp packagepiurplsql/gen/utl_urlsupport for pl/sql implementation of utl_url packageplioplsql/pkgpl/sql object instantiationplslmplsql/coxsupport for NCOMP processingplsm pmuc pmuo pmuxobjmgmt/polsupport for pl/sql handling of collectionsprifold prioldplsql/coxsupport to allow rpc Forwarding to an older releaseprmsqllang/paramparameter handling associated with sql layerprsa prsc prsszsqllang/parseprsa-parser for alter cluster command Prsc-parser for create database command; prssz-support for parse context to be savedpsdbnd psdevnprogint/dbpsdpsdbnd-support for managing bind variables; psdevn-support for pl/sql debuggerpsdicdprogint/plsicdssmall number of ICD to allow pl/sql to call into 'C'sourcepsdmsc psdpgiprogint/dbpsdpsdmsc-pl/sql system dependent miscellaneous functions; psdpgi-support for opening and closing cursors in pl/sqlpsfplsql/plspl/sql service related functions for instantiating called pl/sql unit in library cacheqbadrv qbaopnsqllang/qrybufalprovides allocation of buffer and control structures in query executionqcdl qcdodict/dictlkupqcdl-query compile semantic analysis Qcdo-query compile dictionary support for objectsqcidict/shrdcurssupport for SQL language parser and semantic analyserqcop qcpi qcpi3 qcpi4 qcpi5sqllang/parsesupport for query compilation parse phaseqcs qcs2 qcs3 qcsji qcsodict/dictlkupsupport for semantic analysis by SQL compilerqct qctosqllang/typeconvqct-query compile type check operations; qcto-query compile type check operatorsqcusqllang/parsevarious utilities provided for sql compilationqecdrvsqllang/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 qesmmcsqlexec/execsvcrun time support for sql executionqkacon qkadrv qkajoi qkatab qke qkk qkn qkna qknesqlexec/rwsallocSQL query dynamic structure allocation routinesqks3tsqlexec/execsvcquery execution service associated with temp table transformationqksmm qksmms qksopsqllang/compsvcqksmm-memory management services for the SQL compiler; qksmms-memory management simulation services for the SQL compiler; qksop-query compilation service for operand processingqkswcsqlexec/execsvcsupport for temp table transformation associated for with clause.qmfxmlsupp/utilsupport for ftp server Implements processing of ftp commandsqmr qmrb qmrsxmlsupp/resolversupport hierarchical resolverqmsxmlsupp/datasupport for storage and retrieval of XOBsqmursxmlsupp/urisupport for handling URIsqmx qmxsaxxmlsupp/dataqmx-xml support; qmxsax-support for handling sax processingqmxtcxmlsupp/sqlsuppsupport for ddl and other operators related to the sql XML supportqmxtgxxmlsuppsupport for transformation: ADT-> XMLqmxtskxmlsupp/sqlsuppXMLType support functionsqsmesummgmt/dictsummary management expression processingqsmka qsmkzdict/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 qsmqutlsummgmt/dictqsmp-summary management partition processing; qsmq-summary

Management dictionary access; qsmqcsm-support for create / drop / alter summary and related dimension operations; qsmqutl-support for summariesqsmssummgmt/advsvrsummary management advisorqxdidobjsupp/objddlsupport for domain index ddl operationsqxidmobjsupp/objsqlsupport for extensible index dml operationsqxidpobjsupp/objddlsupport for domain index ddl partition operationsqximobjsupp/objsqlextensible indexing support for objectsqxitex qxopc qxopeobjsupp/objddlqxitex-support for create / drop indextype; qxope-execution time support for operator callbacks; qxope-execution time support for operator DDLqxopq qxuag qxxmobjsupp/objsqlqxopq-support for queries with user-defined operators; qxuag-support for user defined aggregate processing Qxxm-queries involving external tablesrfmon rfra rfrdb rfrla rfrm rfrxptdrsimplements 9i data guard broker monitorrnmdict/sqlddlmanages rename statement operationrpiprogint/rpirecursive procedure interface which handles the the environment setup where multiple recursize statements are executed from one top level statementrwoimasqlexec/rwoprndsrow operand operationsrwsimasqlexec/rowsrcrow source implementation/retrieval according to the defining querysdbimasqlexec/sortmanages and performs sort operationselexesqlexec/dmldrvhandles the operation of select statement executionskgmosdsplatform specific memory management rountines interfacing with O.S. Allocation functionssmbima sorsqlexec/sortmanages and performs sort operationsqndict/sqlddlsupport for parsing references to sequencessrdima srsima stsimasqlexec/sortmanages and performs sort operationtbsdrvspace/spcmgmtoperations for executing create / alter / drop tablespace and related supporting functionsttcclr ttcdrv Ttcdty ttcrxh ttcx2yprogint/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 upsexesqlexec/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 insertvopoptim/vwsubqview optimisation related functionalityxcttxn/lcltxsupport for the management of transactions and savepoint operationsxplsqlexec/expplansupport for the explain plan commandxtysqllang/typeconvtype checking functionszlkesecurity/ols/intextlabel security error handling component III. Description of other parameters

There are instructions in the MOS document: [ID28929.1].

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

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

An in-depth study on the relationship between Oracle DB Server system time Modification and SCN

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

The format and description of the parameters of ORA-600 are as follows:

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.

Note that the DBA here refers to Data Block Address. For instructions, please refer to my Blog:

Oracle rdba and dba description

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 undosegment 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 isfor 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 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

Now let's take a look at the relationship between these five parameters.

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.

Based on SCN WRAP and SCN BASE, we can calculate the timestamp corresponding to the current SCN.

Consult dbsnake about the relationship with depent SCN and current SCN. The responses are as follows:

When a library is clean shutdown, Oracle must do full checkpoint, write all dirty block back to their respective datafile, and write the current SCN back to the datafile header of each datafile as checkpoint SCN. In other words, if a library is clean shutdown, then it is impossible for the library to have a block of SCN (there are three types of SCN in a block of Oracle, namely, the SCN,CSC of the block and the commit SCN recorded in ITL) is larger than the checkpoint SCN just written back.

When a library starts, Oracle does a series of checks, one of which is that Oracle checks some blocks under the system tablespace. If Oracle finds that the SCN in these blocks is larger than the current current SCN of the library (in fact, the current SCN at startup is from the checkpoint SCN recorded in datafileheader when shutdown), it indicates that there is something wrong with the library.

At this point, Oracle will report a series of errors related to SCN, and ORA-600 [2662] is just one of them. In the case of ORA-600 [2662], dependent SCN is actually the SCN in some blocks under the system tablespace where Oracle found a problem, and this SCN may be the commit SCN recorded in the ITL in this block, or it may be CSC (cleanout SCN).

According to dbsnake, this dependent SCN is the SCN in a data block. Normally, the SCN is less than current SCN, and when the dependent SCN is greater than current SCN, the relevant error will be reported. Both instance failure and physical corruption can cause this problem.

At this point, I believe you have a deeper understanding of the "analysis of the meaning of the parameters of ORA-600 in the database". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.