oradebug 用法小结(一）

oradebug是oracle内部提供的工具，并且在文档中没有记录。11g中oracle的oradebug功能加强，我们可以通过 oradebug doc 命令来查看internal trace command。简单记录下，留作研究。

首先看下当前的环境和连接的用户

1. > select * from v$version;
   
2. 
   
3. BANNER
   
4. --------------------------------------------------------------------------------
   
5. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
   
6. PL/SQL Release 11.2.0.4.0 - Production
   
7. CORE 11.2.0.4.0 Production
   
8. TNS for Linux: Version 11.2.0.4.0 - Production
   
9. NLSRTL Version 11.2.0.4.0 - Production
   
10. 
    
11. > sho user
12. USER is "SYS"

oradebug doc查看

1. > oradebug doc
   
2. 
   
3. Internal Documentation
   
4. **********************
   
5. 
   
6.   EVENT Help on events (syntax, event list, ...)
   
7.   COMPONENT [<comp_name>] List all components or describe <comp_name>

oradebug doc event

1. > oradebug doc event
   
2. 
   
3. Event Help:
   
4. ***********
   
5. 
   
6.   Formal Event Syntax
   
7.   --------------------
   
8.     <event_spec> ::= ' []
   
9.                                    []
   
10.                                    []
    
11.                                    []
    
12.                                    [off]'
    
13. 
    
14.     <event_id> ::= <event_name | number>[<target_parameters>]
    
15. 
    
16.     <event_scope> ::= [<scope_name>: scope_parameters]
    
17. 
    
18.     <event_filter> ::= {<filter_name>: filter_parameters}
    
19. 
    
20.     <action> ::= <action_name>(action_parameters)
    
21. 
    
22.     <*_parameters> ::= <parameter_name> = <value>[, ]
    
23. 
    
24. 
    
25.   Some Examples
    
26.   -------------
    
27.     * Set event 10235 level 1:
    
28.       alter session set events '10235';
    
29. 
    
30.     * Set events SQL_TRACE (a.k.a. 10046) level 1:
    
31.       alter session set events 'sql_trace';
    
32. 
    
33.     * Turn off event SQL_TRACE:
    
34.       alter session set events 'sql_trace off';
    
35. 
    
36.     * Set events SQL_TRACE with parameter <plan_stat> set to 'never'
    
37.       and parameter <wait> set to 'true':
    
38.       alter session set events 'sql_trace wait=true, plan_stat=never';
    
39. 
    
40.     * Trace in-memory the SQL_MONITOR component (the target) and all its
    
41.       sub-components at level high. Get high resolution time for each
    
42.       trace:
    
43.       alter session set events 'trace[sql_mon.*] memory=high,
    
44.                                                  get_time=highres';
    
45. 
    
46.     * On-disk trace PX servers p000 and p005 for components 'sql_mon'
    
47.       and 'sql_optimizer' (including sub-components) at level highest:
    
48.       alter system set events 'trace[sql_mon | sql_optimizer.*]
    
49.                                     {process: pname = p000 | p005}';
    
50. 
    
51.     * Same as above but only when SQL id '7ujay4u33g337' is executed:
    
52.       alter system set events 'trace[sql_mon | sql_optimizer.*]
    
53.                                     [sql: 7ujay4u33g337]
    
54.                                     {process: pname = p000 | p005}';
    
55. 
    
56.     * Execute an action immediatly by using 'immediate' for the event
    
57.       name:
    
58.       alter session set events 'immediate eventdump(system)'
    
59. 
    
60.     * Create an incident labeled 'table_missing' when external error
    
61.       942 is signaled by process id 14534:
    
62.       alter session set events '942 {process: 14534}
    
63.                                     incident(table_missing)';
    
64. 
    
65. 
    
66.   Notes
    
67.   -----
    
68.     * Implicit parameter level is 1 by default
    
69.       e.g. '10053\' is same as '10053 level 1'
    
70. 
    
71.     * Event target (see [<target_parameters>] construct) is only
    
72.       supported by specific events like the TRACE[] event
    
73. 
    
74.     * <event_scope> and/or <event_filter> are constructs
    
75.       that can be used for any event
    
76. 
    
77.     * Same event can be set simultaneously for a different scope or
    
78.       target but not for different filters.
    
79. 
    
80.     * '|' character can be used to select multiple targets, scope or
    
81.       filters.
    
82. 
    
83.       E.g. 'sql_trace [sql: sql_id=g3yc1js3g2689 | sql_id=7ujay4u33g337]'
    
84. 
    
85.     * '=' sign is optional in <*_parameters>
    
86. 
    
87.       E.g. 'sql_trace level 12';
    
88. 
    
89.     * Like PL/SQL, no need to specify the parameter name for target,
    
90.       scope, filters and action. Resolution is done by position in
    
91.       that case:
    
92. 
    
93.       E.g. 'sql_trace [sql: g3yc1js3g2689 | 7ujay4u33g337]'
    
94. 
    
95. 
    
96.   Help sub-topics
    
97.   ---------------
    
98. 
    
99.     NAME [<event_name>] List all events or describe <event_name>
    
100.     SCOPE [<scope_name>] List all scopes or describe <scope_name>
     
101.     FILTER [<filter_name>] List all filters or describe <filter_name>
     
102.     ACTION [<action_name>] List all actions or describe <action_name>

oradebug doc event name

1. > oradebug doc event name
   
2. 
   
3. Events in library DIAG:
   
4. ------------------------------
   
5. trace[] Main event to control UTS tracing
   
6. disable_dde_action[] Event used by DDE to disable actions
   
7. ams_trace[] Event to dump ams performance trace records
   
8. ams_rowsrc_trace[] Event to dump ams row source tracing
   
9. sweep_verification Event to enable sweep file verification
   
10. enable_xml_inc_staging Event to enable xml incident staging format
    
11. 
    
12. Events in library RDBMS:
    
13. ------------------------------
    
14. alert_text event for textual alerts
    
15. trace_recursive event to force tracing recursive SQL statements
    
16. clientid_overwrite event to overwrite client_identifier when client_info is set
    
17. sql_monitor event to force monitoring SQL statements
    
18. eventsync_tac Event posted from events syncing tac
    
19. sql_trace event for sql trace
    
20. pmon_startup startup of pmon process
    
21. background_startup startup of background processes
    
22. db_open_begin start of db open operation
    
23. test_gvtf test GV$() Table Tunction
    
24. krbabrstat_fault event to control krbabrstat fault injection
    
25. 
    
26. Events in library GENERIC:
    
27. ------------------------------
    
28. kg_event[] Support old error number events (use err# for short)
    
29. 
    
30. Events in library CLIENT:
    
31. ------------------------------
    
32. oci_trace event for oci trace
    
33. 
    
34. Events in library LIBCELL:
    
35. ------------------------------
    
36. libcell_stat libcell statistics level specification
    
37. cellclnt_skgxp_trc_ops Controls to trace SKGXP operations
    
38. cellclnt_ossnet_trc Controls to trace IP affinity in ossnet
    
39. cellclnt_high_lat_ops Control to trace High-latency I/O operations
    
40. cellclnt_read_outlier_limit Control to trace read I/O outliers
    
41. cellclnt_write_outlier_limit Control to trace write I/O outliers
    
42. cellclnt_lgwrite_outlier_limit Control to trace log write I/O outliers
    
43. 
    
44. Events in library ADVCMP:
    
45. ------------------------------
    
46. arch_comp_level[] arch_comp_level[<ulevel, 1-7>]
    
47. ccmp_debug columnar compression debug event
    
48. ccmp_align columnar compression enable alignment
    
49. ccmp_countstar columnar compression enable count(*) optimization
    
50. ccmp_dumpunaligned columnar compression dump dbas of unaligned CUs

oradebug doc event name sql_trace

1. > oradebug doc event name sql_trace
   
2. 
   
3. sql_trace: event for sql trace
   
4. 
   
5. Usage
   
6. -------
   
7. sql_trace
   
8.    wait < false | true >,
   
9.    bind < false | true >,
   
10.    plan_stat < never | first_execution | all_executions | adaptive >,
    
11.    level <ub4>
    
12. 
    
13. 
    
14. > oradebug doc event name db_open_begin
    
15. 
    
16. db_open_begin: start of db open operation
    
17. 
    
18. Usage
    
19. -------
    
20. db_open_begin
    
21.    delay <ub4>

oradebug doc component

1. > oradebug doc component
   
2. 
   
3. 
   
4. Components in library DIAG:
   
5. --------------------------
   
6.   diag_uts Unified Tracing Service (dbgt, dbga)
   
7.     uts_vw UTS viewer toolkit (dbgtp, dbgtn)
   
8.   diag_adr Automatic Diagnostic Repository (dbgr)
   
9.     ams_comp ADR Meta-data Repository (dbgrm)
   
10.     ame_comp ADR Export/Import Services (dbgre)
    
11.     ami_comp ADR Incident Meta-data Services (dbgri)
    
12.     diag_ads Diagnostic Directory and File Services (dbgrf, sdbgrf, sdbgrfu, sdbgrfb)
    
13.   diag_hm Diagnostic Health Monitor
    
14.   diag_ips Diagnostic Incident Packaging System
    
15.   diag_dde Diagnostic Data Extractor (dbge)
    
16.   diag_fmwk Diagnostic Framework (dbgc)
    
17.     diag_ilcts Diagnostic Inter-Library Compile-time Service (dbgf)
    
18.     diag_attr Diagnostic Attributes Management
    
19.     diag_comp Diagnostic Components Management
    
20.   diag_testp Diagnostic component test parent (dbgt)
    
21.     diag_testc1 Diagnostic component test child 1
    
22.     diag_testc2 Diagnostic component test child 2
    
23.   KGSD Kernel Generic Service Debugging (kgsd)
    
24.   diag_events Diagnostic Events (dbgd)
    
25.   diag_adl Diagnostic ARB Alert Log (dbgrl, dbgrlr)
    
26.   diag_vwk Diagnostic viewer toolkit (dbgv)
    
27.     diag_vwk_parser Diagnostic viewer parser (dbgvp, dbgvl)
    
28.     diag_vwk_uts Diagnostic viewer for UTS traces and files (dbgvf)
    
29.     diag_vwk_ams Diagnostic viewer for AMS metadata (dbgvm)
    
30.     diag_vwk_ci Diagnostic viewer for command line (dbgvci)
    
31.   kghsc KGHSC Compact Stream (kghsc)
    
32.   dbgxtk DBGXTK xml toolkit (dbgxtk)
    
33. 
    
34. Components in library RDBMS:
    
35. --------------------------
    
36.   SQL_Compiler SQL Compiler
    
37.     SQL_Parser SQL Parser (qcs)
    
38.     SQL_Semantic SQL Semantic Analysis (kkm)
    
39.     SQL_Optimizer SQL Optimizer
    
40.       SQL_Transform SQL Transformation (kkq, vop, nso)
    
41.         SQL_MVRW SQL Materialized View Rewrite
    
42.         SQL_VMerge SQL View Merging (kkqvm)
    
43.         SQL_Virtual SQL Virtual Column (qksvc, kkfi)
    
44.       SQL_APA SQL Access Path Analysis (apa)
    
45.       SQL_Costing SQL Cost-based Analysis (kko, kke)
    
46.         SQL_Parallel_Optimization SQL Parallel Optimization (kkopq)
    
47.     SQL_Code_Generator SQL Code Generator (qka, qkn, qke, kkfd, qkx)
    
48.       SQL_Parallel_Compilation SQL Parallel Compilation (kkfd)
    
49.       SQL_Expression_Analysis SQL Expression Analysis (qke)
    
50.       SQL_Plan_Management SQL Plan Managment (kkopm)
    
51.     MPGE MPGE (qksctx)
    
52.     ADS ADS (kkoads)
    
53.   SQL_Execution SQL Execution (qer, qes, kx, qee)
    
54.     Parallel_Execution Parallel Execution (qerpx, qertq, kxfr, kxfx, kxfq, kxfp)
    
55.       PX_Messaging Parallel Execution Messaging (kxfp)
    
56.       PX_Group Parallel Execution Slave Group (kxfp)
    
57.       PX_Affinity Parallel Affinity (ksxa)
    
58.       PX_Buffer Parallel Execution Buffers (kxfpb)
    
59.       PX_Granule Parallel Execution Granules (kxfr)
    
60.       PX_Control Parallel Execution Control (kxfx)
    
61.       PX_Table_Queue Parallel Execution Table Queues (kxfq)
    
62.       PX_Scheduler Parallel Execution Scheduler (qerpx)
    
63.       PX_Queuing Parallel Execution Queuing (kxfxq)
    
64.     Bloom_Filter Bloom Filter (qerbl, qesbl)
    
65.       PX_Blackbox Parallel Execution Blackbox (kxf)
    
66.   PGA_Manage PGA Memory Management
    
67.     PGA_Compile PGA Memory Compilation
    
68.     PGA_IMM PGA Memory Instance Manage
    
69.     PGA_CMM PGA Memory Cursor Manage
    
70.     PGA_ADV PGA Memory Advisor
    
71.   rdbms_dde RDBMS Diagnostic Data Extractor (dbke)
    
72.   VOS VOS (ks)
    
73.     hang_analysis Hang Analysis (ksdhng)
    
74.     background_proc Background Processes (ksb, ksbt)
    
75.     system_param System Parameters (ksp, kspt)
    
76.     ksu Kernel Service User (ksu)
    
77.       ksutac KSU Timeout Actions
    
78.     ksv_trace Kernel Services Slave Management (ksv)
    
79.   sql_mon SQL Monitor (keswx)
    
80.     sql_mon_deamon SQL Monitor Deamon
    
81.     sql_mon_query SQL Monitor Query
    
82.   CACHE_RCV Cache Recovery (kcv, kct, kcra, kcrp, kcb)
    
83.   DIRPATH_LOAD Direct Path Load (kl, kdbl, kpodp)
    
84.     DIRPATH_LOAD_BIS Direct Path Kpodpbis Routine (kpodp)
    
85.   RAC Real Application Clusters
    
86.     GES Global Enqueue Service
    
87.     GCS Global Cache Service (kjb)
    
88.     GSIPC Global Enqueue/Cache Service IPC
    
89.       KSI Kernel Service Instance locking (ksi)
    
90.       RAC_ENQ Enqueue Operations
    
91.     RAC_RCFG Reconfiguration
    
92.     RAC_DRM Dynamic Remastering
    
93.     RAC_MRDOM Multiple Recovery Domains
    
94.     CGS Cluster Group Services (kjxg)
    
95.     CGSIMR Instance Membership Recovery (kjxgr)
    
96.       DD GES Deadlock Detection
    
97.       GCS_BSCN Broadcast SCN (kjb, kcrfw)
    
98.     RAC_WLM Work Load Management (wlm)
    
99.     RAC_MLMDS RAC Multiple LMS (kjm)
    
100.       GCS_READMOSTLY GCS Read-mostly (kjb)
     
101.       GCS_READER_BYPASS GCS Reader Bypass (kjb)
     
102.       GCS_DELTAPUSH GCS Delta Push (kjb)
     
103.       RAC_BCAST Enqueue Broadcast Operations
     
104.     RAC_LT RAC Latch Usage
     
105.   db_trace RDBMS server only tracing
     
106.   kst server trace layer tracing (kst)
     
107.   ddedmp RDBMS Diagnostic Data Extractor Dumper (dbked)
     
108.   cursor Shared Cursor (kxs, kks)
     
109.     Bind_Capture Bind Capture Tracing
     
110.   KSM Kernel Service Memory (ksm)
     
111.   KSE Kernel Service Error Manager (kse)
     
112.   explain SQL Explain Plan (xpl)
     
113.   rdbms_event RDBMS Events (dbkd)
     
114.   LOB_INODE Lob Inode (kdli)
     
115.   rdbms_adr RDBMS ADR (dbkr)
     
116.   ASM Automatic Storage Management (kf)
     
117.     KFK KFK (kfk)
     
118.       KFKIO KFK IO (kfkio)
     
119.       KFKSB KFK subs (kfksubs)
     
120.     KFN ASM Networking subsystem (kfn)
     
121.       KFNU ASM Umbillicus (kfnm, kfns, kfnb)
     
122.       KFNS ASM Server networking (kfns)
     
123.       KFNC ASM Client networking (kfnc)
     
124.     KFIS ASM Intelligent Storage interfaces (kfis)
     
125.     KFM ASM Node Monitor Interface Implementation (kfm)
     
126.       KFMD ASM Node Monitor Layer for Diskgroup Registration (kfmd)
     
127.       KFMS ASM Node Monitor Layers Support Function Interface (kfms)
     
128.     KFFB ASM Metadata Block (kffb)
     
129.     KFFD ASM Metadata Directory (kffd)
     
130.     KFZ ASM Zecurity subsystem (kfz)
     
131.     KFC ASM Cache (kfc)
     
132.     KFR ASM Recovery (kfr)
     
133.     KFE ASM attributes (kfe)
     
134.     KFDP ASM PST (kfdp)
     
135.     KFG ASM diskgroups (kfg)
     
136.     KFDS ASM staleness registry and resync (kfds)
     
137.     KFDX ASM Exadata interface (kfdx)
     
138.   DML DML Drivers (ins, del, upd)
     
139.   Health_Monitor Health Monitor
     
140.   DRA Data Repair Advisor
     
141.   DIRACC Direct access to fixed tables (kqfd)
     
142.   PART Partitioning (kkpo, qespc, qesma, kkpa, qergi)
     
143.     PART_IntPart Interval Partitioning
     
144.     PART_Dictionary Partitioning Dictionary (kkpod)
     
145.   LOB_KDLW Lob kdlw (kdlw)
     
146.   LOB_KDLX Lob xfm (kdlx)
     
147.   LOB_KDLXDUP Lob dedup (kdlxdup)
     
148.   LOB_KDLRCI Lob rci (kdlrci)
     
149.   LOB_KDLA SecureFile Archive (kdla)
     
150.   SQL_Manage SQL Manageability (kes)
     
151.     SQL_Manage_Infra Other SQL Manageability Infrastructure (kesai, kesqs, kesatm, kesutl, kessi, keswat, keswts, keswsq)
     
152.     SQL_Tune SQL Tuning Advisor (kest)
     
153.       SQL_Tune_Auto SQL Tuning Advisor (auto-tune) (kestsa)
     
154.       SQL_Tune_Index SQL Tuning Advisor (index-tune) (kestsi)
     
155.       SQL_Tune_Plan SQL Tuning Advisor (plan node analysis) (kestsp)
     
156.       SQL_Tune_Px SQL Tuning Advisor (parallel execution) (kestsa)
     
157.       SQL_Tune_Fr SQL Tuning Advisor (fix regression) (kestsa)
     
158.     SQL_Test_Exec SQL Test-Execute Service (kestse)
     
159.     SQL_Perf SQL Performance Analyzer (kesp, keswpi)
     
160.     SQL_Repair SQL Repair Advisor (kesds)
     
161.         Auto_Tune_Opt Auto Tuning Optimizer (kkoat)
     
162.     SQL_trace_parser SQL trace parser (kesstp)
     
163.   SQL_Analyze SQL Analyze (qksan)
     
164.   SQL_DS SQL Dynamic Sampling Services (qksds)
     
165.   SQL_DDL SQL DDL (atb, ctc, dtb)
     
166.   RAT_WCR Real Application Test: Workload Capture and Replay (kec)
     
167.   Spatial Spatial (md)
     
168.     Spatial_IND Spatial Indexing (mdr)
     
169.     Spatial_GR Spatial GeoRaster (mdgr)
     
170.   Text Text (dr)
     
171.   rdbms_gc RDBMS Diagnostic Generic Configuration (dbkgc)
     
172.   XS XS Fusion Security (kzx)
     
173.     XSSESSION XS Session (kzxs)
     
174.     XSPRINCIPAL XS Principal (kzxu)
     
175.     XSSECCLASS XS Security Class (kzxc)
     
176.     XSXDS XS Data Security (kzxd)
     
177.     XSVPD XS VPD
     
178.     XSXDB_DEFAULT XS XDB
     
179.     XS_MIDTIER XS Midtier (kpuzxs)
     
180.   AQ Streams Advanced Queuing (kwq, kkcn, kpon, kpoaq, kpce, kpcm, kpun, kpuaq)
     
181.     AQ_DEQ Streams Advanced Queuing Dequeue (kwqid, kwqdl)
     
182.     AQ_TM Streams Advanced Queuing Time Manager (kwqit, kwqmn)
     
183.   KSFM Kernel Service File Mapping (ksfm)
     
184.   KXD Exadata specific Kernel modules (kxd)
     
185.     KXDAM Exadata Disk Auto Manage (kxdam)
     
186.     KCFIS Exadata Predicate Push (kcfis)
     
187.     NSMTIO Trace Non Smart I/O (nsmtio)
     
188.     KXDRS Exadata Resilvering Layer (kxdrs)
     
189.     KXDOFL Exadata Offload (kxdofl)
     
190.     KXDMISC Exadata Misc (kxdmisc)
     
191.   DV Database Vault (kzv)
     
192.   ASO Advanced Security Option
     
193.     RADM Real-time Application-controlled Data Masking (kzradm)
     
194.   SVRMAN Server Manageability (ke)
     
195.       ASH Active Session History (kewa)
     
196.     AWR Automaitc Workload Repository (kew)
     
197.       METRICS AWR metrics (kewm)
     
198.     AUTOTASK Automated Maintenance Tasks (ket)
     
199.     MMON MMON/MMNL Infrastructure (keb)
     
200.   RAT Real Application Testing (kec)
     
201.     RAT_MASK Real Application Testing: Masking (kesm, kecprm)
     
202. 
     
203. Components in library GENERIC:
     
204. --------------------------
     
205.   Generic_VOS Generic VOS
     
206.     VOS_Heap_Manager VOS Heap Manager
     
207.     VOS_Latches VOS Latches
     
208.     VOS_GST VOS Generic Stack Trace (kgds)
     
209.   XML XML (qmxt, qmxq)
     
210.   Generic_XDB Generic XDB
     
211.     XDB_Repository XDB Repository (qme)
     
212.     XDB_Protocols XDB Protocols (qmh, qmf, qmn)
     
213.     XDB_Query XDB Query (qmxtra, qerxp)
     
214.     XDB_XMLIndex XDB XMLIndex (qmxtri, qmixq)
     
215.     XDB_Schema XDB Schema (qmxtri, qmixq)
     
216.     XDB_XOB XDB XOB (qmx)
     
217.     XDB_CSX XDB CSX (qmcxe, qmcxd)
     
218.     XDB_Default XDB Default
     
219.   LOB LOB (koll, kola)
     
220.     LOB_Refcount LOB Refcount (kolr)
     
221.     LOB_Default LOB Default (kole, kokl, koxs, kokla, koklm, koklv)
     
222.   KGH KGH Memory Allocator (kgh)
     
223.   KGF ASM Automatic Storage Management (kgf)
     
224.   LIBCACHE LIBCACHE (kgl, kql)
     
225.   OBJECTS OBJECTS
     
226.     OBJECTS_DDL OBJECTS DDL (kokt)
     
227.     OBJECTS_Types OBJECTS Types (kot, ko, ort)
     
228.     OBJECTS_Images OBJECTS Images (koke, kot, kad)
     
229.     OBJECTS_Anydata OBJECTS Anydata (kokla, kolo, kot, kad)
     
230.     OBJECTS_Streams OBJECTS Streams (koxs)
     
231.     OBJECTS_Dict OBJECTS Dictionary (kkdo, qcdo)
     
232.     OBJECTS_Semanal OBJECTS Semantic Analysis (koks, qcso, qcto)
     
233.     OBJECTS_Default OBJECTS Default
     
234. 
     
235. Components in library CLIENT:
     
236. --------------------------
     
237.   Client_KPU Client KPU
     
238.     KPU_Memory KPU Memory
     
239.     KPU_TTC KPU TTC
     
240.     KPU_Relational KPU Relational
     
241.     KPU_Objects KPU Objects
     
242.     KPU_LOBS KPU LOBS
     
243.   SQLLDR_Load SQLLDR Load (ul)
     
244.   DPAPI_Load DPAPI Load (kpudp)
     
245. 
     
246. Components in library LIBCELL:
     
247. --------------------------
     
248.   Client_Library Client Library
     
249.     Disk_Layer Disk Layer
     
250.     Network_Layer Network Layer
     
251.     IPC_Layer IPC Layer
     
252. 
     
253. Components in library ORANET:
     
254. --------------------------
     
255.   TNSLSNR OraNet Listener
     
256.     NET_NSGR Network Service Generic Registration
     
257.     NET_NSGI TNI Network Service Generic Listener User-defined class
     
258.   CMAN OraNet Connection Manager
     
259.   NET OraNet Services
     
260.     NET_NI Network Interface Layer
     
261.     NET_NS Network Session Layer
     
262.     NET_NT Network Transport Layer
     
263.     NET_NTM Network Transport Mailbox Layer
     
264.     NET_NTP Network Transport IPC Layer
     
265.     NET_NTT Network Transport TCP/IP Layer
     
266.     NET_NTUS Network Transport Unix Domain Sockets Layer
     
267.     NET_NL Network Library
     
268.     NET_NA Network Authentication
     
269.     NET_NZ Network Zecurity
     
270.     NET_NTZ Network SSL
     
271.     NET_NU Network Trace Route Utility
     
272.     NET_NN Network Names
     
273. 
     
274. Components in library ADVCMP:
     
275. --------------------------
     
276.   ADVCMP_MAIN Archive Compression (kdz)
     
277.     ADVCMP_COMP Archive Compression: Compression (kdzc, kdzh, kdza)
     
278.     ADVCMP_DECOMP Archive Compression: Decompression (kdzd, kdzs)
     
279. 
     
280. Components in library PLSQL:
     
281. --------------------------
     
282.   PLSQL_Apps PL/SQL Apps (di, pi, plitblm, scm, std, textio, wpiutil)
     
283.   PLSQL_Codegen PL/SQL Codegen
     
284.     PLSQL_COG_IDL_Gen PL/SQL Codegen IDL Gen (pdw)
     
285.     PLSQL_COG_Infrastructure PL/SQL Codegen Infrastructure (pdz)
     
286.     PLSQL_COG_Native PL/SQL Codegen Native (pdn)
     
287.     PLSQL_COG_Optimizer PL/SQL Codegen Optimizer (pdx)
     
288.     PLSQL_COG_MCode_Gen PL/SQL Codegen MCode Gen (pdy)
     
289.   PLSQL_Code_Execution PL/SQL Code Execution (pb, pd, pe, pf, plst, pri)
     
290.   PLSQL_External_Proc PL/SQL External Proc (pef, ociextp)
     
291.   PLSQL_IDL PL/SQL IDL (pdt, pt)
     
292.   PLSQL_ILMS PL/SQL ILMS (pgm)
     
293.   PLSQL_KNLDE PL/SQL KNLDE (pbbicd, pbp3g, pbs, pbt3g, peibp)
     
294.   PLSQL_KG_Interface PL/SQL KG Interface (bam, hep, hsh, lis, par, phdr, pk)
     
295.   PLSQL_Infrastructure PL/SQL Infrastructure (pci, pcm, ph, pl, pncutil, pp, ps, pu, tre)
     
296.   PLSQL_PSD PL/SQL PSD
     
297.     PLSQL_PSD_Generic PL/SQL PSD Generic (psd, pso, psu)
     
298.     PLSQL_PSD_Standalones PL/SQL PSD Standalones (p2c, pls, psx)
     
299.   PLSQL_Semantics PL/SQL Semantics (ph2, pha, phn)
     
300.   PLSQL_Syntax PL/SQL Syntax (ph1)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28697282/viewspace-1478774/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28697282/viewspace-1478774/