ORA-600汇总（下）
日期：2014-05-16 浏览次数：20524 次
ORA-600汇总（上）
此文转载 http://space.itpub.net/13558130 mydbalife的文章
?
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
| 1 | Service Layer |
The 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.
|
|||||||||||||||||||||||||||||||||||||||||||||
| 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;
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
|
