oracle-Expdp/impdp指令

建立邏輯路徑

create or replace directory dumpdir as 'c:\';

grant read,write on directory dumpdir to scott;

倒入/出

expdp newdr/123456@hncrm directory=test dumpfile=test_score1.dmp logfile=tes

t.log parallel=2 schemas=newdr

錯誤

ORA-00054

resource busy and acquire with NOWAIT specified

         資源正忙，要求指定NOWAIT

ORA-00600

internal error code,arguments:[num],[?],[?],[?],[?]

産生原因：這種錯誤通常為ORACLE的内部錯誤，隻對OSS和ORACLE開發有用。ORA-600的錯誤經常伴随跟蹤檔案的狀态轉儲（系統狀态和程序狀态），系統狀态存儲将包括ORACLE RDBMS持有的目前對象的資訊，程序狀态轉儲則将顯示特殊程序持有的對象，當程序符合了某錯誤條件時，經常是由于一些資訊取自它持有的一個塊，如果我們知道這些錯誤程序持有的塊，就容易跟蹤問題的來源。

解決方法：一般來說出現這個錯誤我們本身是無法解決的，隻有從提高系統本身各方面來解決這個内部問題，如增加硬體裝置，調整系統性能，使用OPS（當然OPS從某種意義上說并不是一種好的解決方式）等。ORA-600錯誤的第一個變量用于标記代碼中錯誤的位置（代碼中的每個部分的第一變量都不一樣），從第二個到第五個變量顯示附加資訊，告訴OSS代碼在哪裡出現了錯誤。

一個報錯例子如下：

       ORA-00600: internal error code, arguments: [1237], [], [], [], [], [], [], []

       相應的英文如下：

       Cause:This is a catchall(包羅萬象的) internal error message for Oracle program exceptions.It indicates that a process has met a low-level,unexpected condition.Various causes of this message include:

       Time-outs（逾時）

       File corruption(檔案太老)

       Failed data checks in memory（記憶體檢索失敗）

       Hardware,memory,or I/O errors（硬體、記憶體或者磁盤錯誤）

       Incorrectly restored files（錯誤的重建檔案）

Ora-600 Base	Functionality	Description
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. vos Component notifier  100 Debug 300 Error 500 Lock 700 Memory 900 System Parameters  1100 System State object  1110 Generic Linked List management  1140 Enqueue 1180 Instance Locks  1200 User State object  1400 Async Msgs  1700 license Key  1800 Instance Registration  1850 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. server/rcv Cache Op 2100 Control File mgmt  2200 Misc (SCN etc.)  2400 Buffer Instance Hash Table  2600 Redo file component  2800 Db file  3000 Redo Application  3200 server/cache Buffer manager  3400 Archival & media recovery component  3600 recovery component 3700 Thread component  3800 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.  server/txn Transaction Undo  4100 4210 Transaction Parallel  4250 Transaction List  4300 space/spcmgmt Transaction Segment  4400 txn/lcltx Transaction Control  4450 distributed transaction control 4500 Transaction Block  4600 Transaction Table  4800 dict/rowcache Query Row Cache  4900 Transaction Monitor  5000 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.  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 index related 8150 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 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 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 kernel Index creation sqllang/integ constraint mechanism 13100 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 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.
	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. osds File access 14100 Concurrency management;  14200 Process management; 14300 Osds Exception-handler or signal handler management 14500 Memory allocation
	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		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		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		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		manages compilation of pl/sql packages and procedures
15500	dict/dictlkup	performs dictionary lookup to ensure semantics are correct
15550	sqlexec/execsvc	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
15700		component provides support for Parallel Query operation; specifically mechanism for starting up and shutting down query slaves
15800
15810		component provides support for Parallel Query operation; specifically functions for creating mechanisms through which Query co-ordinator can communicate with PQ slaves;
15820
15850	sqlexec/execsvc	component provides support for the execution of SQL statements
15860
	loader	sql Loader direct load operation;
