oradebug 用法小结(一）

  • apporacle

    2015-03-30 14:24:31
  • Oracle
  • 原创

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

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

  1. > select * from v$version;

  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

  11. > sho user
  12. USER is "SYS"
oradebug doc查看

  1. > oradebug doc

  3. Internal Documentation
  4. **********************

  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

  3. Event Help:
  4. ***********

  6.   Formal Event Syntax
  7.   --------------------
  8.     <event_spec> ::= ' []
  9.                                    []
  10.                                    []
  11.                                    []
  12.                                    [off]'

  14.     <event_id> ::= <event_name | number>[<target_parameters>]

  16.     <event_scope> ::= [<scope_name>: scope_parameters]

  18.     <event_filter> ::= {<filter_name>: filter_parameters}

  20.     <action> ::= <action_name>(action_parameters)

  22.     <*_parameters> ::= <parameter_name> = <value>[, ]


  25.   Some Examples
  26.   -------------
  27.     * Set event 10235 level 1:
  28.       alter session set events '10235';

  30.     * Set events SQL_TRACE (a.k.a. 10046) level 1:
  31.       alter session set events 'sql_trace';

  33.     * Turn off event SQL_TRACE:
  34.       alter session set events 'sql_trace off';

  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';

  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';

  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}';

  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}';

  56.     * Execute an action immediatly by using 'immediate' for the event
  57.       name:
  58.       alter session set events 'immediate eventdump(system)'

  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)';


  66.   Notes
  67.   -----
  68.     * Implicit parameter level is 1 by default
  69.       e.g. '10053\' is same as '10053 level 1'

  71.     * Event target (see [<target_parameters>] construct) is only
  72.       supported by specific events like the TRACE[] event

  74.     * <event_scope> and/or <event_filter> are constructs
  75.       that can be used for any event

  77.     * Same event can be set simultaneously for a different scope or
  78.       target but not for different filters.

  80.     * '|' character can be used to select multiple targets, scope or
  81.       filters.

  83.       E.g. 'sql_trace [sql: sql_id=g3yc1js3g2689 | sql_id=7ujay4u33g337]'

  85.     * '=' sign is optional in <*_parameters>

  87.       E.g. 'sql_trace level 12';

  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:

  93.       E.g. 'sql_trace [sql: g3yc1js3g2689 | 7ujay4u33g337]'


  96.   Help sub-topics
  97.   ---------------

  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

  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

  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

  26. Events in library GENERIC:
  27. ------------------------------
  28. kg_event[] Support old error number events (use err# for short)

  30. Events in library CLIENT:
  31. ------------------------------
  32. oci_trace event for oci trace

  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

  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

  3. sql_trace: event for sql trace

  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>


  14. > oradebug doc event name db_open_begin

  16. db_open_begin: start of db open operation

  18. Usage
  19. -------
  20. db_open_begin
  21.    delay <ub4>
oradebug doc component


  1. > oradebug doc component


  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)

  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)

  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

  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)

  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

  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

  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)

  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)


请使用浏览器的分享功能分享到微信等