oradebug doc 备查-凯发app官方网站

凯发app官方网站-凯发k8官网下载客户端中心 | | 凯发app官方网站-凯发k8官网下载客户端中心
  • 博客访问: 3502988
  • 博文数量: 718
  • 博客积分: 1860
  • 博客等级: 上尉
  • 技术积分: 7790
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文(718)

文章存档

2024年(4)

2023年(74)

2022年(134)

2021年(238)

2020年(115)

2019年(11)

2018年(9)

2017年(9)

2016年(17)

2015年(7)

2014年(4)

2013年(1)

2012年(11)

2011年(27)

2010年(35)

2009年(11)

2008年(11)

最近访客
相关博文
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·

分类: oracle

2021-11-15 22:56:45

oracle 19.10
sqlplus / as sysdba


  1. sql> oradebug doc component rac_mlmds

  2.   rac_mlmds rac multiple lms (kjm)

  1. sql> oradebug doc component krb

  2.   krb kernel backup restore (krb)
  3.     krb_thread krbbpc thread switches ((null))
  4.     krb_io krb i/o ((null))
  5.     krb_incr krb incremental restore ((null))
  6.     krb_perf krb performance tracing ((null))
  7.     krb_bpoutput detailed backup piece output ((null))
  8.     krb_bpval detailed block list during restore validate ((null))
  9.     krb_flwres details on restore flow ((null))
  10.     krb_flwcpy details on krbydd flow ((null))
  11.     krb_flwbck details on backup flow ((null))
  12.     krb_flwusage rman feature usage ((null))
  13.     krb_optim unused space compression ((null))

  1. sql> oradebug dumplist;
  2. adjust_scn
  3. alrt_test
  4. archive_error
  5. ashdump
  6. ashdumpseconds
  7. asmdisk_err_off
  8. asmdisk_err_on
  9. asmdisk_read_err_on
  10. atsk_test
  11. awr_debug_flush_table_off
  12. awr_debug_flush_table_on
  13. awr_flush_table_off
  14. awr_flush_table_on
  15. awr_test
  16. bc_sanity_check
  17. bginfo
  18. bg_messages
  19. blk0_fmtchg
  20. buffer
  21. buffers
  22. callstack
  23. cbdb_entries
  24. cgs
  25. check_roreuse_sanity
  26. contextarea
  27. controlf
  28. crossic
  29. crs
  30. css
  31. cursordump
  32. cursortrace
  33. cursor_stats
  34. data_err_off
  35. data_err_on
  36. data_read_err_on
  37. dbscheduler
  38. dead_cleanup_state
  39. drop_segments
  40. dumpglobaldata
  41. dump_adv_snapshots
  42. dump_all_comp_granules
  43. dump_all_comp_granule_addrs
  44. dump_all_objstats
  45. dump_all_reqs
  46. dump_pinned_buffer_history
  47. dump_sga_metadata
  48. dump_temp
  49. dump_transfer_ops
  50. enqueues
  51. errorstack
  52. event_tsm_test
  53. exception_dump
  54. failover
  55. fbhdr
  56. fbinc
  57. fbtail
  58. file_hdrs
  59. flashback_gen
  60. flush_buffer
  61. flush_cache
  62. flush_java_pool
  63. flush_object
  64. full_dumps
  65. gc_elements
  66. ges_state
  67. gipc
  68. global_area
  69. global_buffer_dump
  70. gwm_test
  71. gwm_trace
  72. hanganalyze
  73. hanganalyze_global
  74. hanganalyze_proc
  75. hangdiag_header
  76. heapdump
  77. heapdump_addr
  78. hm_fdg_vers
  79. hm_fw_trace
  80. hngdet_mem_usage_dump
  81. imdb_pinned_buffer_history
  82. instantiationstate
  83. ioerremul
  84. ioerremulrng
  85. ir_fw_trace
  86. javainfo
  87. kbrs_trace
  88. kcbi_dump_freelist
  89. kcbo_obj_check_dump
  90. kcbs_adv_int_dump
  91. kcb_working_set_dump
  92. kdfsdmp
  93. kdlidmp
  94. kra_options
  95. krbmror_limit
  96. krbmrsr_limit
  97. krb_bset_days
  98. krb_corrupt_interval
  99. krb_corrupt_offset
  100. krb_corrupt_repeat
  101. krb_corrupt_size
  102. krb_corrupt_spbad_interval
  103. krb_corrupt_spbad_signal
  104. krb_corrupt_spbitmap_interval
  105. krb_corrupt_spbitmap_repeat
  106. krb_corrupt_spheader_interval
  107. krb_corrupt_spheader_repeat
  108. krb_fail_input_fileno
  109. krb_options
  110. krb_options2
  111. krb_overwrite_action
  112. krb_piece_fail
  113. krb_set_time_switch
  114. krb_simulate_node_affinity
  115. krb_unused_option
  116. krdrsbf
  117. ksdtradv_test
  118. ksfqp_limit
  119. kskdumptrace
  120. kstdumpallprocs
  121. kstdumpallprocs_cluster
  122. kstdumpcurproc
  123. ktpr_debug
  124. kupplatchtest
  125. kxfpblatchtest
  126. kxfpclearstats
  127. kxfpdumptrace
  128. kxfrhashmap
  129. kxfxcursorstate
  130. kxfxslavestate
  131. latches
  132. ldap_kernel_dump
  133. ldap_user_dump
  134. library_cache
  135. library_cache_object
  136. locks
  137. logerror
  138. loghist
  139. longf_create
  140. lreg_state
  141. mga
  142. mman_alloc_memory
  143. mman_create_def_request
  144. mman_create_imm_request
  145. mman_imm_request
  146. mmon_test
  147. modified_parameters
  148. next_scn_wrap
  149. object_cache
  150. ocr
  151. olap_dump
  152. open_files
  153. pdbstats
  154. pga_detail_cancel
  155. pga_detail_dump
  156. pga_detail_get
  157. pga_summary
  158. pin_blocks
  159. pin_random_blocks
  160. poke_address
  161. poke_length
  162. poke_value
  163. poke_value0
  164. pool_simulator
  165. processstate
  166. pxdowngrade_analyze
  167. racdump
  168. realfreedump
  169. record_callstack
  170. recovery
  171. redohdr
  172. redologs
  173. refresh_os_stats
  174. row_cache
  175. rulesetdump
  176. rulesetdump_addr
  177. savepoints
  178. scn_auto_rollover_ts_override
  179. selftestasm
  180. session_stats_freelist
  181. set_afn
  182. set_istempfile
  183. set_nblocks
  184. set_tsn_p1
  185. sga_summary
  186. shared_server_state
  187. short_stack
  188. simulate_eov
  189. slock_dump
  190. sqlnet_server_trace
  191. state_object_deletion_time
  192. state_object_metadata
  193. systemstate
  194. systemstate_global
  195. test_db_robustness
  196. test_get_caller
  197. test_spacebg
  198. test_stack_dump
  199. trace_buffer_off
  200. trace_buffer_on
  201. treedump
  202. tr_corrupt_one_side
  203. tr_crash_after_write
  204. tr_read_one_side
  205. tr_reset_normal
  206. tr_set_all_blocks
  207. tr_set_block
  208. tr_set_side
  209. update_block0_format
  210. workareatab_dump
  211. xs_session_state


  1. sql> oradebug doc event name
  2. events in library diag:
    ------------------------------
    trace[]              main event to control uts tracing
    disable_dde_action[] event used by dde to disable actions
    ams_trace[]          event to dump ams performance trace records
    ams_rowsrc_trace[]   event to dump ams row source tracing
    sweep_verification   event to enable sweep file verification
    enable_xml_inc_staging event to enable xml incident staging format
    dbg[]                event to hook dbgtdbg logging statements


    events in library rdbms:
    ------------------------------
    wait_event[]         event to control wait event post-wakeup actions
    alert_text           event for textual alerts
    trace_recursive      event to force tracing recursive sql statements
    clientid_overwrite   event to overwrite client_identifier when client_info is set
    sql_monitor          event to force monitoring sql statements
    sql_monitor_test     event to test sql monitoring
    eventsync_tac        event posted from events syncing tac
    sql_trace            event for sql trace
    pmon_startup         startup of pmon process
    background_startup   startup of background processes
    db_open_begin        start of db open operation
    test_gvtf            test gv$() table tunction
    fault                event used to inject fault in rdbms kernel
    gcr_systest          gcr_systest
    em_express           em express debug event
    emx_control          event to control em express
    emx_test_control     event to control em express testing
    awrdiag[]            awr diagnostic event
    msgq_trace           event to control msgq tracing
    ipclw_trace          event to control ipclw tracing
    kbc_fault            event to control container fault injection
    asm_corruption_trace event to control asm corruption tracing
    kxdrs_sim            debug event to simulate certain conditions in kxdrs layer


    kcfio_debug          debug event to debug kcfio based on event level


    krbabrstat_fault     event to control krbabrstat fault injection
    periodic_dump[]      event for periodically dumping
    kxdrs_log_for_wbfc   debug event to log skipped extents for wbfc resilvering


    clean_plsql_error_stack event to clear ora-06512s from the error stack
    plsql_coverage_flag  event to set plsql coverage flag


    events in library generic:
    ------------------------------
    kg_event[]           support old error number events (use err# for short)


    events in library client:
    ------------------------------
    oci_trace            event for oci trace


    events in library libcell:
    ------------------------------
    libcell_stat         libcell statistics level specification
    cellclnt_skgxp_trc_ops controls to trace skgxp operations
    cellclnt_ossnet_trc  controls to trace ip affinity in ossnet
    cellclnt_high_lat_ops control to trace high-latency i/o operations
    diskmon_sim_ops[]    diskmon simulation events
    cellclnt_read_outlier_limit control to trace read i/o outliers
    cellclnt_write_outlier_limit control to trace write i/o outliers
    cellclnt_lgwrite_outlier_limit control to trace log write i/o outliers
    cellclnt_sparse_mode mode of how to handle sparse buffers
    cellclnt_submission_recon simulation period for forcing submission reconnect


    events in library fplib:
    ------------------------------
    fgq_control          fine grain quarantine control


    events in library advcmp:
    ------------------------------
    arch_comp_level[]    arch_comp_level[]
    ccmp_debug           columnar compression debug event
    inmemory_nobasic     disable kdzcf_imc_basic implementation
    inmemory_nohybrid    disable kdzcf_imc_hybrid implementation
    ccmp_align           columnar compression enable alignment
    ccmp_countstar       columnar compression enable count(*) optimization
    ccmp_dumpunaligned   columnar compression dump dbas of unaligned cus
    ccmp_rbtree          columnar compression switch back to rb tree
    inmemory_force_ccl   inmemory force column compression levels
    columnar_cache_config flash cash configuration event
    inmemory_imcu[]      inmemory_imcu[]
    inmemory_nobitpacked_gd disable bit-packed gd codes in cu. use ub4 instead
    inmemory_dicthash    enable storage of dictionary hash values in imcu
    inmemory_cache_joinopt inmemory cache join optimizations
    inmemory_scan_joinopt join optimizations to use during scan
    inmemory_compute_cachehash compute a hash vector when there is no cached hash
    ifc_dump_block       block rdba to dump in ifc
    ifc_disable_scan_rid disable cc2 type scan when rowid is required
    ifc_sim_version_mismatch simulate ifc version mismatch error
    ifc_disable_col_crypto disable column level encryption/decryption
    ifc_ulevel[]         ifc_ulevel
    inmemory_prefixdict  enable prefix compression on dictionary encoded imcu
    inmemory_disable_dsb usage of stored dsb dictionary during scans
    disable_skip_pdo     disable skipping kafpdo columns during projection
    inmemory_noime       disable usage of ime in queries


    events in library plsql:
    ------------------------------
    plsql_event[]        support pl/sql error number events


    events in library vplib:
    ------------------------------
    key_vector_debug     key vector debug parameters
    key_vector_diag      key vector diagnostics parameters
    key_vector_test      key vector testing parameters
    vector_groupby_test  vector group by testing parameters
    vector_groupby_debug vector group by debugging parameters
    binary_decimal_debug binary decimal debugging parameters
    key_vector_test2     key vector testing parameters 2




  1. sql> oradebug doc component


  2. components in library diag:
  3. --------------------------
  4.   diag_uts unified tracing service (dbgt, dbga)
  5.     uts_vw uts viewer toolkit (dbgtp, dbgtn)
  6.   diag_adr automatic diagnostic repository (dbgr)
  7.     ams_comp adr meta-data repository (dbgrm)
  8.     ame_comp adr export/import services (dbgre)
  9.     ami_comp adr incident meta-data services (dbgri)
  10.     diag_ads diagnostic directory and file services (dbgrf, sdbgrf, sdbgrfu, sdbgrfb)
  11.   diag_hm diagnostic health monitor ((null))
  12.   diag_ips diagnostic incident packaging system ((null))
  13.   diag_dde diagnostic data extractor (dbge)
  14.   diag_fmwk diagnostic framework (dbgc)
  15.     diag_ilcts diagnostic inter-library compile-time service (dbgf)
  16.     diag_attr diagnostic attributes management ((null))
  17.     diag_comp diagnostic components management ((null))
  18.   diag_testp diagnostic component test parent (dbgt)
  19.     diag_testc1 diagnostic component test child 1 ((null))
  20.     diag_testc2 diagnostic component test child 2 ((null))
  21.   kgsd kernel generic service debugging (kgsd)
  22.   diag_events diagnostic events (dbgd)
  23.   diag_adl diagnostic arb alert log (dbgrl, dbgrlr)
  24.   diag_vwk diagnostic viewer toolkit (dbgv)
  25.     diag_vwk_parser diagnostic viewer parser (dbgvp, dbgvl)
  26.     diag_vwk_uts diagnostic viewer for uts traces and files (dbgvf)
  27.     diag_vwk_ams diagnostic viewer for ams metadata (dbgvm)
  28.     diag_vwk_ci diagnostic viewer for command line (dbgvci)
  29.   kghsc kghsc compact stream (kghsc)
  30.   dbgxtk dbgxtk xml toolkit (dbgxtk)
  31.   kdizoltp adv high index (kdizoltp)

  32. components in library rdbms:
  33. --------------------------
  34.   sql_compiler sql compiler ((null))
  35.     sql_parser sql parser (qcs)
  36.     sql_semantic sql semantic analysis (kkm)
  37.     sql_optimizer sql optimizer ((null))
  38.       sql_transform sql transformation (kkq, vop, nso)
  39.         sql_mvrw sql materialized view rewrite ((null))
  40.         sql_vmerge sql view merging (kkqvm)
  41.         sql_virtual sql virtual column (qksvc, kkfi)
  42.       sql_apa sql access path analysis (apa)
  43.       sql_costing sql cost-based analysis (kko, kke)
  44.         sql_parallel_optimization sql parallel optimization (kkopq)
  45.         vector_processing vector processing (kkevp)
  46.       sql_plan_management sql plan managment (kkopm)
  47.       sql_plan_directive sql plan directive (qosd)
  48.       sql_optimizer_stats sql optimizer statistics (qos)
  49.         sql_optimizer_stats_advisor sql optimizer statistics advisor (qosadv)
  50.       sql_quarantine sql quarantine (qsfc)
  51.     sql_code_generator sql code generator (qka, qkn, qke, kkfd, qkx)
  52.       sql_parallel_compilation sql parallel compilation (kkfd)
  53.       sql_expression_analysis sql expression analysis (qke)
  54.       sql_rowsets_setup sql rowsets setup (qknr)
  55.     mpge mpge (qksctx)
  56.     ads ads (kkoads)
  57.     icdt_compile in memory cdt compilation (qks3t)
  58.     shard_sql shard sql (kkoshd)
  59.     aqp aqp (kkodp, qesdp, qersc)
  60.     ptf_comp polymorphic table functions compilation (qksptf)
  61.   sql_execution sql execution (qer, qes, kx, qee)
  62.     parallel_execution parallel execution (qerpx, qertq, kxfr, kxfx, kxfq, kxfp)
  63.       px_messaging parallel execution messaging (kxfp)
  64.       px_group parallel execution slave group (kxfp)
  65.       px_affinity parallel affinity (ksxa)
  66.       px_buffer parallel execution buffers (kxfpb)
  67.       px_granule parallel execution granules (kxfr)
  68.       px_control parallel execution control (kxfx)
  69.       px_table_queue parallel execution table queues (kxfq)
  70.       px_scheduler parallel execution scheduler (qerpx)
  71.       px_queuing parallel execution queuing (kxfxq)
  72.       px_blackbox parallel execution blackbox (kxf)
  73.       px_ptl parallel execution ptl (kxft)
  74.       px_expr_eval parallel execution expression evaluation ((null))
  75.       px_selector parallel execution px selector (qerpsel)
  76.       px_overhead parallel execution overhead (qerpx, kxfr, kxfx, kxfp)
  77.     bloom_filter bloom filter (qerbl, qesbl)
  78.     time_limit query execution time limit (opiexe, qerst)
  79.     icdt_exec in memory cdt execution (qes3t, kxtt)
  80.     execute_temp_table execute temp table (kxtt)
  81.     sql_trace sql trace (kxst, xpl)
  82.     ptf_exec polymorphic table functions execution (qerptf)
  83.     result_cache result cache (qesrc, qerrc)
  84.   pga_manage pga memory management ((null))
  85.     pga_compile pga memory compilation ((null))
  86.     pga_imm pga memory instance manage ((null))
  87.     pga_cmm pga memory cursor manage ((null))
  88.     pga_adv pga memory advisor ((null))
  89.   rdbms_dde rdbms diagnostic data extractor (dbke)
  90.   vos vos (ks)
  91.     hang_analysis hang analysis (ksdhng)
  92.     background_proc background processes (ksb, ksbt)
  93.     system_param system parameters (ksp, kspt)
  94.     ksu kernel service user (ksu)
  95.       ksutac ksu timeout actions ((null))
  96.     ksv_trace kernel services slave management (ksv)
  97.     file file i/o (ksfd, ksfdaf)
  98.     ksq kernel service enqueues (ksq)
  99.     ksolt_trace kernel services lightweight threads (ksolt)
  100.     ksim kernel service instance management (ksim)
  101.       ksim_grpop kernel service instance management group operation ((null))
  102.     ksipc vos ipc (ksipc)
  103.       ksmsq message queue services (ksmsq)
  104.         ksmsq_mql message queueing layer ((null))
  105.       ksrma ksrma (ksrma)
  106.       ksrmf ksrmf (ksrmf)
  107.       ksipc_am active messaging ((null))
  108.       ksipc_grp ksipc group services ((null))
  109.       ksipc_sn ksipc shared nothing ((null))
  110.       ksipc_kv ksipc key value ((null))
  111.       ksipc_topo ksipc topology services ((null))
  112.       ksipc_pr ksipc path record ((null))
  113.       ksipc_ipclw ipc lightweight ((null))
  114.       ksipc_ipcor ipc core functionality ((null))
  115.       ksipc_shreg ksipc shared registration ((null))
  116.       ksipc_aspc ksipc address space map ((null))
  117.       ksipcenv ksipc memory allocations on different sockets (ksipcenv)
  118.       ksxp cross instance ipc (ksxp)
  119.     lreg listener registration (kml)
  120.     ksupd ksu planned draining (ksupd)
  121.     state_object state objects (kss)
  122.     sess_signature session signature (ksusgn)
  123.   sql_mon sql monitor (keswx)
  124.     sql_mon_deamon sql monitor deamon ((null))
  125.     sql_mon_query sql monitor query ((null))
  126.   cache_rcv cache recovery (kcv, kct, kcra, kcrp, kcb)
  127.     dlf delayed log force ((null))
  128.     mbr multi-block read ((null))
  129.   dirpath_load direct path load (kl, kdbl, kpodp)
  130.     dirpath_load_bis direct path kpodpbis routine (kpodp)
  131.   rac real application clusters ((null))
  132.     ges global enqueue service ((null))
  133.       ksi kernel service instance locking (ksi)
  134.       rac_enq enqueue operations ((null))
  135.       dd ges deadlock detection ((null))
  136.       rac_bcast enqueue broadcast operations ((null))
  137.       rac_frz dlm-client freeze/unfreeze (kjfz)
  138.       kjoe dlm omni enqueue service (kjoe)
  139.     gcs global cache service (kjb)
  140.       gcs_bscn broadcast scn (kjb, kcrfw)
  141.       gcs_readmostly gcs read-mostly (kjb)
  142.       gcs_reader_bypass gcs reader bypass (kjb)
  143.       gcs_deltapush gcs delta push (kjb)
  144.       gcs_pcl2 persistent cluster flash cache (kjbfp)
  145.     gsipc global enqueue/cache service ipc ((null))
  146.     rac_rcfg reconfiguration ((null))
  147.     rac_drm dynamic remastering ((null))
  148.     rac_mrdom multiple recovery domains ((null))
  149.       mrdom_esm multiple/pdb domains - enter/exit server mode (kjs, kjfz)
  150.     cgs cluster group services (kjxg)
  151.     cgsimr instance membership recovery (kjxgr)
  152.     rac_wlm work load management (wlm)
  153.     rac_mlmds rac multiple lms (kjm)
  154.     rac_ka kernel accelerator (kjk)
  155.     rac_lt rac latch usage ((null))
  156.     rac_slock slock optimisation ((null))
  157.     kjsc rac global stats (kjsc)
  158.     lmhb heartbeat monitoring (kjfm)
  159.   db_trace rdbms server only tracing ((null))
  160.   kst server trace layer tracing (kst)
  161.   ddedmp rdbms diagnostic data extractor dumper (dbked)
  162.   cursor shared cursor (kxs, kks)
  163.     bind_capture bind capture tracing ((null))
  164.     kksh cursor hash table tracing (kksh)
  165.   ksm kernel service memory (ksm)
  166.   kse kernel service error manager (kse)
  167.   explain sql explain plan (xpl)
  168.   rdbms_event rdbms events (dbkd)
  169.   lob_inode lob inode (kdli)
  170.   rdbms_adr rdbms adr (dbkr)
  171.   asm automatic storage management (kf)
  172.     kfk kfk (kfk)
  173.       kfkio kfk io (kfkio)
  174.         kfkio_count kfk io count ((null))
  175.         kfkio_cancel kfk io cancel ((null))
  176.         kfkio_hard kfk io hard errors ((null))
  177.         kfkio_split kfk io split ((null))
  178.         kfkio_misc kfk io miscellaneous ((null))
  179.       kfksb kfk subs (kfksubs)
  180.         kfksb_lib kfk subs libraries ((null))
  181.         kfksb_dm kfk subs disk management ((null))
  182.       kfks kfk sage (kfks)
  183.     kfn asm networking subsystem (kfn)
  184.       kfnu asm umbillicus (kfnm, kfns, kfnb)
  185.       kfns asm server networking (kfns)
  186.       kfnc asm client networking (kfnc)
  187.       kfnor kfn orion (kfnor)
  188.     kfis asm intelligent storage interfaces (kfis)
  189.     kfm asm node monitor interface implementation (kfm)
  190.       kfmd asm node monitor layer for diskgroup registration (kfmd)
  191.       kfms asm node monitor layers support function interface (kfms)
  192.     kffb asm metadata block (kffb)
  193.     kffd asm metadata directory (kffd)
  194.     kfz asm zecurity subsystem (kfz)
  195.     kfc asm cache (kfc)
  196.     kfr asm recovery (kfr)
  197.     kfe asm attributes (kfe)
  198.     kfdp asm pst (kfdp)
  199.     kfg asm diskgroups (kfg)
  200.       kfgb asm diskgroups background (kfgb)
  201.     kfds asm staleness registry and resync (kfds)
  202.     kfia asm remote (kfia)
  203.       kfias asm ioserver (kfias)
  204.       kfiac asm ioserver client (kfiac)
  205.     kffscrub asm scrubbing (kffscrub)
  206.     kfio asm translation i/o layer (kfio)
  207.     kfioer asm translation i/o layer (kfioer)
  208.     kfv asm volume subsystem (kfv)
  209.       kfvsu asm volume umbilicus (kfvsu)
  210.       kfvsd asm volume background (kfvsd)
  211.       kfvioc asm volume cell storage (kfvioc)
  212.     kfdx asm exadata interface (kfdx)
  213.     kfzp asm password file layer (kfzp)
  214.     kfa asm alias operations (kfa)
  215.     kff kff (kff)
  216.     kfd asm disk (kfd)
  217.       kfdva asm virtual atb (kfdva)
  218.     kftha asm transparent high availability (kftha)
  219.     kffg asm file group (kffg)
  220.     kffs asm split mirror operations (kffs)
  221.     kfios kfio simple (kfios)
  222.   dml dml drivers (ins, del, upd)
  223.   health_monitor health monitor ((null))
  224.   dra data repair advisor ((null))
  225.   diracc direct access to fixed tables (kqfd)
  226.   part partitioning (kkpo, qespc, qesma, kkpa, qergi)
  227.     part_intpart interval partitioning ((null))
  228.     part_dictionary partitioning dictionary (kkpod)
  229.   lob_kdlw lob kdlw (kdlw)
  230.   lob_kdlx lob xfm (kdlx)
  231.   lob_kdlxdup lob dedup (kdlxdup)
  232.   lob_kdlrci lob rci (kdlrci)
  233.   lob_kdla securefile archive (kdla)
  234.   sql_manage sql manageability (kes)
  235.     sql_manage_infra other sql manageability infrastructure (kesai, kesqs, kesatm, kesutl, kessi, keswat, keswts, keswsq)
  236.     sql_tune sql tuning advisor (kest)
  237.       sql_tune_auto sql tuning advisor (auto-tune) (kestsa)
  238.         auto_tune_opt auto tuning optimizer (kkoat)
  239.       sql_tune_index sql tuning advisor (index-tune) (kestsi)
  240.       sql_tune_plan sql tuning advisor (plan node analysis) (kestsp)
  241.       sql_tune_px sql tuning advisor (parallel execution) (kestsa)
  242.       sql_tune_fr sql tuning advisor (fix regression) (kestsa)
  243.       sql_tune_stats sql tuning advisor (statistics advisor) (kestss)
  244.       sql_tune_exa sql tuning advisor (exadata) (kestsaexa)
  245.     sql_test_exec sql test-execute service (kestse)
  246.     sql_perf sql performance analyzer (kesp, keswpi)
  247.     sql_repair sql repair advisor (kesds)
  248.     sql_trace_parser sql trace parser (kesstp)
  249.   sql_analyze sql analyze (qksan)
  250.   sql_ds sql dynamic sampling services (qksds)
  251.   sql_ddl sql ddl (atb, ctc, dtb)
  252.     kkp kkp manager (kkp)
  253.   rat_wcr real application test: workload capture and replay (kec)
  254.   spatial spatial (md)
  255.     spatial_ind spatial indexing (mdr)
  256.     spatial_gr spatial georaster (mdgr)
  257.   text text (dr)
  258.   rdbms_gc rdbms diagnostic generic configuration (dbkgc)
  259.   xs xs fusion security (kzx)
  260.     xssession xs session (kzxs)
  261.     xsprincipal xs principal (kzxu)
  262.     xssecclass xs security class (kzxc, kzxsp)
  263.     xsxds xs data security (kzxd)
  264.     xsvpd xs vpd ((null))
  265.     xsxdb_default xs xdb ((null))
  266.     xs_midtier xs midtier (kpuzxs)
  267.     xsnstemplate xs namespace template (kzxnt)
  268.     xsacl xs acl (kzxa)
  269.     xsadm xs administrative operation (kzxm, kzxi)
  270.   aq streams advanced queuing (kwq, kkcn, kpon, kpoaq, kpce, kpcm, kpun, kpuaq, kws)
  271.     aq_deq streams advanced queuing dequeue (kwqid, kwqdl)
  272.     aq_back streams advanced queueing background (kwsbg, kwsbsm)
  273.       aq_tm streams advanced queuing time manager (kwqit, kwqmn)
  274.       aq_cp streams advanced queuing cross process (kwscp, kwsipc)
  275.       aq_lb streams advanced queuing load balancer (kwslb, kwslbbg)
  276.       aq_ntfn streams advanced queuing notification (kpond, kkcne)
  277.         aq_ntfnp12c streams advanced queuing pre-12c notification (kwqic)
  278.       aq_tmsq streams advanced queuing time manager for sharded queue (kwsbtm, kwsbjc, kwsbit)
  279.     aq_mc streams advanced queuing message cache (kwsmc, kwssh, kwsmb, kwsmsg, kwssb, kwschnk, kwscb, kwsdqwm, kwssbsh)
  280.     aq_pt streams advanced queuing partitioning (kwspt)
  281.     aq_sub streams advanced queuing subscription (kwssi, kwssa, kwsnsm, kwsnsme)
  282.     aq_opt streams advanced queuing opt (kwssub)
  283.     aq_dly streams advanced queuing delay (kwsdly)
  284.   ksfm kernel service file mapping (ksfm)
  285.   kxd exadata specific kernel modules (kxd)
  286.     kxdam exadata disk auto manage (kxdam)
  287.     kcfis exadata predicate push (kcfis)
  288.     nsmtio trace non smart i/o (nsmtio)
  289.     kxdbio exadata block level intelligent operations (kxdbio)
  290.     kxdrs exadata resilvering layer (kxdrs)
  291.     kxdofl exadata offload (kxdofl)
  292.     kxdmisc exadata misc (kxdmisc)
  293.     kxdcm exadata metrics fixed table callbacks (kxdcm)
  294.     kxdbc exadata backup compression for backup appliance (kxdbc)
  295.   dv database vault (kzv)
  296.   aso advanced security option ((null))
  297.     radm real-time application-controlled data masking (kzradm)
  298.   svrman server manageability (ke)
  299.     awr automatic workload repository (kew)
  300.       ash active session history (kewa)
  301.       metrics awr metrics (kewm)
  302.       repository awr repository (kewr)
  303.         flush awr snapshot flush (kewrf)
  304.         purge awr snapshot purge (kewrps)
  305.       awrutl awr utilities (kewu)
  306.     autotask automated maintenance tasks (ket)
  307.     mmon mmon/mmnl infrastructure (keb)
  308.     svralrt server generated alert infrastructure (kel)
  309.     iut iut infrastructure (keiut)
  310.   ols oracle label security (zll)
  311.   auditng database audit next generation (aud, kza, kzft, aus, aop, ttp)
  312.     configuration ang configuration (aud, kza, kzft, aus, aop, ttp)
  313.     queuewrite ang queue write (aud, kza, kzft, aus, aop, ttp)
  314.     filewrite ang file write (aud, kza, kzft, aus, aop, ttp)
  315.     recordcompose ang record compose (aud, kza, kzft, aus, aop, ttp)
  316.     dbconsolidation ang database consolidation (aud, kza, kzft, aus, aop, ttp)
  317.     sys_auditing ang sys auditing (aud, kza, kzft, aus, aop, ttp)
  318.   kjci kjci cross instance call (kjci)
  319.   kjz kjz - diag (kjz)
  320.     kjzc kjzc - diag communication layer (kjzc)
  321.     kjzd kjzd - diag main layer (kjzd)
  322.     kjzf kjzf - diag flow control layer (kjzf)
  323.     kjzg kjzg - diag group services layer (kjzg)
  324.     kjzh kjzh - diag api layer (kjzh)
  325.     kjzm kjzm - diag membership layer (kjzm)
  326.   sec security (kz)
  327.     cbac code-based access control (kzc)
  328.     vpd virtual private database (kzr)
  329.     gdsi generic directory services integration (kzlg)
  330.   dbop dbop monitoring (keomn)
  331.     dbop_gen dbop generic service (keomg)
  332.       dbop_deamon dbop monitoring deamon (keomg)
  333.     dbop_comp dbop composite type (keomm)
  334.   em_express em express (kex)
  335.   orarep orarep (ker)
  336.   data data layer (kd, ka)
  337.     kds kernel data scan (kds)
  338.       kdsrid fetch by rowid (kdsgrp, kdsgnp)
  339.       kdsfts full table scan (kdsttgr, kdstgr)
  340.       kdsclu cluster table scan (kdsics, kdscgr)
  341.     kdwf kernel data worker framework (kdwf)
  342.     imoltp_kv inmemory oltp keyvalue (kdkv)
  343.     memopt_fi memoptimize for write (kdfi)
  344.   rat real application testing (kec)
  345.     rat_mask real application testing: masking (kesm, kecprm)
  346.   ba backup appliance (kbrs)
  347.   kbc ba containers (kbc)
  348.   connection_broker connection broker (kmp)
  349.   kra kernel recovery area function (kra)
  350.   kra_sql kra sql tracing ((null))
  351.   krb kernel backup restore (krb)
  352.     krb_thread krbbpc thread switches ((null))
  353.     krb_io krb i/o ((null))
  354.     krb_incr krb incremental restore ((null))
  355.     krb_perf krb performance tracing ((null))
  356.     krb_bpoutput detailed backup piece output ((null))
  357.     krb_bpval detailed block list during restore validate ((null))
  358.     krb_flwres details on restore flow ((null))
  359.     krb_flwcpy details on krbydd flow ((null))
  360.     krb_flwbck details on backup flow ((null))
  361.     krb_flwusage rman feature usage ((null))
  362.     krb_optim unused space compression ((null))
  363.   krbabr auto block media recovery (krbabr)
  364.   krc recovery block change tracking (krc)
  365.   krc_changes recovery block change tracking changes ((null))
  366.   im in-memory ((null))
  367.     im_transaction im transaction layer ((null))
  368.       im_txn_pj im txn private journal (ktmpj)
  369.       im_txn_sj im txn shared journal (ktmsj)
  370.       im_txn_js im txn journal scan (ktmjs)
  371.       im_txn_conc im txn concurrency (ktmc)
  372.       im_txn_blk im txn block (ktmb)
  373.       im_txn_read im txn read (ktmr)
  374.       im_txn_adg im txn adg (ktma)
  375.     im_space im space layer ((null))
  376.     im_data im data layer (kdm)
  377.       im_populate im populating (kdml)
  378.       im_background im background (kdmr)
  379.       im_scan im scans ((null))
  380.       im_journal im journal ((null))
  381.       im_dump im dump ((null))
  382.       im_fs im faststart ((null))
  383.       im_optimizer im optimizer (kdmo)
  384.       im_gd im gd (kdmgd)
  385.       im_ado im ado (kdmado)
  386.       im_ime im ime (kdmime)
  387.       im_dictionary im dictionary and cache (kdmd)
  388.       im_verification im verification (kdmv)
  389.   xdb_wallet xdb wallet (kzs)
  390.   progint programmatic interfaces (kp)
  391.     oci oci (oci, kpk, kpn)
  392.     opi opi (opi)
  393.     rpi rpi (rpi, kpr)
  394.     npi npi (npi, nco, kpfs)
  395.     two_task two task (osn, ksn)
  396.     progint_plsql programmatic interfaces to/from pl/sql (kkx, psd, pckl, plswa)
  397.     two_phase two-phase commit (k2)
  398.     conn_pool connection pool (kppl)
  399.     tsm transparent session migration (kpm, kps)
  400.     progint_misc progint miscellaneous (kpo, kpbf, kpin)
  401.   kdfs dbfs c-api (kdfs)
  402.   olap olap analytic workspace (xs)
  403.     olap_paging olap paging manager (xspg, xsdb)
  404.   streams replication (knl)
  405.     streams_capture streams capture (knlc)
  406.     streams_propagation streams propagation ((null))
  407.       streams_propagation_sender streams propagation sender (knlcsv)
  408.       streams_propagation_receiver streams propagation receiver (knanr)
  409.     streams_apply streams apply (kna)
  410.       streams_apply_coordinator streams apply coordinator (knac)
  411.       streams_apply_reader streams apply reader (knalf)
  412.       streams_apply_server streams apply server (knas)
  413.   space space (ktd, kte, kts, ktf, ktt)
  414.     search_cache search cache (ktspsc)
  415.   context oracle text (dr, kci)
  416.     context_index oracle text index (drs, drg, drn, drl, dre)
  417.     context_query oracle text query (drex, drp, dry, drw)
  418.   rdbms_uts rdbms unified tracing service (uts) (dbkt)
  419.   mira_rcv mira recovery (krd, krp, krr)
  420.   reg_cache registration caches (kssmc)
  421.   ofs kernel services oracle file system ((null))
  422.     ofs_ksfs ofs file system (ksfs)
  423.     ofs_ksfsd ofs file system dispatcher (ksfsd)
  424.     ofs_ksfsm ofs file system metadata (ksfsm)
  425.     ofs_ksfsc1 ofs file system callback (ksfsc1)
  426.     ofs_skofs ofs file system implementation (skofs)
  427.   sql_compare_plans sql compare plans (keplan)

  428. components in library generic:
  429. --------------------------
  430.   generic_vos generic vos ((null))
  431.     vos_heap_manager vos heap manager ((null))
  432.     vos_latches vos latches ((null))
  433.     vos_gst vos generic stack trace (kgds)
  434.   xml xml (qmxt, qmxq)
  435.   generic_xdb generic xdb ((null))
  436.     xdb_repository xdb repository (qme)
  437.     xdb_protocols xdb protocols (qmh, qmf, qmn)
  438.     xdb_query xdb query (qmxtra, qerxp)
  439.     xdb_xmlindex xdb xmlindex (qmxtri, qmixq)
  440.     xdb_schema xdb schema (qmxtri, qmixq)
  441.     xdb_xob xdb xob (qmx)
  442.     xdb_csx xdb csx (qmcx)
  443.       xdb_csx_encoding xdb csx encoding (qmcxe, qmcxm)
  444.       xdb_csx_decoding xdb csx decoding (qmcxd)
  445.       xdb_csx_selfcon xdb csx selfcon (qmcxe)
  446.       xdb_csx_print xdb csx print (qmxrs, qmxp, kolace, kolars)
  447.       xdb_csx_tokenmgr xdb csx tokenmgr (qmtm)
  448.     xdb_default xdb default ((null))
  449.     xdb_memory xdb memory (qmu)
  450.   lob lob (koll, kola)
  451.     lob_refcount lob refcount (kolr)
  452.     lob_default lob default (koll, kole, kokl, koxs)
  453.     lob_dblink lob dblink (koll, kokl, kpolobr, kkxlr)
  454.     lob_temporary lob temporary (kola, koklt)
  455.     lob_api lob api (kpolob, kkxlr, kokle, koklc)
  456.   kgh kgh memory allocator (kgh)
  457.   kgf asm automatic storage management (kgf)
  458.   libcache libcache (kgl, kql)
  459.     lco_status_ddl change of lib-cache-obj status during ddl ((null))
  460.   objects objects ((null))
  461.     objects_ddl objects ddl (kokt)
  462.     objects_types objects types (kot, ko, ort)
  463.     objects_images objects images (koke, kot, kad)
  464.     objects_anydata objects anydata (kokla, kolo, kot, kad)
  465.     objects_streams objects streams (koxs)
  466.     objects_dict objects dictionary (kkdo, qcdo)
  467.     objects_semanal objects semantic analysis (koks, qcso, qcto)
  468.     objects_default objects default ((null))
  469.     objects_tables objects tables (kkbo)
  470.   kgfpm patch repository (kgfpm)
  471.   kgfdvf voting file interface (kgfdvf)
  472.   shared_objects shared object manager (pes)
  473.     so_loader native code loader (pesld)
  474.   direct_nfs direct nfs client (kgnfs, kgodm, skgnfs)
  475.   kgsc session cache for cursors ((null))
  476.     kgsc_kqd session cache for kqd cursors ((null))
  477.     kgsc_bun session cache for kqd bundled cursors ((null))
  478.     kgsc_kks session cache for kks cursors ((null))
  479.     kgsc_pls session cache for plsql cursors ((null))
  480.     kgsc_cons session cache for constraint cursors ((null))
  481.     kgsc_trig session cache for trigger cursors ((null))
  482.     kgsc_jox session cache for jox shortname translation cursors ((null))
  483.   kdi index layer (kdi)
  484.     kdiadhi index layer compress advanced high ((null))
  485.     kdiadlo index layer compress advanced low ((null))
  486.     kdil index load (kdil)
  487.       kdiladhi index load compress advanced high ((null))
  488.       kdiladlo index load compress advanced low ((null))
  489.     kdis index split (kdis)
  490.       kdisadhi index split compress advanced high ((null))
  491.       kdisadlo index split compress advanced low ((null))
  492.     kdxt index reorg (kdxt)
  493.       kdxtadhi index adlo compress advanced high ((null))
  494.       kdxtadlo index reorg compress advanced low ((null))
  495.     kdim index coalesce (kdim)
  496.       kdimadhi index coalesece compress advanced high ((null))
  497.       kdimadlo index coalesece compress advanced low ((null))
  498.     kdif index scan (kdif)
  499.       kdifadhi index scan compress advanced high ((null))
  500.       kdifadlo index scan compress advanced low ((null))
  501.     kdizadhi advanced high index codec (kdizoltp)
  502.     kdizadlo advanced low index codec ((null))
  503.     kdidml index dml ((null))
  504.       kdidmladhi index dml compress advanced high ((null))
  505.       kdidmladlo index dml compress advanced low ((null))
  506.     kdigdr index ghost data removal ((null))
  507.       kdigdrbr index ghost data removal branch ((null))
  508.       kdigdrlf index ghost data removal leaf ((null))

  509. components in library client:
  510. --------------------------
  511.   client_kpu client kpu ((null))
  512.     kpu_memory kpu memory ((null))
  513.     kpu_ttc kpu ttc ((null))
  514.     kpu_relational kpu relational ((null))
  515.     kpu_objects kpu objects ((null))
  516.     kpu_lobs kpu lobs ((null))
  517.   progint_appcont prog interfaces application continuity ((null))
  518.     progint_appcont_rdbms prog interfaces application continuity rdbms-side ((null))
  519.   sqlldr_load sqlldr load (ul)
  520.   dpapi_load dpapi load (kpudp)
  521.   dbfs_client_profiler dbfs_client profiler ((null))

  522. components in library libcell:
  523. --------------------------
  524.   client_library client library ((null))
  525.     disk_layer disk layer ((null))
  526.     network_layer network layer ((null))
  527.     connect_layer connect layer ((null))
  528.     ipc_layer ipc layer ((null))

  529. components in library oranet:
  530. --------------------------
  531.   tnslsnr oranet listener ((null))
  532.     net_nsgr network service generic registration ((null))
  533.     net_nsgi tni network service generic listener user-defined class ((null))
  534.   cman oranet connection manager ((null))
  535.   net oranet services ((null))
  536.     net_ni network interface layer ((null))
  537.     net_ns network session layer ((null))
  538.     net_nt network transport layer ((null))
  539.     net_ntm network transport mailbox layer ((null))
  540.     net_ntp network transport ipc layer ((null))
  541.     net_ntt network transport tcp/ip layer ((null))
  542.     net_ntus network transport unix domain sockets layer ((null))
  543.     net_nl network library ((null))
  544.     net_na network authentication ((null))
  545.     net_nz network zecurity ((null))
  546.     net_ntz network ssl ((null))
  547.     net_nu network trace route utility ((null))
  548.     net_nn network names ((null))

  549. components in library advcmp:
  550. --------------------------
  551.   advcmp_main archive compression (kdz)
  552.     advcmp_comp archive compression: compression (kdzc, kdzh, kdza)
  553.     advcmp_decomp archive compression: decompression (kdzd, kdzs)
  554.       advcmp_decomp_hpk archive compression: hpk (kdzk)
  555.       advcmp_decomp_pcode archive compression: pcode (kdp)

  556. components in library plsql:
  557. --------------------------
  558.   plsql_apps pl/sql apps (di, pi, plitblm, scm, std, textio, wpiutil)
  559.     plsql_utl_file pl/sql utl file (pifi)
  560.   plsql_codegen pl/sql codegen ((null))
  561.     plsql_cog_idl_gen pl/sql codegen idl gen (pdw)
  562.     plsql_cog_infrastructure pl/sql codegen infrastructure (pdz)
  563.     plsql_cog_native pl/sql codegen native (pdn)
  564.     plsql_cog_optimizer pl/sql codegen optimizer (pdx)
  565.     plsql_cog_mcode_gen pl/sql codegen mcode gen (pdy)
  566.   plsql_code_execution pl/sql code execution (pb, pd, pe, pf, plst, pri)
  567.     plsql_stack_frames pl/sql runtime stack frame (pfrstk)
  568.   plsql_external_proc pl/sql external proc (pef, ociextp)
  569.   plsql_idl pl/sql idl (pdt, pt)
  570.   plsql_ilms pl/sql ilms (pgm)
  571.   plsql_knlde pl/sql knlde (pbbicd, pbp3g, pbs, pbt3g, peibp)
  572.   plsql_kg_interface pl/sql kg interface (bam, hep, hsh, lis, par, phdr, pk)
  573.   plsql_infrastructure pl/sql infrastructure (pci, pcm, ph, pl, pncutil, pp, ps, pu, tre)
  574.   plsql_psd pl/sql psd ((null))
  575.     plsql_psd_generic pl/sql psd generic (psd, pso, psu)
  576.     plsql_psd_standalones pl/sql psd standalones (p2c, pls, psx)
  577.   plsql_semantics pl/sql semantics (ph2, pha, phn)
  578.   plsql_syntax pl/sql syntax (ph1)

  579. components in library xdk:
  580. --------------------------
  581.   xdk_parser xdk parser ((null))
  582.     xdk_fsm_parser xdk fsm parser (lpxfsm)
  583.   xdk_schema_validator xdk schema validator ((null))
  584.   xdk_xslt_engine xdk xslt engine ((null))

  585. components in library vplib:
  586. --------------------------
  587.   vector_translate vector translate (qkaxl, qerxl, qesxl, evaxl)
  588.   vector_aggregate vector aggregate (qergv, qesgv, evavgby)
  589.   vector_px vector px (qesxlp)
  590.   binary_decimal binary decimal (qesdsb, ldsb)
参考:
  1. tech.e2sn.com/oracle/troubleshooting
  2. juliandyke.com/diagnostics/tools/oradebug/oradebug.php 朱利安。戴克  


阅读(944) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
")); function link(t){ var href= $(t).attr('href'); href ="?url=" encodeuricomponent(location.href); $(t).attr('href',href); //setcookie("returnouturl", location.href, 60, "/"); }
网站地图