`

ora 600 错误分类

SQL ServerOracleCacheSQLAccess 
阅读更多

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

Ora-600 BaseFunctionalityDescription
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.
 

Ora-600 BaseFunctionalityDescription
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 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 BaseFunctionalityDescription
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.
 
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 BaseFunctionalityDescription
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.
 
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 BaseFunctionalityDescription
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.
 
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 sequence
 

 

Ora-600 BaseFunctionalityDescription
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.
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 BaseFunctionalityDescription
14000 osds File access
14100 osds Concurrency management; 
14200 osds Process management;
14300 osds Exception-handler or signal handler management
14500 osds Memory allocation
15000 security/dac,
security/logon
security/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 file
15100 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 cursors
15230 dict/sqlddl manages the compilation of triggers
15260 dict/dictlkup
dict/libcache 		dictionary lookup and library cache access
15400 server/drv manages alter system and alter session operations
15410 progint/if manages compilation of pl/sql packages and procedures
15500 dict/dictlkup performs dictionary lookup to ensure semantics are correct
15550 sqlexec/execsvc
sqlexec/rowsrc 		hash join execution management; 
parallel row source management
15600 sqlexec/pq component provides support for Parallel Query operation
15620 repl/snapshots manages the creation of snapshot or materialized views as well as related snapshot / MV operations
15640 repl/defrdrpc layer containing various functions for examining the deferred transaction queue and retrieving information
15660 jobqs/jobq manages the operation of the Job queue background processes
15670 sqlexec/pq component provides support for Parallel Query operation
15700 sqlexec/pq component provides support for Parallel Query operation; specifically mechanism for starting up and shutting down query slaves
15800 sqlexec/pq component provides support for Parallel Query operation
15810 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 operation
15850 sqlexec/execsvc component provides support for the execution of SQL statements
15860 sqlexec/pq component provides support for Parallel Query operation
16000 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) operation
16400 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_pipe
17270 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 functions
17990 plsql plsql ’standard’ package related issues
18000 txn/lcltx transaction and savepoint management operations 
19000 optim/cbo cost based optimizer related operations
20000 ram/index bitmap index and index related errors.
20400 ram/partnmap operations on partition related objects
20500 server/rcv server recovery related operation
21000 repl/defrdrpc, 
repl/snapshot,
repl/trigger 		replication related features
23000 oltp/qs AQ related errors.
24000 dict/libcache operations associated with managing stored outlines
25000 server/rcv tablespace management operations

字符串类型的Ora-600

Error Mnemonic(s)FunctionalityDescription
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 propaga
分享到：
| 非归档模式下,ORA-01190错误解决案例
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    Oracle错误码大全

    1. 错误码分类： - ORA-00001到ORA-09999：这部分错误码主要涉及SQL语法错误、并发控制问题（如唯一性约束违反）和事务管理等。 - ORA-10000到ORA-19999：这部分是Oracle内部错误，通常表示数据库系统在执行某些...

    ORA-00600 reference

    #### 错误分类 ORA-00600 错误可以根据其内部代码进行分类，这些内部代码提供了关于引发错误的具体组件的信息。以下是对 ORA-00600 错误的一些常见分类： ##### **服务层 (0000)** 服务层错误主要涉及数据库服务层...

    Ora92ErrMsg.chm

    1. **错误分类**：错误信息按类别划分，如网络问题、数据完整性问题、SQL语法错误等，方便用户根据问题类型进行查找。 2. **错误代码**：每个错误代码都有详细的解释，包括错误产生的原因、可能的影响以及如何修复...

    oracle 错误代码一览表

    下面是 Oracle 错误代码的详细分类： * ORA-00001 到 ORA-00999: 语法错误 * ORA-01000 到 ORA-01999: 语义错误 * ORA-02000 到 ORA-02999: 运行时错误 * ORA-03000 到 ORA-03999: 系统错误 * ORA-04000 到 ORA-...

    Ora9iSQL参考手册.zip

    Ora9iSQL参考手册 oracle函数大全 分类显示 Oracle函数大全 Oracle函数手册 ORACLE九阴真经 oracle知识库 SQLCodes Oracle错误代码与消息解释 SQL语言参考大全

    oracle10g 错误代码

    1. **错误分类**： - **系统错误**：这类错误通常涉及到数据库的内部操作，如内存管理、进程控制等，常见的如ORA-600、ORA-7445。 - **用户错误**：用户在执行SQL语句或应用逻辑时可能出现的错误，如ORA-00922...

    Oracle报错信息速查

    ORA-00001 错误表示违反唯一约束条件，这个错误通常发生在 insert、update 或 delete 操作时。当用户尝试插入或更新数据时，Oracle 数据库将检查数据是否违反唯一约束条件，如果违反，则返回 ORA-00001 错误。 二、...

    Oracle错误码.docx

    * 系统错误码（ORA-00001 ~ ORA-00999）：这些错误码是 Oracle 数据库管理系统的核心组件，用于描述系统级别的错误。 * SQL 错误码（ORA-01000 ~ ORA-01999）：这些错误码是指 SQL 语句执行过程中的错误。 * PL/SQL ...

    Oracle错误大全

    1. 错误分类： Oracle错误通常分为两类：用户错误（User Errors）和系统错误（System Errors）。用户错误通常是由于SQL语句编写不当或违反数据库约束引起的，如语法错误、权限不足等。系统错误则涉及数据库内部操作...

    Oracle常见问题的错误码大全

    2. 错误码分类：Oracle错误可以大致分为逻辑错误、语法错误、网络错误、存储错误等。例如，“ORA-00001”表示唯一性约束违反，通常是由于插入或更新操作试图创建一个违反唯一索引或唯一约束的数据行；“ORA-01403”...

    ORACLE 错误码大全

    5. **错误分类**：错误码可以按类别分组，如网络问题（如TNS错误）、存储问题、备份与恢复问题、性能问题等，这有助于快速定位问题所在的领域。 6. **错误处理**：对于严重的错误，可能需要通过回滚事务、重启实例...

    as4+ora9204

    【标签】"as4+ora9204" 是对主题的关键词提炼，便于搜索和分类，提示读者该内容与这两个技术组件的集成有关。 【压缩包子文件的文件名称】"RedHat Linux AS4下安装Oracle9i.pdf" 显示了压缩包内包含一份详细的PDF...

    ORACLE 异常错误处理

    这类错误可以通过捕获通用的`ORA-xxxxx`错误代码来处理。 3. **用户自定义异常**：当开发者需要处理一些特定的情况时，可以自己定义异常。这种方式提供了更大的灵活性，可以根据具体的应用场景来定制错误处理逻辑...

    Oracle 错误码大全 ERROR CODE LIST

    1. **错误分类**：Oracle错误大致可以分为两类，一类是SQL错误，这类错误通常与SQL语句的语法、权限或逻辑有关；另一类是PL/SQL错误，主要涉及存储过程、函数、触发器等PL/SQL组件。 2. **错误处理**：当Oracle遇到...

    Oracle错误一览表

    在提供的四个文档中，"Oracle错误一览表1-4.doc"可能分别包含了不同部分的错误代码，或者是按错误类型、严重程度或者更新日期进行的分类。这些文档可以作为日常工作的必备参考资料，帮助我们在面对Oracle数据库问题...

    Oracle官方文档CHM合集 Oracle10g错误代码

    1. 错误分类：错误代码通常按类别划分，如网络问题、数据一致性错误、SQL语法错误等，这有助于快速定位问题所在领域。 2. 错误描述：每个错误代码都有对应的错误描述，清晰解释了错误发生的情况和可能的原因。 3. ...

    oracle错误码大全(chm

    2. **错误码分类**： - 系统错误：与Oracle数据库系统本身的运行有关，如内存管理、进程异常等。 - 网络错误：涉及数据库连接、网络通信等问题。 - SQL错误：与SQL语句的执行有关，包括语法错误、权限问题、数据...

Magicbox
Global site tag (gtag.js) - Google Analytics