`
wsql
  • 浏览: 11713279 次
  • 性别: Icon_minigender_1
  • 来自: 深圳
文章分类
社区版块
存档分类
最新评论

ORA-600 各个参数含义说明

 
阅读更多

说明:

CSDN 的新blog 对表格的样式支持太差,所以这里的排版很不清楚。 可以下载我的word 文档,下载地址,0分资源,有帐号即可下载。

http://download.csdn.net/source/3480570

一. ORA-600 概述

ORA-600 是一个非常头疼的一个错误。比如:

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

这个就是undo 损坏出现故障的一个提示信息。关于这种情况的解决方法,参考blog:

Current online Redo 和 Undo 损坏的处理方法

http://blog.csdn.net/xujinyang/article/details/6822947

Errorsof the form ORA-600 are called internal errors. This section clarifies themisunderstanding of ORA-600s being synonymous with corruption.

An ORA-600 usually has up to five arguments associated withit which gives Oracle support and developers more information about theerror. The first argument of an ORA-600 indicates wherein the source code an unexpected condition was encountered. Theremaining arguments give information about the variables and data beingexamined. An analyst can then determine if the error was the result of sometype of corruption.

Oracle server source code is subdivided into about 13different layers or modules,each of which is assigned a range of ORA-600 errors. Of these, only some rangespertain directly to the types of corruption described in this paper.

ORA-600通常有5个参数,第一个参数表示的是异常的source code位置。 Oracle Server source code 大致分为了13个不同的layers 和 modules。 关于第一参数的具体说明,在MOS 的文档:[ID175982.1],有详细的说明。

二. 第一个参数说明

在[ID 175982.1]文档上的定义分成了2种:

(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

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.

2.2 Internal Errors Categorised by mnemonic

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)

Functionality

Description

ain ainp

ram/index

ain - alter index; ainp - alter index partition management operation

apacb

optim/rbo

used by optimizer in connect by processing

atb 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 operation

ddfnet

progint/distrib

various distributed operations on remote dictionary

delexe

sqlexec/dmldrv

manages the delete statement operation

dix

ram/index

manages drop index or validate index operation

dtb

dict/sqlddl

manages drop table operation

evaa2g 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 equivalent

gra

security/dac

manages the granting and revoking of privilege rights to a user

gslcsq

plsldap

support for operations with an LDAP server

insexe

sqlexec/dmldrv

handles the insert statement operation

jox

progint/opi

functionality associated with the Java compiler and with the Java runtime environment within the Server

k2c 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 id

k2g k2l

txn/disttx

support for the 2 phase commit protocol protocol and the coordination of the various states in managing the distributed transaction

k2r 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 operation

kad

cartserv/picklercs

handles OCIAnyData implementation

kau

ram/data

manages the modification of indexes for inserts, updates and delete operations for IOTs as well as modification of indexes for IOTs

kcb 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 functionality

kck

rcv

compatibility related checks associated with the compatible parameter

kcl

cache

background lck process which manages locking in a RAC or parallel server multiple instance environment

kco 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 operations

kda

ram/analyze

manages the analyze command and collection of statistics

kdbl kdc kdd

ram/data

support for direct load operation, cluster space management and deleting rows

kdg

ram/analyze

gathers information about the underlying data and is used by the analyze command

kdi 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 up

kdl kdlt

ram/object

lob and temporary lob management

kdo

ram/data

operations on data such as inserting a row piece or deleting a row piece

kdrp

ram/analyze

underlying support for operations provided by the dbms_repair package

kds kdt kdu

ram/data

operations on data such as retrieving a row and updating existing row data

kdv kdx

ram/index

functionality for dumping index and managing index blocks

kfc kfd kfg

asm

support for ASM file and disk operations

kfh kfp kft

rcv

support for writing to file header and transportable tablespace operations

kgaj kgam kgan kgas kgat kgav kgaz

argusdbg/argusdbg

support for Java Debug Wire Protocol (JDWP) and debugging facilites

kgbt 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 policies

kgl kgl2 kgl3 kgla kglp kglr kgls

dict/libcache

generic library cache operation

kgm kgmt

ilms

support for inter language method services - or calling one language from another

kgrq kgsk kgski kgsn kgss

vos

support for priority queue and scheduling; capabilities for Numa support; Service State object manager

kgupa 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 functions

kjak 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 operation

kjxgf 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 Facility

kjxt

ccl/dlm

DLM request message management

kjzc kjzd kjzf kjzg kjzm

ccl/diag

support for diagnosibility amongst OPS related services

kkb

dict/sqlddl

support for operatoins which load/change table definitions

kkbl kkbn kkbo

objsupp/objddl

support for tables with lobs , nested tables and varrays as well as columns with objects

kkdc kkdl kkdo

dict/dictlkup

support for constraints, dictionary lookup and dictionary support for objects

kke

optim/cbo

query engine cost engine; provides support functions that provide cost estimates for queries under a number of different circumstances

kkfd

sqlexec/pq

support for performing parallel query operation

kkfi

optim/cbo

optimizer support for matching of expressions against functional ndexes

kkfr kkfs

sqlexec/pq

support for rowid range handling as well as for building parallel query query operations

kkj

jobqs/jobq

job queue operation

kkkd kkki

dict/dbsched

resource manager related support. Additionally, provides underlying functions provided by dbms_resource_manager and dbms_resource_manager_privs packages

kklr

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 functions

kkn

ram/analyze

support for the analyze command

kko 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 thereof

kkpam kkpap

ram/partnmap

support for mapping predicate keys expressions to equivalent partitions

kkpo kkpoc kkpod

dict/partn

support for creation and modification of partitioned objects

kkqg kkqs kkqs1 kkqs2 kkqs3 kkqu kkqv kkqw

optim/vwsubq

query rewrite operation

kks kksa kksh kksl kksm

dict/shrdcurs

support for managing shared cursors/ shared sql

kkt

dict/sqlddl

support for creating, altering and dropping trigger definitions as well as handling the trigger operation

kkxa

repl/defrdrpc

underlying support for dbms_defer_query package operations

kkxb

dict/sqlddl

library cache interface for external tables

kkxl

dict/plsicds

underlying support for the dbms_lob package

kkxm

progint/opi

support for inter language method services

kkxs

dict/plsicds

underlying support for the dbms_sys_sql package

kkxt

repl/trigger

support for replication internal trigger operation

kkxwtp

progint/opi

entry point into the plsql compiler

kky

drv

support for alter system/session commands

kkz kkzd kkzf kkzg kkzi kkzj kkzl kkzo kkzp kkzq kkzr kkzu kkzv

repl/snapshot

support for snapshots or Materialized View validation and operation

kla klc klcli klx

tools/sqlldr

support for direct path sql loader operation

kmc 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 MTS

knac knafh knaha knahc knahf knahs

repl/apply

replication apply operation associated with Oracle streams

kncc

repl/repcache

support for replication related information stored and maintained in library cache

kncd knce

repl/defrdrpc

replication related enqueue and dequeue of transction data as well as other queue related operations

kncog

repl/repcache

support for loading replicaiton object group information into library cache

kni

repl/trigger

support for replication internal trigger operation

knip knip2 knipi knipl knipr knipu knipu2 knipx

repl/intpkg

support for replication internal package operation.

kno

repl/repobj

support for replication objects

knp 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 collection

knt kntg kntx

repl/trigger

support for replication internal trigger operation

koc

objmgmt/objcache

support for managing ADTs objects in the OOCI heap

kod

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 objects

koi

objmgmt/objmgr

support for object types

koka

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 objects

kokc

objmgmt/objcache

support for pinning , unpinning and freeing objects

kokd

objsupp/datadrv

driver on the server side for managing objects

koke koke2 koki

objsupp/objsql

support for managing objects

kokl

objsupp/objdata

lob access

kokl2

objsupp/objsql

lob DML and programmatic interface support

kokl3

objsupp/objdata

object temporary LOB support

kokle kokm

objsupp/objsql

object SQL evaluation functions

kokn

objsupp/objname

naming support for objects

koko

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 operations

kokt kokt2 kokt3

objsupp/objddl

object compilation type manager

koku kokv

objsupp/objsql

support for unparse object operators and object view support

kol kolb kole kolf kolo

objmgmt/objmgr

support for object Lob buffering , object lob evaluation and object Language/runtime functions for Opaque types

kope2 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 functions

kos

objsupp/objsup

object Stream interfaces for images/objects

kot 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 functions

kpcp kpcxlt

progint/kpc

Kernel programmatic connection pooling and kernel programmatic common type XLT translation routines

kpki

progint/kpki

kernel programatic interface support

kpls

cartserv/corecs

support for string formatting operations

kpn

progint/kpn

support for server to server communication

kpoal8 kpoaq kpob kpodny kpodp kpods kpokgt kpolob kpolon kpon

progint/kpo

support for programmatic operations

kpor

progint/opi

support for streaming protocol used by replication

kposc

progint/kpo

support for scrollable cursors

kpotc

progint/opi

oracle side support functions for setting up trusted external procedure callbacks

kpotx 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 statements

kprb kprc

progint/rpi

support for executing sql efficiently on the Oracle server side as well as for copying data types during rpi operations

kptsc

progint/twotask

callback functions provided to all streaming operation as part of replication functionality

kpu kpuc kpucp

progint/kpu

Oracle kernel side programmatic user interface, cursor management functions and client side connection pooling support

kqan 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 pool

kqr

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_pitr

krvg 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 capabilities

ksx

sqlexec/execsvc

support for query execution associated with temporary tables

ksxa ksxp ksxr

vos

support for various kernel associated capabilities in relation to OPS or RAC operation

kta

space/spcmgmt

support for DML locks and temporary tables associated with table access

ktb 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 map

ktf

txn/lcltx

flashback support

ktfb 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 operation

ktp 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 package

ktsa ktsap ktsau ktsb ktscbr ktsf ktsfx ktsi ktsm ktsp ktss ktst ktsx ktt kttm

space/spcmgmt

support for checking and verifying space usage

ktu ktuc ktur ktusm

txn/lcltx

internal management of undo and rollback segments

kwqa 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 transformations

kwrc kwre

oltp/re

rules engine evaluation

kxcc kxcd kxcs

sqllang/integ

constraint processing

kxdr

sqlexec/dmldrv

DML driver entrypoint

kxfp kxfpb kxfq kxfr kxfx

sqlexec/pq

parallel query support

kxhf kxib

sqlexec/execsvc

khhf- support for hash join file and memory management; kxib - index buffering operations

kxs

dict/instmgmt

support for executing shared cursors

kxti kxto kxtr

dbproc/trigger

support for trigger operation

kxtt

ram/partnmap

support for temporary table operations

kxwph

ram/data

support for managing attributes of the segment of a table / cluster / table-partition

kza

security/audit

support for auditing operations

kzar

security/dac

support for application auditing

kzck

security/crypto

encryption support

kzd

security/dac

support for dictionary access by security related functions

kzec

security/dbencryption

support inserting and retrieving encrypted objects into and out of the database

kzfa kzft

security/audit

support for fine grained auditing

kzia

security/logon

identification and authentication operations

kzp kzra kzrt kzs kzu kzup

security/dac

security related operations associated with privileges

msqima msqimb

sqlexec/sqlgen

support for generating sql statments

ncodef npi npil npixfr

progint/npi

support for managing remote network connection from within the server itself

oba

sqllang/outbufal

operator buffer allocate for various types of operators : concatenate, decode, NVL, etc. the list is extensive.

ocik

progint/oci

OCI oracle server functions

opiaba 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 interfaces

pesblt pfri pfrsqc

plsql/cox

pesblt - pl/sql built in interpreter; pfri - pl/sql runtime; pfrsqc - pl/sql callbacks for array sql and dml with returning

piht

plsql/gen/utl

support for pl/sql implementation of utl_http package

pirg

plsql/cli/utl_raw

support for pl/sql implementation of utl_raw package

pism

plsql/cli/utl_smtp

support for pl/sql implementation of utl_smtp package

pitcb

plsql/cli/utl_tcp

support for pl/sql implementation of utl_tcp package

piur

plsql/gen/utl_url

support for pl/sql implementation of utl_url package

plio

plsql/pkg

pl/sql object instantiation

plslm

plsql/cox

support for NCOMP processing

plsm pmuc pmuo pmux

objmgmt/pol

support for pl/sql handling of collections

prifold priold

plsql/cox

support to allow rpc forwarding to an older release

prm

sqllang/param

parameter handling associated with sql layer

prsa prsc prssz

sqllang/parse

prsa - parser for alter cluster command; prsc - parser for create database command; prssz - support for parse context to be saved

psdbnd psdevn

progint/dbpsd

psdbnd - support for managing bind variables; psdevn - support for pl/sql debugger

psdicd

progint/plsicds

small number of ICD to allow pl/sql to call into 'C' source

psdmsc psdpgi

progint/dbpsd

psdmsc - pl/sql system dependent miscellaneous functions ; psdpgi - support for opening and closing cursors in pl/sql

psf

plsql/pls

pl/sql service related functions for instantiating called pl/sql unit in library cache

qbadrv qbaopn

sqllang/qrybufal

provides allocation of buffer and control structures in query execution

qcdl qcdo

dict/dictlkup

qcdl - query compile semantic analysis; qcdo - query compile dictionary support for objects

qci

dict/shrdcurs

support for SQL language parser and semantic analyser

qcop qcpi qcpi3 qcpi4 qcpi5

sqllang/parse

support for query compilation parse phase

qcs qcs2 qcs3 qcsji qcso

dict/dictlkup

support for semantic analysis by SQL compiler

qct qcto

sqllang/typeconv

qct - query compile type check operations; qcto - query compile type check operators

qcu

sqllang/parse

various utilities provided for sql compilation

qecdrv

sqllang/qryedchk

driver performing high level checks on sql language query capabilities

qerae 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 source

qes3t qesa qesji qesl qesmm qesmmc

sqlexec/execsvc

run time support for sql execution

qkacon qkadrv qkajoi qkatab qke qkk qkn qkna qkne

sqlexec/rwsalloc

SQL query dynamic structure allocation routines

qks3t

sqlexec/execsvc

query execution service associated with temp table transformation

qksmm 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 processing

qkswc

sqlexec/execsvc

support for temp table transformation associated for with clause.

qmf

xmlsupp/util

support for ftp server; implements processing of ftp commands

qmr qmrb qmrs

xmlsupp/resolver

support hierarchical resolver

qms

xmlsupp/data

support for storage and retrieval of XOBs

qmurs

xmlsupp/uri

support for handling URIs

qmx qmxsax

xmlsupp/data

qmx - xml support; qmxsax - support for handling sax processing

qmxtc

xmlsupp/sqlsupp

support for ddl and other operators related to the sql XML support

qmxtgx

xmlsupp

support for transformation : ADT -> XML

qmxtsk

xmlsupp/sqlsupp

XMLType support functions

qsme

summgmt/dict

summary management expression processing

qsmka 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 analysis

qsmp 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 summaries

qsms

summgmt/advsvr

summary management advisor

qxdid

objsupp/objddl

support for domain index ddl operations

qxidm

objsupp/objsql

support for extensible index dml operations

qxidp

objsupp/objddl

support for domain index ddl partition operations

qxim

objsupp/objsql

extensible indexing support for objects

qxitex qxopc qxope

objsupp/objddl

qxitex - support for create / drop indextype; qxope - execution time support for operator callbacks; qxope - execution time support for operator DDL

qxopq qxuag qxxm

objsupp/objsql

qxopq - support for queries with user-defined operators; qxuag - support for user defined aggregate processing; qxxm - queries involving external tables

rfmon rfra rfrdb rfrla rfrm rfrxpt

drs

implements 9i data guard broker monitor

rnm

dict/sqlddl

manages rename statement operation

rpi

progint/rpi

recursive procedure interface which handles the the environment setup where multiple recursize statements are executed from one top level statement

rwoima

sqlexec/rwoprnds

row operand operations

rwsima

sqlexec/rowsrc

row source implementation/retrieval according to the defining query

sdbima

sqlexec/sort

manages and performs sort operation

selexe

sqlexec/dmldrv

handles the operation of select statement execution

skgm

osds

platform specific memory management rountines interfacing with O.S. allocation functions

smbima sor

sqlexec/sort

manages and performs sort operation

sqn

dict/sqlddl

support for parsing references to sequences

srdima srsima stsima

sqlexec/sort

manages and performs sort operation

tbsdrv

space/spcmgmt

operations for executing create / alter / drop tablespace and related supporting functions

ttcclr 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 versa

uixexe 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 insert

vop

optim/vwsubq

view optimisation related functionality

xct

txn/lcltx

support for the management of transactions and savepoint operations

xpl

sqlexec/expplan

support for the explain plan command

xty

sqllang/typeconv

type checking functions

zlke

security/ols/intext

label security error handling component

三. 其他参数说明

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

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

http://blog.csdn.net/xujinyang/article/details/6922438

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

http://blog.csdn.net/xujinyang/article/details/6831310

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

ERROR:

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

ARGUMENTS:

Arg [a] Current SCN WRAP

Arg [b] Current SCN BASE

Arg [c] dependent SCN WRAP

Arg [d] dependent SCN BASE

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

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

Oracle rdba和 dba 说明

http://blog.csdn.net/xujinyang/article/details/6829256

From kcrf.h:

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

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

SCN value is storedinternally as :

(1)SCN_wrap

(2)SCN_base

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

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

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

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

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

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

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

-- (a) Get the current SCN base.

SQL>select max(scn_bas) SCN_BASE fromsmon_scn_time;

1603342197

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

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

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

TIMESTAMP SCN

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

28-JUL-06 05:31:08 8252235517813

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

ARGUMENTS:

Arg [a] Current SCN WRAP

Arg [b] Current SCN BASE

Arg [c] dependent SCNWRAP

Arg [d] dependent SCN BASE

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

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

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

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

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

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

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

这里面提到的一些概念可以参考我的blog:

Oracle 实例恢复时 前滚(roll forward) 后滚(rollback) 问题

http://blog.csdn.net/xujinyang/article/details/6831268

Orace ITL(InterestedTransaction List) 说明

http://blog.csdn.net/xujinyang/article/details/6823264

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics