• 11g新特性:RDBMS Component TRACE


    11g新特性UTS TRACE是比10g中引入的KST TRACE更强力内部诊断工具, 有了UTS和KST这2现代化个debugger工具, 我们差不多可以扔掉gdb和dtrace的拐杖了。   今后会继续介绍UTS和KST TRACE的使用方法,让任何人都有机会了解Oracle的内部运行原理。   以下是UTS trace events 的列表,可以利用oradebug doc component rdbms列出:  
    SQL> select * from v$version;
    
    BANNER
    --------------------------------------------------------------------------------
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    PL/SQL Release 11.2.0.3.0 - Production
    CORE    11.2.0.3.0      Production
    TNS for Linux: Version 11.2.0.3.0 - Production
    NLSRTL Version 11.2.0.3.0 - Production
    
    SQL> oradebug doc component rdbms
    
    Components in library RDBMS:
    --------------------------
      SQL_Compiler                 SQL Compiler
        SQL_Parser                 SQL Parser (qcs)
        SQL_Semantic               SQL Semantic Analysis (kkm)
        SQL_Optimizer              SQL Optimizer
          SQL_Transform            SQL Transformation (kkq, vop, nso)
            SQL_MVRW               SQL Materialized View Rewrite
            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)
        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_Plan_Management      SQL Plan Managment (kkopm)
        MPGE                       MPGE (qksctx)
      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)
        Bloom_Filter               Bloom Filter (qerbl, qesbl)
          PX_Blackbox              Parallel Execution Blackbox (kxf)
      PGA_Manage                   PGA Memory Management
        PGA_Compile                PGA Memory Compilation
        PGA_IMM                    PGA Memory Instance Manage
        PGA_CMM                    PGA Memory Cursor Manage
        PGA_ADV                    PGA Memory Advisor
      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
        ksv_trace                  Kernel Services Slave Management (ksv)
      sql_mon                      SQL Monitor (keswx)
        sql_mon_deamon             SQL Monitor Deamon
        sql_mon_query              SQL Monitor Query
      CACHE_RCV                    Cache Recovery (kcv, kct, kcra, kcrp, kcb)
      DIRPATH_LOAD                 Direct Path Load (kl, kdbl, kpodp)
        DIRPATH_LOAD_BIS           Direct Path Kpodpbis Routine (kpodp)
      RAC                          Real Application Clusters
        GES                        Global Enqueue Service
        GCS                        Global Cache Service (kjb)
        GSIPC                      Global Enqueue/Cache Service IPC
          KSI                      Kernel Service Instance locking (ksi)
          RAC_ENQ                  Enqueue Operations
        RAC_RCFG                   Reconfiguration
        RAC_DRM                    Dynamic Remastering
        RAC_MRDOM                  Multiple Recovery Domains
        CGS                        Cluster Group Services (kjxg)
        CGSIMR                     Instance Membership Recovery (kjxgr)
          DD                       GES Deadlock Detection
          GCS_BSCN                 Broadcast SCN (kjb, kcrfw)
        RAC_WLM                    Work Load Management (wlm)
        RAC_MLMDS                  RAC Multiple LMS (kjm)
          GCS_READMOSTLY           GCS Read-mostly (kjb)
          GCS_READER_BYPASS        GCS Reader Bypass (kjb)
          GCS_DELTAPUSH            GCS Delta Push (kjb)
          RAC_BCAST                Enqueue Broadcast Operations
      db_trace                     RDBMS server only tracing
      kst                          server trace layer tracing (kst)
      ddedmp                       RDBMS Diagnostic Data Extractor Dumper (dbked)
      cursor                       Shared Cursor (kxs, kks)
        Bind_Capture               Bind Capture Tracing
      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)
          KFKSB                    KFK subs (kfksubs)
        KFN                        ASM Networking subsystem (kfn)
          KFNU                     ASM Umbillicus (kfnm, kfns, kfnb)
          KFNS                     ASM Server networking (kfns)
          KFNC                     ASM Client networking (kfnc)
        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)
        KFDS                       ASM staleness registry and resync (kfds)
      DML                          DML Drivers (ins, del, upd)
      Health_Monitor               Health Monitor
      DRA                          Data Repair Advisor
      DIRACC                       Direct access to fixed tables (kqfd)
      ASH                          Active Session History (kewa)
      PART                         Partitioning (kkpo, qespc, qesma, kkpa, qergi)
        PART_IntPart               Interval Partitioning
        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)
          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_Test_Exec              SQL Test-Execute Service (kestse)
        SQL_Perf                   SQL Performance Analyzer (kesp, keswpi)
        SQL_Repair                 SQL Repair Advisor (kesds)
            Auto_Tune_Opt          Auto Tuning Optimizer (kkoat)
        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)
      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)
        XSXDS                      XS Data Security (kzxd)
        XSVPD                      XS VPD
        XSXDB_DEFAULT              XS XDB
        XS_MIDTIER                 XS Midtier (kpuzxs)
      AQ                           Streams Advanced Queuing (kwq, kkcn, kpon, kpoaq, kpce, kpcm, kpun, kpuaq)
        AQ_DEQ                     Streams Advanced Queuing Dequeue (kwqid, kwqdl)
        AQ_TM                      Streams Advanced Queuing Time Manager (kwqit, kwqmn)
      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)
      DV                           Database Vault (kzv)
  • 相关阅读:
    pandas之数据读取
    pandas之简单数据统计描述
    人脸识别
    图像识别之物体识别
    图像识别之特征点检测
    图像识别之角点检测
    图像识别之边缘识别
    爬取企查查网站中安徽省内的企业数据信息
    民政局中行政区域数据爬取
    有道翻译和百度翻译在线爬取
  • 原文地址:https://www.cnblogs.com/macleanoracle/p/2968301.html
Copyright © 2020-2023  润新知