oracle 19.10
sqlplus / as sysdba
-
-
sql> oradebug doc component rac_mlmds
-
-
rac_mlmds rac multiple lms (kjm)
-
sql> oradebug doc component krb
-
-
krb kernel backup restore (krb)
-
krb_thread krbbpc thread switches ((null))
-
krb_io krb i/o ((null))
-
krb_incr krb incremental restore ((null))
-
krb_perf krb performance tracing ((null))
-
krb_bpoutput detailed backup piece output ((null))
-
krb_bpval detailed block list during restore validate ((null))
-
krb_flwres details on restore flow ((null))
-
krb_flwcpy details on krbydd flow ((null))
-
krb_flwbck details on backup flow ((null))
-
krb_flwusage rman feature usage ((null))
-
krb_optim unused space compression ((null))
-
-
sql> oradebug doc event name
-
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
-
-
sql> oradebug doc component
-
-
-
components in library diag:
-
--------------------------
-
diag_uts unified tracing service (dbgt, dbga)
-
uts_vw uts viewer toolkit (dbgtp, dbgtn)
-
diag_adr automatic diagnostic repository (dbgr)
-
ams_comp adr meta-data repository (dbgrm)
-
ame_comp adr export/import services (dbgre)
-
ami_comp adr incident meta-data services (dbgri)
-
diag_ads diagnostic directory and file services (dbgrf, sdbgrf, sdbgrfu, sdbgrfb)
-
diag_hm diagnostic health monitor ((null))
-
diag_ips diagnostic incident packaging system ((null))
-
diag_dde diagnostic data extractor (dbge)
-
diag_fmwk diagnostic framework (dbgc)
-
diag_ilcts diagnostic inter-library compile-time service (dbgf)
-
diag_attr diagnostic attributes management ((null))
-
diag_comp diagnostic components management ((null))
-
diag_testp diagnostic component test parent (dbgt)
-
diag_testc1 diagnostic component test child 1 ((null))
-
diag_testc2 diagnostic component test child 2 ((null))
-
kgsd kernel generic service debugging (kgsd)
-
diag_events diagnostic events (dbgd)
-
diag_adl diagnostic arb alert log (dbgrl, dbgrlr)
-
diag_vwk diagnostic viewer toolkit (dbgv)
-
diag_vwk_parser diagnostic viewer parser (dbgvp, dbgvl)
-
diag_vwk_uts diagnostic viewer for uts traces and files (dbgvf)
-
diag_vwk_ams diagnostic viewer for ams metadata (dbgvm)
-
diag_vwk_ci diagnostic viewer for command line (dbgvci)
-
kghsc kghsc compact stream (kghsc)
-
dbgxtk dbgxtk xml toolkit (dbgxtk)
-
kdizoltp adv high index (kdizoltp)
-
-
components in library rdbms:
-
--------------------------
-
sql_compiler sql compiler ((null))
-
sql_parser sql parser (qcs)
-
sql_semantic sql semantic analysis (kkm)
-
sql_optimizer sql optimizer ((null))
-
sql_transform sql transformation (kkq, vop, nso)
-
sql_mvrw sql materialized view rewrite ((null))
-
sql_vmerge sql view merging (kkqvm)
-
sql_virtual sql virtual column (qksvc, kkfi)
-
sql_apa sql access path analysis (apa)
-
sql_costing sql cost-based analysis (kko, kke)
-
sql_parallel_optimization sql parallel optimization (kkopq)
-
vector_processing vector processing (kkevp)
-
sql_plan_management sql plan managment (kkopm)
-
sql_plan_directive sql plan directive (qosd)
-
sql_optimizer_stats sql optimizer statistics (qos)
-
sql_optimizer_stats_advisor sql optimizer statistics advisor (qosadv)
-
sql_quarantine sql quarantine (qsfc)
-
sql_code_generator sql code generator (qka, qkn, qke, kkfd, qkx)
-
sql_parallel_compilation sql parallel compilation (kkfd)
-
sql_expression_analysis sql expression analysis (qke)
-
sql_rowsets_setup sql rowsets setup (qknr)
-
mpge mpge (qksctx)
-
ads ads (kkoads)
-
icdt_compile in memory cdt compilation (qks3t)
-
shard_sql shard sql (kkoshd)
-
aqp aqp (kkodp, qesdp, qersc)
-
ptf_comp polymorphic table functions compilation (qksptf)
-
sql_execution sql execution (qer, qes, kx, qee)
-
parallel_execution parallel execution (qerpx, qertq, kxfr, kxfx, kxfq, kxfp)
-
px_messaging parallel execution messaging (kxfp)
-
px_group parallel execution slave group (kxfp)
-
px_affinity parallel affinity (ksxa)
-
px_buffer parallel execution buffers (kxfpb)
-
px_granule parallel execution granules (kxfr)
-
px_control parallel execution control (kxfx)
-
px_table_queue parallel execution table queues (kxfq)
-
px_scheduler parallel execution scheduler (qerpx)
-
px_queuing parallel execution queuing (kxfxq)
-
px_blackbox parallel execution blackbox (kxf)
-
px_ptl parallel execution ptl (kxft)
-
px_expr_eval parallel execution expression evaluation ((null))
-
px_selector parallel execution px selector (qerpsel)
-
px_overhead parallel execution overhead (qerpx, kxfr, kxfx, kxfp)
-
bloom_filter bloom filter (qerbl, qesbl)
-
time_limit query execution time limit (opiexe, qerst)
-
icdt_exec in memory cdt execution (qes3t, kxtt)
-
execute_temp_table execute temp table (kxtt)
-
sql_trace sql trace (kxst, xpl)
-
ptf_exec polymorphic table functions execution (qerptf)
-
result_cache result cache (qesrc, qerrc)
-
pga_manage pga memory management ((null))
-
pga_compile pga memory compilation ((null))
-
pga_imm pga memory instance manage ((null))
-
pga_cmm pga memory cursor manage ((null))
-
pga_adv pga memory advisor ((null))
-
rdbms_dde rdbms diagnostic data extractor (dbke)
-
vos vos (ks)
-
hang_analysis hang analysis (ksdhng)
-
background_proc background processes (ksb, ksbt)
-
system_param system parameters (ksp, kspt)
-
ksu kernel service user (ksu)
-
ksutac ksu timeout actions ((null))
-
ksv_trace kernel services slave management (ksv)
-
file file i/o (ksfd, ksfdaf)
-
ksq kernel service enqueues (ksq)
-
ksolt_trace kernel services lightweight threads (ksolt)
-
ksim kernel service instance management (ksim)
-
ksim_grpop kernel service instance management group operation ((null))
-
ksipc vos ipc (ksipc)
-
ksmsq message queue services (ksmsq)
-
ksmsq_mql message queueing layer ((null))
-
ksrma ksrma (ksrma)
-
ksrmf ksrmf (ksrmf)
-
ksipc_am active messaging ((null))
-
ksipc_grp ksipc group services ((null))
-
ksipc_sn ksipc shared nothing ((null))
-
ksipc_kv ksipc key value ((null))
-
ksipc_topo ksipc topology services ((null))
-
ksipc_pr ksipc path record ((null))
-
ksipc_ipclw ipc lightweight ((null))
-
ksipc_ipcor ipc core functionality ((null))
-
ksipc_shreg ksipc shared registration ((null))
-
ksipc_aspc ksipc address space map ((null))
-
ksipcenv ksipc memory allocations on different sockets (ksipcenv)
-
ksxp cross instance ipc (ksxp)
-
lreg listener registration (kml)
-
ksupd ksu planned draining (ksupd)
-
state_object state objects (kss)
-
sess_signature session signature (ksusgn)
-
sql_mon sql monitor (keswx)
-
sql_mon_deamon sql monitor deamon ((null))
-
sql_mon_query sql monitor query ((null))
-
cache_rcv cache recovery (kcv, kct, kcra, kcrp, kcb)
-
dlf delayed log force ((null))
-
mbr multi-block read ((null))
-
dirpath_load direct path load (kl, kdbl, kpodp)
-
dirpath_load_bis direct path kpodpbis routine (kpodp)
-
rac real application clusters ((null))
-
ges global enqueue service ((null))
-
ksi kernel service instance locking (ksi)
-
rac_enq enqueue operations ((null))
-
dd ges deadlock detection ((null))
-
rac_bcast enqueue broadcast operations ((null))
-
rac_frz dlm-client freeze/unfreeze (kjfz)
-
kjoe dlm omni enqueue service (kjoe)
-
gcs global cache service (kjb)
-
gcs_bscn broadcast scn (kjb, kcrfw)
-
gcs_readmostly gcs read-mostly (kjb)
-
gcs_reader_bypass gcs reader bypass (kjb)
-
gcs_deltapush gcs delta push (kjb)
-
gcs_pcl2 persistent cluster flash cache (kjbfp)
-
gsipc global enqueue/cache service ipc ((null))
-
rac_rcfg reconfiguration ((null))
-
rac_drm dynamic remastering ((null))
-
rac_mrdom multiple recovery domains ((null))
-
mrdom_esm multiple/pdb domains - enter/exit server mode (kjs, kjfz)
-
cgs cluster group services (kjxg)
-
cgsimr instance membership recovery (kjxgr)
-
rac_wlm work load management (wlm)
-
rac_mlmds rac multiple lms (kjm)
-
rac_ka kernel accelerator (kjk)
-
rac_lt rac latch usage ((null))
-
rac_slock slock optimisation ((null))
-
kjsc rac global stats (kjsc)
-
lmhb heartbeat monitoring (kjfm)
-
db_trace rdbms server only tracing ((null))
-
kst server trace layer tracing (kst)
-
ddedmp rdbms diagnostic data extractor dumper (dbked)
-
cursor shared cursor (kxs, kks)
-
bind_capture bind capture tracing ((null))
-
kksh cursor hash table tracing (kksh)
-
ksm kernel service memory (ksm)
-
kse kernel service error manager (kse)
-
explain sql explain plan (xpl)
-
rdbms_event rdbms events (dbkd)
-
lob_inode lob inode (kdli)
-
rdbms_adr rdbms adr (dbkr)
-
asm automatic storage management (kf)
-
kfk kfk (kfk)
-
kfkio kfk io (kfkio)
-
kfkio_count kfk io count ((null))
-
kfkio_cancel kfk io cancel ((null))
-
kfkio_hard kfk io hard errors ((null))
-
kfkio_split kfk io split ((null))
-
kfkio_misc kfk io miscellaneous ((null))
-
kfksb kfk subs (kfksubs)
-
kfksb_lib kfk subs libraries ((null))
-
kfksb_dm kfk subs disk management ((null))
-
kfks kfk sage (kfks)
-
kfn asm networking subsystem (kfn)
-
kfnu asm umbillicus (kfnm, kfns, kfnb)
-
kfns asm server networking (kfns)
-
kfnc asm client networking (kfnc)
-
kfnor kfn orion (kfnor)
-
kfis asm intelligent storage interfaces (kfis)
-
kfm asm node monitor interface implementation (kfm)
-
kfmd asm node monitor layer for diskgroup registration (kfmd)
-
kfms asm node monitor layers support function interface (kfms)
-
kffb asm metadata block (kffb)
-
kffd asm metadata directory (kffd)
-
kfz asm zecurity subsystem (kfz)
-
kfc asm cache (kfc)
-
kfr asm recovery (kfr)
-
kfe asm attributes (kfe)
-
kfdp asm pst (kfdp)
-
kfg asm diskgroups (kfg)
-
kfgb asm diskgroups background (kfgb)
-
kfds asm staleness registry and resync (kfds)
-
kfia asm remote (kfia)
-
kfias asm ioserver (kfias)
-
kfiac asm ioserver client (kfiac)
-
kffscrub asm scrubbing (kffscrub)
-
kfio asm translation i/o layer (kfio)
-
kfioer asm translation i/o layer (kfioer)
-
kfv asm volume subsystem (kfv)
-
kfvsu asm volume umbilicus (kfvsu)
-
kfvsd asm volume background (kfvsd)
-
kfvioc asm volume cell storage (kfvioc)
-
kfdx asm exadata interface (kfdx)
-
kfzp asm password file layer (kfzp)
-
kfa asm alias operations (kfa)
-
kff kff (kff)
-
kfd asm disk (kfd)
-
kfdva asm virtual atb (kfdva)
-
kftha asm transparent high availability (kftha)
-
kffg asm file group (kffg)
-
kffs asm split mirror operations (kffs)
-
kfios kfio simple (kfios)
-
dml dml drivers (ins, del, upd)
-
health_monitor health monitor ((null))
-
dra data repair advisor ((null))
-
diracc direct access to fixed tables (kqfd)
-
part partitioning (kkpo, qespc, qesma, kkpa, qergi)
-
part_intpart interval partitioning ((null))
-
part_dictionary partitioning dictionary (kkpod)
-
lob_kdlw lob kdlw (kdlw)
-
lob_kdlx lob xfm (kdlx)
-
lob_kdlxdup lob dedup (kdlxdup)
-
lob_kdlrci lob rci (kdlrci)
-
lob_kdla securefile archive (kdla)
-
sql_manage sql manageability (kes)
-
sql_manage_infra other sql manageability infrastructure (kesai, kesqs, kesatm, kesutl, kessi, keswat, keswts, keswsq)
-
sql_tune sql tuning advisor (kest)
-
sql_tune_auto sql tuning advisor (auto-tune) (kestsa)
-
auto_tune_opt auto tuning optimizer (kkoat)
-
sql_tune_index sql tuning advisor (index-tune) (kestsi)
-
sql_tune_plan sql tuning advisor (plan node analysis) (kestsp)
-
sql_tune_px sql tuning advisor (parallel execution) (kestsa)
-
sql_tune_fr sql tuning advisor (fix regression) (kestsa)
-
sql_tune_stats sql tuning advisor (statistics advisor) (kestss)
-
sql_tune_exa sql tuning advisor (exadata) (kestsaexa)
-
sql_test_exec sql test-execute service (kestse)
-
sql_perf sql performance analyzer (kesp, keswpi)
-
sql_repair sql repair advisor (kesds)
-
sql_trace_parser sql trace parser (kesstp)
-
sql_analyze sql analyze (qksan)
-
sql_ds sql dynamic sampling services (qksds)
-
sql_ddl sql ddl (atb, ctc, dtb)
-
kkp kkp manager (kkp)
-
rat_wcr real application test: workload capture and replay (kec)
-
spatial spatial (md)
-
spatial_ind spatial indexing (mdr)
-
spatial_gr spatial georaster (mdgr)
-
text text (dr)
-
rdbms_gc rdbms diagnostic generic configuration (dbkgc)
-
xs xs fusion security (kzx)
-
xssession xs session (kzxs)
-
xsprincipal xs principal (kzxu)
-
xssecclass xs security class (kzxc, kzxsp)
-
xsxds xs data security (kzxd)
-
xsvpd xs vpd ((null))
-
xsxdb_default xs xdb ((null))
-
xs_midtier xs midtier (kpuzxs)
-
xsnstemplate xs namespace template (kzxnt)
-
xsacl xs acl (kzxa)
-
xsadm xs administrative operation (kzxm, kzxi)
-
aq streams advanced queuing (kwq, kkcn, kpon, kpoaq, kpce, kpcm, kpun, kpuaq, kws)
-
aq_deq streams advanced queuing dequeue (kwqid, kwqdl)
-
aq_back streams advanced queueing background (kwsbg, kwsbsm)
-
aq_tm streams advanced queuing time manager (kwqit, kwqmn)
-
aq_cp streams advanced queuing cross process (kwscp, kwsipc)
-
aq_lb streams advanced queuing load balancer (kwslb, kwslbbg)
-
aq_ntfn streams advanced queuing notification (kpond, kkcne)
-
aq_ntfnp12c streams advanced queuing pre-12c notification (kwqic)
-
aq_tmsq streams advanced queuing time manager for sharded queue (kwsbtm, kwsbjc, kwsbit)
-
aq_mc streams advanced queuing message cache (kwsmc, kwssh, kwsmb, kwsmsg, kwssb, kwschnk, kwscb, kwsdqwm, kwssbsh)
-
aq_pt streams advanced queuing partitioning (kwspt)
-
aq_sub streams advanced queuing subscription (kwssi, kwssa, kwsnsm, kwsnsme)
-
aq_opt streams advanced queuing opt (kwssub)
-
aq_dly streams advanced queuing delay (kwsdly)
-
ksfm kernel service file mapping (ksfm)
-
kxd exadata specific kernel modules (kxd)
-
kxdam exadata disk auto manage (kxdam)
-
kcfis exadata predicate push (kcfis)
-
nsmtio trace non smart i/o (nsmtio)
-
kxdbio exadata block level intelligent operations (kxdbio)
-
kxdrs exadata resilvering layer (kxdrs)
-
kxdofl exadata offload (kxdofl)
-
kxdmisc exadata misc (kxdmisc)
-
kxdcm exadata metrics fixed table callbacks (kxdcm)
-
kxdbc exadata backup compression for backup appliance (kxdbc)
-
dv database vault (kzv)
-
aso advanced security option ((null))
-
radm real-time application-controlled data masking (kzradm)
-
svrman server manageability (ke)
-
awr automatic workload repository (kew)
-
ash active session history (kewa)
-
metrics awr metrics (kewm)
-
repository awr repository (kewr)
-
flush awr snapshot flush (kewrf)
-
purge awr snapshot purge (kewrps)
-
awrutl awr utilities (kewu)
-
autotask automated maintenance tasks (ket)
-
mmon mmon/mmnl infrastructure (keb)
-
svralrt server generated alert infrastructure (kel)
-
iut iut infrastructure (keiut)
-
ols oracle label security (zll)
-
auditng database audit next generation (aud, kza, kzft, aus, aop, ttp)
-
configuration ang configuration (aud, kza, kzft, aus, aop, ttp)
-
queuewrite ang queue write (aud, kza, kzft, aus, aop, ttp)
-
filewrite ang file write (aud, kza, kzft, aus, aop, ttp)
-
recordcompose ang record compose (aud, kza, kzft, aus, aop, ttp)
-
dbconsolidation ang database consolidation (aud, kza, kzft, aus, aop, ttp)
-
sys_auditing ang sys auditing (aud, kza, kzft, aus, aop, ttp)
-
kjci kjci cross instance call (kjci)
-
kjz kjz - diag (kjz)
-
kjzc kjzc - diag communication layer (kjzc)
-
kjzd kjzd - diag main layer (kjzd)
-
kjzf kjzf - diag flow control layer (kjzf)
-
kjzg kjzg - diag group services layer (kjzg)
-
kjzh kjzh - diag api layer (kjzh)
-
kjzm kjzm - diag membership layer (kjzm)
-
sec security (kz)
-
cbac code-based access control (kzc)
-
vpd virtual private database (kzr)
-
gdsi generic directory services integration (kzlg)
-
dbop dbop monitoring (keomn)
-
dbop_gen dbop generic service (keomg)
-
dbop_deamon dbop monitoring deamon (keomg)
-
dbop_comp dbop composite type (keomm)
-
em_express em express (kex)
-
orarep orarep (ker)
-
data data layer (kd, ka)
-
kds kernel data scan (kds)
-
kdsrid fetch by rowid (kdsgrp, kdsgnp)
-
kdsfts full table scan (kdsttgr, kdstgr)
-
kdsclu cluster table scan (kdsics, kdscgr)
-
kdwf kernel data worker framework (kdwf)
-
imoltp_kv inmemory oltp keyvalue (kdkv)
-
memopt_fi memoptimize for write (kdfi)
-
rat real application testing (kec)
-
rat_mask real application testing: masking (kesm, kecprm)
-
ba backup appliance (kbrs)
-
kbc ba containers (kbc)
-
connection_broker connection broker (kmp)
-
kra kernel recovery area function (kra)
-
kra_sql kra sql tracing ((null))
-
krb kernel backup restore (krb)
-
krb_thread krbbpc thread switches ((null))
-
krb_io krb i/o ((null))
-
krb_incr krb incremental restore ((null))
-
krb_perf krb performance tracing ((null))
-
krb_bpoutput detailed backup piece output ((null))
-
krb_bpval detailed block list during restore validate ((null))
-
krb_flwres details on restore flow ((null))
-
krb_flwcpy details on krbydd flow ((null))
-
krb_flwbck details on backup flow ((null))
-
krb_flwusage rman feature usage ((null))
-
krb_optim unused space compression ((null))
-
krbabr auto block media recovery (krbabr)
-
krc recovery block change tracking (krc)
-
krc_changes recovery block change tracking changes ((null))
-
im in-memory ((null))
-
im_transaction im transaction layer ((null))
-
im_txn_pj im txn private journal (ktmpj)
-
im_txn_sj im txn shared journal (ktmsj)
-
im_txn_js im txn journal scan (ktmjs)
-
im_txn_conc im txn concurrency (ktmc)
-
im_txn_blk im txn block (ktmb)
-
im_txn_read im txn read (ktmr)
-
im_txn_adg im txn adg (ktma)
-
im_space im space layer ((null))
-
im_data im data layer (kdm)
-
im_populate im populating (kdml)
-
im_background im background (kdmr)
-
im_scan im scans ((null))
-
im_journal im journal ((null))
-
im_dump im dump ((null))
-
im_fs im faststart ((null))
-
im_optimizer im optimizer (kdmo)
-
im_gd im gd (kdmgd)
-
im_ado im ado (kdmado)
-
im_ime im ime (kdmime)
-
im_dictionary im dictionary and cache (kdmd)
-
im_verification im verification (kdmv)
-
xdb_wallet xdb wallet (kzs)
-
progint programmatic interfaces (kp)
-
oci oci (oci, kpk, kpn)
-
opi opi (opi)
-
rpi rpi (rpi, kpr)
-
npi npi (npi, nco, kpfs)
-
two_task two task (osn, ksn)
-
progint_plsql programmatic interfaces to/from pl/sql (kkx, psd, pckl, plswa)
-
two_phase two-phase commit (k2)
-
conn_pool connection pool (kppl)
-
tsm transparent session migration (kpm, kps)
-
progint_misc progint miscellaneous (kpo, kpbf, kpin)
-
kdfs dbfs c-api (kdfs)
-
olap olap analytic workspace (xs)
-
olap_paging olap paging manager (xspg, xsdb)
-
streams replication (knl)
-
streams_capture streams capture (knlc)
-
streams_propagation streams propagation ((null))
-
streams_propagation_sender streams propagation sender (knlcsv)
-
streams_propagation_receiver streams propagation receiver (knanr)
-
streams_apply streams apply (kna)
-
streams_apply_coordinator streams apply coordinator (knac)
-
streams_apply_reader streams apply reader (knalf)
-
streams_apply_server streams apply server (knas)
-
space space (ktd, kte, kts, ktf, ktt)
-
search_cache search cache (ktspsc)
-
context oracle text (dr, kci)
-
context_index oracle text index (drs, drg, drn, drl, dre)
-
context_query oracle text query (drex, drp, dry, drw)
-
rdbms_uts rdbms unified tracing service (uts) (dbkt)
-
mira_rcv mira recovery (krd, krp, krr)
-
reg_cache registration caches (kssmc)
-
ofs kernel services oracle file system ((null))
-
ofs_ksfs ofs file system (ksfs)
-
ofs_ksfsd ofs file system dispatcher (ksfsd)
-
ofs_ksfsm ofs file system metadata (ksfsm)
-
ofs_ksfsc1 ofs file system callback (ksfsc1)
-
ofs_skofs ofs file system implementation (skofs)
-
sql_compare_plans sql compare plans (keplan)
-
-
components in library generic:
-
--------------------------
-
generic_vos generic vos ((null))
-
vos_heap_manager vos heap manager ((null))
-
vos_latches vos latches ((null))
-
vos_gst vos generic stack trace (kgds)
-
xml xml (qmxt, qmxq)
-
generic_xdb generic xdb ((null))
-
xdb_repository xdb repository (qme)
-
xdb_protocols xdb protocols (qmh, qmf, qmn)
-
xdb_query xdb query (qmxtra, qerxp)
-
xdb_xmlindex xdb xmlindex (qmxtri, qmixq)
-
xdb_schema xdb schema (qmxtri, qmixq)
-
xdb_xob xdb xob (qmx)
-
xdb_csx xdb csx (qmcx)
-
xdb_csx_encoding xdb csx encoding (qmcxe, qmcxm)
-
xdb_csx_decoding xdb csx decoding (qmcxd)
-
xdb_csx_selfcon xdb csx selfcon (qmcxe)
-
xdb_csx_print xdb csx print (qmxrs, qmxp, kolace, kolars)
-
xdb_csx_tokenmgr xdb csx tokenmgr (qmtm)
-
xdb_default xdb default ((null))
-
xdb_memory xdb memory (qmu)
-
lob lob (koll, kola)
-
lob_refcount lob refcount (kolr)
-
lob_default lob default (koll, kole, kokl, koxs)
-
lob_dblink lob dblink (koll, kokl, kpolobr, kkxlr)
-
lob_temporary lob temporary (kola, koklt)
-
lob_api lob api (kpolob, kkxlr, kokle, koklc)
-
kgh kgh memory allocator (kgh)
-
kgf asm automatic storage management (kgf)
-
libcache libcache (kgl, kql)
-
lco_status_ddl change of lib-cache-obj status during ddl ((null))
-
objects objects ((null))
-
objects_ddl objects ddl (kokt)
-
objects_types objects types (kot, ko, ort)
-
objects_images objects images (koke, kot, kad)
-
objects_anydata objects anydata (kokla, kolo, kot, kad)
-
objects_streams objects streams (koxs)
-
objects_dict objects dictionary (kkdo, qcdo)
-
objects_semanal objects semantic analysis (koks, qcso, qcto)
-
objects_default objects default ((null))
-
objects_tables objects tables (kkbo)
-
kgfpm patch repository (kgfpm)
-
kgfdvf voting file interface (kgfdvf)
-
shared_objects shared object manager (pes)
-
so_loader native code loader (pesld)
-
direct_nfs direct nfs client (kgnfs, kgodm, skgnfs)
-
kgsc session cache for cursors ((null))
-
kgsc_kqd session cache for kqd cursors ((null))
-
kgsc_bun session cache for kqd bundled cursors ((null))
-
kgsc_kks session cache for kks cursors ((null))
-
kgsc_pls session cache for plsql cursors ((null))
-
kgsc_cons session cache for constraint cursors ((null))
-
kgsc_trig session cache for trigger cursors ((null))
-
kgsc_jox session cache for jox shortname translation cursors ((null))
-
kdi index layer (kdi)
-
kdiadhi index layer compress advanced high ((null))
-
kdiadlo index layer compress advanced low ((null))
-
kdil index load (kdil)
-
kdiladhi index load compress advanced high ((null))
-
kdiladlo index load compress advanced low ((null))
-
kdis index split (kdis)
-
kdisadhi index split compress advanced high ((null))
-
kdisadlo index split compress advanced low ((null))
-
kdxt index reorg (kdxt)
-
kdxtadhi index adlo compress advanced high ((null))
-
kdxtadlo index reorg compress advanced low ((null))
-
kdim index coalesce (kdim)
-
kdimadhi index coalesece compress advanced high ((null))
-
kdimadlo index coalesece compress advanced low ((null))
-
kdif index scan (kdif)
-
kdifadhi index scan compress advanced high ((null))
-
kdifadlo index scan compress advanced low ((null))
-
kdizadhi advanced high index codec (kdizoltp)
-
kdizadlo advanced low index codec ((null))
-
kdidml index dml ((null))
-
kdidmladhi index dml compress advanced high ((null))
-
kdidmladlo index dml compress advanced low ((null))
-
kdigdr index ghost data removal ((null))
-
kdigdrbr index ghost data removal branch ((null))
-
kdigdrlf index ghost data removal leaf ((null))
-
-
components in library client:
-
--------------------------
-
client_kpu client kpu ((null))
-
kpu_memory kpu memory ((null))
-
kpu_ttc kpu ttc ((null))
-
kpu_relational kpu relational ((null))
-
kpu_objects kpu objects ((null))
-
kpu_lobs kpu lobs ((null))
-
progint_appcont prog interfaces application continuity ((null))
-
progint_appcont_rdbms prog interfaces application continuity rdbms-side ((null))
-
sqlldr_load sqlldr load (ul)
-
dpapi_load dpapi load (kpudp)
-
dbfs_client_profiler dbfs_client profiler ((null))
-
-
components in library libcell:
-
--------------------------
-
client_library client library ((null))
-
disk_layer disk layer ((null))
-
network_layer network layer ((null))
-
connect_layer connect layer ((null))
-
ipc_layer ipc layer ((null))
-
-
components in library oranet:
-
--------------------------
-
tnslsnr oranet listener ((null))
-
net_nsgr network service generic registration ((null))
-
net_nsgi tni network service generic listener user-defined class ((null))
-
cman oranet connection manager ((null))
-
net oranet services ((null))
-
net_ni network interface layer ((null))
-
net_ns network session layer ((null))
-
net_nt network transport layer ((null))
-
net_ntm network transport mailbox layer ((null))
-
net_ntp network transport ipc layer ((null))
-
net_ntt network transport tcp/ip layer ((null))
-
net_ntus network transport unix domain sockets layer ((null))
-
net_nl network library ((null))
-
net_na network authentication ((null))
-
net_nz network zecurity ((null))
-
net_ntz network ssl ((null))
-
net_nu network trace route utility ((null))
-
net_nn network names ((null))
-
-
components in library advcmp:
-
--------------------------
-
advcmp_main archive compression (kdz)
-
advcmp_comp archive compression: compression (kdzc, kdzh, kdza)
-
advcmp_decomp archive compression: decompression (kdzd, kdzs)
-
advcmp_decomp_hpk archive compression: hpk (kdzk)
-
advcmp_decomp_pcode archive compression: pcode (kdp)
-
-
components in library plsql:
-
--------------------------
-
plsql_apps pl/sql apps (di, pi, plitblm, scm, std, textio, wpiutil)
-
plsql_utl_file pl/sql utl file (pifi)
-
plsql_codegen pl/sql codegen ((null))
-
plsql_cog_idl_gen pl/sql codegen idl gen (pdw)
-
plsql_cog_infrastructure pl/sql codegen infrastructure (pdz)
-
plsql_cog_native pl/sql codegen native (pdn)
-
plsql_cog_optimizer pl/sql codegen optimizer (pdx)
-
plsql_cog_mcode_gen pl/sql codegen mcode gen (pdy)
-
plsql_code_execution pl/sql code execution (pb, pd, pe, pf, plst, pri)
-
plsql_stack_frames pl/sql runtime stack frame (pfrstk)
-
plsql_external_proc pl/sql external proc (pef, ociextp)
-
plsql_idl pl/sql idl (pdt, pt)
-
plsql_ilms pl/sql ilms (pgm)
-
plsql_knlde pl/sql knlde (pbbicd, pbp3g, pbs, pbt3g, peibp)
-
plsql_kg_interface pl/sql kg interface (bam, hep, hsh, lis, par, phdr, pk)
-
plsql_infrastructure pl/sql infrastructure (pci, pcm, ph, pl, pncutil, pp, ps, pu, tre)
-
plsql_psd pl/sql psd ((null))
-
plsql_psd_generic pl/sql psd generic (psd, pso, psu)
-
plsql_psd_standalones pl/sql psd standalones (p2c, pls, psx)
-
plsql_semantics pl/sql semantics (ph2, pha, phn)
-
plsql_syntax pl/sql syntax (ph1)
-
-
components in library xdk:
-
--------------------------
-
xdk_parser xdk parser ((null))
-
xdk_fsm_parser xdk fsm parser (lpxfsm)
-
xdk_schema_validator xdk schema validator ((null))
-
xdk_xslt_engine xdk xslt engine ((null))
-
-
components in library vplib:
-
--------------------------
-
vector_translate vector translate (qkaxl, qerxl, qesxl, evaxl)
-
vector_aggregate vector aggregate (qergv, qesgv, evavgby)
-
vector_px vector px (qesxlp)
-
binary_decimal binary decimal (qesdsb, ldsb)
参考:
-
tech.e2sn.com/oracle/troubleshooting
-
juliandyke.com/diagnostics/tools/oradebug/oradebug.php 朱利安。戴克
-
阅读(944) | 评论(0) | 转发(0) |