1、Ora00600错误代码含义及常用查询Ora-00600 错误的代码含义及常用查询ora-600是Oracle对于一些内部错误的一个统一的错误号（类似的还有ora-7445）。要判断ora-600错误具体的类型，一般要根据其第一个参数来区分。一个ora-600的例子如下：ORA-00600: internal error code, arguments: 15700, 3, 0x1DDE1AAB0, , , , , 其中15700代表这个错误的具体类型，这是和并行查询相关的一个内部错误，后面的几个参数则是该错误的一些具体参数，不同类型的错误，参数的意义也不尽相同。ora-600一共有两大类，一
2、类的错误类型以数字标识，另外一类则以字符串标识。数字表示不同的内核层，而字符串则是具体的函数或者模块名。在Metalink的Doc ID: 175982.1 中，oracle列举了这两类错误的详细信息，转录在这里以供需要是查询：援引 Metalink 文档 175982.1中，列举Ora-600错误代码供参考：数字类型的Ora-600Ora-600 BaseFunctionalityDescription1Service LayerThe service layer has within it a variety of servicerelated components which are a
3、ssociated 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 communicat
4、ion 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
5、the same way as is provided by an Operating System. Ora-600 BaseFunctionalityDescription1vosComponent notifier100vosDebug300vosError500vosLock700vosMemory900vosSystem Parameters1100vosSystem State object1110vosGeneric Linked List management1140vosEnqueue1180vosInstance Locks1200vosUser State object1
6、400vosAsync Msgs1700voslicense Key1800vosInstance Registration1850vosI/O Services components2000Cache LayerWhere errors are generated in this area, it is advisableto check whether the error is repeatable and whether the error is perhaps associated with recovery or undo type operations; wherethis is
7、the case and the error is repeatable, this may suggest some kind of hardware or physical issue with a data file, controlfile 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
8、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 BaseFunctionalityDescription2000server/rcvCache Op2100server/rcvControl File mgmt2200server/rcvMisc (SCN etc.)2400server/rcvBuffer Instance Ha
9、sh Table2600server/rcvRedo file component2800server/rcvDb file3000server/rcvRedo Application3200server/cacheBuffer manager3400server/rcvArchival & media recovery component3600server/rcvrecovery component3700server/rcvThread component3800server/rcvCompatibility segmentIt is important to consider when
10、 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 maintainingstructures associated with the management of transactions. As with the cache layer , p
11、roblems 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 BaseFunctionalityDescription4000server/txnTransaction Undo4100server/txnTransaction Undo4210server/txnTransaction Paralle
12、l4250server/txnTransaction List4300space/spcmgmtTransaction Segment4400txn/lcltxTransaction Control4450txn/lcltxdistributed transaction control4500txn/lcltxTransaction Block4600space/spcmgmtTransaction Table4800dict/rowcacheQuery Row Cache4900space/spcmgmtTransaction Monitor5000space/spcmgmtTransact
13、ion ExtentIt is important to try and determine what the object involved in any reproducible problem is. Thenuse 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 N
14、ote 35512.1. 6000Data LayerThe data layer is responsible for maintaining and managingthe data in the database tables and indexes. Issues in this area may indicate some kind of physical issue at the object level andtherefore, it is important to try and isolate the object and then perform an anlayze o
15、n the object to validate its structure. Ora-600 BaseFunctionalityDescription6000ram/data ram/analyze ram/indexdata, analyze command and index related activity7000ram/objectlob related errors8000ram/datageneral data access8110ram/indexindex related8150ram/objectgeneral data accessAgain, it is importa
16、nt 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/
17、Oracle Interface & SQL Layer ComponentsThis layer governs the user interface with the Oracleserver. Problems generated by this layer usually indicate : some kind of presentation or format error in the data received by theserver, i.e. the client may have sent incomplete information; or there is some
18、kind of issue which indicates that the data is received out of sequence Ora-600 BaseFunctionalityDescription12200progint/kpo progint/opilob related errors at interface level on server side, xa , etc.12300progint/ifOCI interface to coordinating global transactions12400sqlexec/rowsrctable row source a
19、ccess12600space/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/inte
20、gconstraint 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 Oracl
21、e16000tools/sqlldrsql loader relatedYou 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. Effectivelyit acts
22、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 BaseFunctionalityDescription14000osdsFile access14100osdsConcurrency management;14200osdsProcess management;14300osdsException-handler or signal handl
23、er management14500osdsMemory allocation15000security/dac, security/logon security/ldaplocal user access validation; challenge / response activity forremote access validation; auditing operation; any activities associated with granting and revoking of privileges; validation of password with external
24、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 informat
25、ion 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 are
26、a 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/d
27、ictlkupperforms 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
28、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 Paralle
29、l 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;
30、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
