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 朱利安。戴克
-
阅读(1128) | 评论(0) | 转发(0) |