16150		this layer is used for 'C' level call outs to direct loader operation;
16200		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		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		this layer contains functionality which allows tables to be loaded / truncated and their definitions to be modified. This is part of dictionary operation;
16450		this layer layer provides support for multi-instance access to the library cache; this functionality is applicable therefore to OPS environments;
16500		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		this layer performs management of data structures within the library cache;
16651		this layer performs management of dictionary related information within library Cache;
16701		this layer provides library Cache support to support database creation and forms part of the bootstrap process;
17000		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		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		this component deals with loading remote library objects into the local library cache with information from the remote database.
17250		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		manages certain types of memory allocation structure.  This functionality is an extension of the Heap manager.
17500		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		additional library Cache supporting functions
17990	plsql	plsql 'standard' package related issues
18000		transaction and savepoint management operations
19000		cost based optimizer related operations
20000		bitmap index and index related errors.
20400	ram/partnmap	operations on partition related objects
20500		server recovery related operation
21000	repl/defrdrpc,  repl/snapshot, repl/trigger	replication related features
23000	oltp/qs	AQ related errors.
24000		operations associated with managing stored outlines
25000		tablespace management operations

Internal Errors Categorised by mnemonic

The following table details mnemonics error stems which are possible. If you have encountered : ora-600[kkjsrj:1] for example,  you should look down the Error Mnemonic column (errors in alphabetical order) until you find the matching stem. In this case, kkj indicates that something unexpected has occurred in job queue operation.

Error Mnemonic(s)
ain ainp		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		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		manages drop index or validate index operation
dtb		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		handles the insert statement operation
jox		functionality associated with the Java compiler and with the Java runtime environment within the Server
k2c k2d		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		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		handles distributed recovery operation
kad	cartserv/picklercs	handles OCIAnyData implementation
kau		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		compatibility related checks associated with the compatible parameter
kcl		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		various buffer cache operation such as quiesce operation , managing fast start IO target, parallel recovery operation , etc.
kd		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		support for direct load operation, cluster space management and deleting rows
kdg		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		support of the creation of indexes on tables an IOTs and index look up
kdl kdlt		lob and temporary lob management
kdo		operations on data such as inserting a row piece or deleting a row piece
kdrp		underlying support for operations provided by the dbms_repair package
kds kdt kdu		operations on data such as retrieving a row and updating existing row data
kdv kdx		functionality for dumping index and managing index blocks
kfh kfp kft		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		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		generic library cache operation
kgm kgmt	ilms	support for inter language method services - or calling one language from another
kgrq kgsk kgski kgsn kgss		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		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		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		DLM request message management
kjzc kjzd kjzf kjzg kjzm	ccl/diag	support for diagnosibility amongst OPS related services
kkb		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		support for constraints, dictionary lookup and dictionary support for objects
kke		query engine cost engine; provides support functions that provide cost estimates for queries under a number of different circumstances
kkfd		support for performing parallel query operation
kkfi		optimizer support for matching of expressions against functional ndexes
kkfr kkfs		support for rowid range handling as well as for building parallel query query operations
kkj		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		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		provides various semantic checking functions
kkn		support for the analyze command
kko kkocri		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		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		support for managing shared cursors/ shared sql
kkt		support for creating, altering and dropping trigger definitions as well as handling the trigger operation
kkxa		underlying support for dbms_defer_query package operations
kkxb		library cache interface for external tables
kkxl	dict/plsicds	underlying support for the dbms_lob package
kkxm		support for inter language method services
kkxs		underlying support for the dbms_sys_sql package
kkxt		support for replication internal trigger operation
kkxwtp		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		support for direct path sql loader operation
kmc kmcp kmd kmm kmr		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		replication related enqueue and dequeue of transction data as well as other queue related operations
kncog		support for loading replicaiton object group information into library cache
kni
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		operations assocaied with propagating transactions to a remote node and coordination of this activity.
knst	repl/stats	replication statistics collection
knt kntg kntx
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		object heap manager provides memory allocation services for objects
koi	objmgmt/objmgr	support for object types
koka		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		support for pinning , unpinning and freeing objects
kokd	objsupp/datadrv	driver on the server side for managing objects
koke koke2 koki		support for managing objects
kokl		lob access
kokl2		lob DML and programmatic interface support
kokl3		object temporary LOB support
kokle kokm		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		query optimisation for objects , semantic checking and semantic rewrite operations
kokt kokt2 kokt3		object compilation type manager
koku kokv		support for unparse object operators and object view support
kol kolb kole kolf kolo		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		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		support for programmatic operations
kpor		support for streaming protocol used by replication
kposc		support for scrollable cursors
kpotc		oracle side support functions for setting up trusted external procedure callbacks
kpotx kpov		support for managing local and distributed transaction coordination.
kpp2 kpp3		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		server-side notifiers and callbacks for debug operations.
kql kqld kqlp		SQL Library Cache manager - manages the sharing of sql statements in the shared pool
kqr		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		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		support for various kernel associated capabilities
ksx		support for query execution associated with temporary tables
ksxa ksxp ksxr		support for various kernel associated capabilities in relation to OPS or RAC operation
kta		support for DML locks and temporary tables associated with table access
ktb ktbt ktc		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		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		flashback support
ktfb ktfd ktft ktm		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		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		support for checking and verifying space usage
ktu ktuc ktur ktusm		internal management of undo and rollback segments
kwqa kwqi kwqic kwqid kwqie kwqit kwqj kwqm kwqn kwqo kwqp kwqs kwqu kwqx		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		constraint processing
kxdr		DML driver entrypoint
kxfp kxfpb kxfq kxfr kxfx		parallel query support
kxhf kxib		khhf- support for hash join file and memory management; kxib - index buffering operations
kxs		support for executing shared cursors
kxti kxto kxtr	dbproc/trigger	support for trigger operation
kxtt		support for temporary table operations
kxwph		support for managing attributes of the segment of a table / cluster / table-partition
kza		support for auditing operations
kzar		support for application auditing
kzck	security/crypto	encryption support
kzd		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		support for fine grained auditing
kzia	security/logon	identification and authentication operations
kzp kzra kzrt kzs kzu kzup		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		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		support for  C langauge interfaces to user-defined types (UDTs)
orp		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		support for NCOMP processing
plsm pmuc pmuo pmux	objmgmt/pol	support for pl/sql handling of collections
prifold priold		support to allow rpc forwarding to an older release
prm	sqllang/param	parameter handling associated with sql layer
prsa prsc prssz		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		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		qcdl - query compile semantic analysis; qcdo - query compile dictionary support for objects
qci		support for SQL language parser and semantic analyser
qcop qcpi qcpi3 qcpi4 qcpi5		support for query compilation parse phase
qcs qcs2 qcs3 qcsji qcso		support for semantic analysis by SQL compiler
qct qcto	sqllang/typeconv	qct - query compile type check operations; qcto -  query compile type check operators
qcu		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		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		run time support for sql execution
qkacon qkadrv qkajoi qkatab qke qkk qkn qkna qkne	sqlexec/rwsalloc	SQL query dynamic structure allocation routines
qks3t		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		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		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		XMLType support functions
qsme	summgmt/dict	summary management expression processing
qsmka qsmkz		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		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		support for domain index ddl operations
qxidm		support for extensible index dml operations
qxidp		support for domain index ddl partition operations
qxim		extensible indexing support for objects
qxitex qxopc qxope		qxitex - support for create / drop indextype; qxope - execution time support for operator  callbacks; qxope - execution time support for operator DDL
qxopq qxuag qxxm		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		manages rename statement operation
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		row source implementation/retrieval according to the defining query
sdbima	sqlexec/sort	manages and performs sort operation
selexe		handles the operation of select statement execution
skgm		platform specific memory management rountines interfacing with O.S. allocation functions
smbima sor
sqn		support for parsing references to sequences
srdima srsima stsima
tbsdrv		operations for executing create / alter / drop tablespace and related supporting functions
ttcclr ttcdrv ttcdty ttcrxh ttcx2y		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		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		view optimisation related functionality
xct		support for the management of transactions and savepoint operations
xpl	sqlexec/expplan	support for the explain plan command
xty		type checking functions