Chinaunix首页 | 论坛 | 博客
  • 博客访问: 9167942
  • 博文数量: 1669
  • 博客积分: 16831
  • 博客等级: 上将
  • 技术积分: 12594
  • 用 户 组: 普通用户
  • 注册时间: 2011-02-25 07:23
个人简介

柔中带刚,刚中带柔,淫荡中富含柔和,刚猛中荡漾风骚,无坚不摧,无孔不入!

文章分类

全部博文(1669)

文章存档

2023年(4)

2022年(1)

2021年(10)

2020年(24)

2019年(4)

2018年(19)

2017年(66)

2016年(60)

2015年(49)

2014年(201)

2013年(221)

2012年(638)

2011年(372)

分类: Oracle

2012-06-25 15:43:09

Oracle 查看 session 当前统计信息 脚本 说明
http://blog.csdn.net/tianlesoftware/article/details/7689450


一.相关说明

当我们在一个session 上进行事务操作时,如果我们想查看这个事务的相关统计信息,那么可以通过v$mystat ,v$sysstat, v$sesstat, v$statname 字典来查看。 在Oracle 11g中,通过这2个视图,我么可以查看到588个相关的统计信息。


  1. SQL> select * from v$version;  
  2.   
  3. BANNER  
  4. --------------------------------------------------------------------------------   
  5. Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production  
  6. PL/SQL Release 11.2.0.1.0 - Production  
  7. CORE    11.2.0.1.0      Production  
  8. TNS for 64-bit Windows: Version 11.2.0.1.0 - Production  
  9. NLSRTL Version 11.2.0.1.0 - Production  
  10.   
  11. SQL> SELECT COUNT (*)  
  12.   2    FROM v$mystat vm, v$sysstat vs  
  13.   3   WHERE vm.statistic# = vs.statistic#;  
  14.   
  15.   COUNT(*)  
  16. ----------   
  17.        588  
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for 64-bit Windows: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production SQL> SELECT COUNT (*) 2 FROM v$mystat vm, v$sysstat vs 3 WHERE vm.statistic# = vs.statistic#; COUNT(*) ---------- 588

v$mystat 字典只能查看当前session 的信息,而v$sesstat 可以查看所有session 的信息,v$sysstat和v$statname 是对统计信息的一个说明。如果不是SYS 用户来执行,那么就需要单独的对这些用户进行赋权操作,具体命令如下:

  1. grant select on v_$mystat to anqing;  
  2. grant select on v_$statname to anqing;  
  3. grant select on v_$sesstat to anqing;  
  4. grant select on v_$sysstat to anqing;  
grant select on v_$mystat to anqing; grant select on v_$statname to anqing; grant select on v_$sesstat to anqing; grant select on v_$sysstat to anqing;


有关Oracle 视图的相关说明参考:

 

Oracle 性能相关的几个 视图 和 参数

http://blog.csdn.net/tianlesoftware/article/details/5867276

 

Oracle 动态性能视图

http://blog.csdn.net/tianlesoftware/article/details/5863191

 

二.查看当前session 的统计信息:v$mystat v$sysstat

我们可以通过如果SQL 来查看当前session 的具体统计信息,从而来帮助我们分析SQL 语句:

  1. /* Formatted on 2012/6/25 10:57:20 (QP5 v5.185.11230.41888) */  
  2. SELECT vm.sid, vs.name, vm.VALUE  
  3.   FROM v$mystat vm, v$sysstat vs  
  4.  WHERE     vm.statistic# = vs.statistic#  
  5.        AND vs.name IN  
  6.               ('cleanouts only - consistent read gets',  
  7.                'session logical reads',  
  8.                'physical reads',  
  9.                'physical reads direct',  
  10.                'redo size');  
  11.                 
/* Formatted on 2012/6/25 10:57:20 (QP5 v5.185.11230.41888) */ SELECT vm.sid, vs.name, vm.VALUE FROM v$mystat vm, v$sysstat vs WHERE vm.statistic# = vs.statistic# AND vs.name IN ('cleanouts only - consistent read gets', 'session logical reads', 'physical reads', 'physical reads direct', 'redo size');

 

这个操作需要注意相关的权限问题。

 

 

三.查看所有session的统计信息:v$sessstat  v$statname

 

  1. /* Formatted on 2012/6/25 12:39:51 (QP5 v5.185.11230.41888) */  
  2. SELECT a.sid, b.name, a.VALUE  
  3.   FROM v$sesstat a, v$statname b  
  4.  WHERE     a.statistic# = b.statistic#  
  5.        AND b.name IN  
  6.               ('cleanouts only - consistent read gets',  
  7.                'session logical reads',  
  8.                'physical reads',  
  9.                'physical reads direct',  
  10.                'redo size');  
/* Formatted on 2012/6/25 12:39:51 (QP5 v5.185.11230.41888) */ SELECT a.sid, b.name, a.VALUE FROM v$sesstat a, v$statname b WHERE a.statistic# = b.statistic# AND b.name IN ('cleanouts only - consistent read gets', 'session logical reads', 'physical reads', 'physical reads direct', 'redo size');


这里我们也可以加上SID 条件,只查看某个session的的统计信息,获取SID的方法参考:

Oracle 查看当前会话 SESSION ID 方法 说明

http://blog.csdn.net/tianlesoftware/article/details/7240085

 

  1. SELECT a.sid, b.name, a.VALUE  
  2.   FROM v$sesstat a, v$statname b  
  3.  WHERE     a.statistic# = b.statistic#  
  4.        AND sid = 139  
  5.        AND b.name IN  
  6.               ('cleanouts only - consistent read gets',  
  7.                'session logical reads',  
  8.                'physical reads',  
  9.                'physical reads direct',  
  10.                'redo size');  
SELECT a.sid, b.name, a.VALUE FROM v$sesstat a, v$statname b WHERE a.statistic# = b.statistic# AND sid = 139 AND b.name IN ('cleanouts only - consistent read gets', 'session logical reads', 'physical reads', 'physical reads direct', 'redo size');


四.所有的统计信息列表

            在Oracle 11gR2中总共有588个相关的统计,我们可以根据自己的需要来查看相关的信息,这588个统计的所有列表如下:

 

  1. SQL> SELECT vm.sid, vs.name, vm.VALUE  
  2.   2    FROM v$mystat vm, v$sysstat vs  
  3.   3   WHERE     vm.statistic# = vs.statistic#;  
  4.   
  5.        SID NAME                                                                  VALUE  
  6. ---------- ---------------------------------------------------------------- ----------   
  7.        139 OS CPU Qt wait time                                                       0  
  8.        139 logons cumulative                                                         1  
  9.        139 logons current                                                            1  
  10.        139 opened cursors cumulative                                                90  
  11.        139 opened cursors current                                                    2  
  12.        139 user commits                                                              0  
  13.        139 user rollbacks                                                            0  
  14.        139 user calls                                                             1180  
  15.        139 recursive calls                                                         957  
  16.        139 recursive cpu usage                                                       2  
  17.        139 pinned cursors current                                                    1  
  18.        139 session logical reads                                                   242  
  19.        139 session stored procedure space                                            0  
  20.        139 CPU used when call started                                               36  
  21.        139 CPU used by this session                                                 36  
  22.        139 DB time                                                                  57  
  23.        139 cluster wait time                                                         0  
  24.        139 concurrency wait time                                                     0  
  25.        139 application wait time                                                     0  
  26.        139 user I/O wait time                                                       21  
  27.        139 scheduler wait time                                                       0  
  28.        139 non-idle wait time                                                       21  
  29.        139 non-idle wait count                                                    1184  
  30.        139 session connect time                                             1340593250  
  31.        139 process last non-idle time                                       1340593250  
  32.        139 session uga memory                                                  1524440  
  33.        139 session uga memory max                                              1975392  
  34.        139 messages sent                                                             2  
  35.        139 messages received                                                         0  
  36.        139 background timeouts                                                       0  
  37.        139 remote Oradebug requests                                                  0  
  38.        139 session pga memory                                                  2387672  
  39.        139 session pga memory max                                              2846424  
  40.        139 recursive system API invocations                                          0  
  41.        139 enqueue timeouts                                                          0  
  42.        139 enqueue waits                                                             0  
  43.        139 enqueue deadlocks                                                         0  
  44.        139 enqueue requests                                                         16  
  45.        139 enqueue conversions                                                       0  
  46.        139 enqueue releases                                                         15  
  47.        139 global enqueue gets sync                                                  0  
  48.        139 global enqueue gets async                                                 0  
  49.        139 global enqueue get time                                                   0  
  50.        139 global enqueue releases                                                   0  
  51.        139 physical read total IO requests                                          14  
  52.        139 physical read total multi block requests                                  0  
  53.        139 physical read requests optimized                                          0  
  54.        139 physical read total bytes                                            114688  
  55.        139 physical write total IO requests                                          0  
  56.        139 physical write total multi block requests                                 0  
  57.        139 physical write total bytes                                                0  
  58.        139 cell physical IO interconnect bytes                                  114688  
  59.        139 spare statistic 1                                                         0  
  60.        139 spare statistic 2                                                         0  
  61.        139 spare statistic 3                                                         0  
  62.        139 spare statistic 4                                                         0  
  63.        139 IPC CPU used by this session                                              0  
  64.        139 gcs messages sent                                                         0  
  65.        139 ges messages sent                                                         0  
  66.        139 global enqueue CPU used by this session                                   0  
  67.        139 max cf enq hold time                                                      0  
  68.        139 total cf enq hold time                                                    0  
  69.        139 total number of cf enq holders                                            0  
  70.        139 db block gets                                                             6  
  71.        139 db block gets from cache                                                  6  
  72.        139 db block gets from cache (fastpath)                                       0  
  73.        139 db block gets direct                                                      0  
  74.        139 consistent gets                                                         236  
  75.        139 consistent gets from cache                                              236  
  76.        139 consistent gets from cache (fastpath)                                   119  
  77.        139 consistent gets - examination                                           106  
  78.        139 consistent gets direct                                                    0  
  79.        139 physical reads                                                           14  
  80.        139 physical reads cache                                                     14  
  81.        139 physical read flash cache hits                                            0  
  82.        139 physical reads direct                                                     0  
  83.        139 physical read IO requests                                                14  
  84.        139 physical read bytes                                                  114688  
  85.        139 db block changes                                                          8  
  86.        139 consistent changes                                                        0  
  87.        139 recovery blocks read                                                      0  
  88.        139 recovery blocks read for lost write detection                             0  
  89.        139 recovery blocks skipped lost write checks                                 0  
  90.        139 physical writes                                                           0  
  91.        139 physical writes direct                                                    0  
  92.        139 physical writes from cache                                                0  
  93.        139 physical write IO requests                                                0  
  94.        139 flash cache inserts                                                       0  
  95.        139 physical reads direct temporary tablespace                                0  
  96.        139 physical writes direct temporary tablespace                               0  
  97.        139 physical write bytes                                                      0  
  98.        139 flash cache eviction: invalidated                                         0  
  99.        139 flash cache eviction: buffer pinned                                       0  
  100.        139 flash cache eviction: aged out                                            0  
  101.        139 flash cache insert skip: not current                                      0  
  102.        139 flash cache insert skip: DBWR overloaded                                  0  
  103.        139 flash cache insert skip: exists                                           0  
  104.        139 flash cache insert skip: not useful                                       0  
  105.        139 flash cache insert skip: modification                                     0  
  106.        139 flash cache insert skip: corrupt                                          0  
  107.        139 db corrupt blocks detected                                                0  
  108.        139 db corrupt blocks recovered                                               0  
  109.        139 physical writes non checkpoint                                            0  
  110.        139 summed dirty queue length                                                 0  
  111.        139 DBWR checkpoint buffers written                                           0  
  112.        139 DBWR thread checkpoint buffers written                                    0  
  113.        139 DBWR tablespace checkpoint buffers written                                0  
  114.        139 DBWR parallel query checkpoint buffers written                            0  
  115.        139 DBWR object drop buffers written                                          0  
  116.        139 DBWR transaction table writes                                             0  
  117.        139 DBWR undo block writes                                                    0  
  118.        139 DBWR revisited being-written buffer                                       0  
  119.        139 DBWR lru scans                                                            0  
  120.        139 DBWR checkpoints                                                          0  
  121.        139 DBWR fusion writes                                                        0  
  122.        139 prefetch clients - keep                                                   0  
  123.        139 prefetch clients - recycle                                                0  
  124.        139 prefetch clients - default                                                0  
  125.        139 prefetch clients - 2k                                                     0  
  126.        139 prefetch clients - 4k                                                     0  
  127.        139 prefetch clients - 8k                                                     0  
  128.        139 prefetch clients - 16k                                                    0  
  129.        139 prefetch clients - 32k                                                    0  
  130.        139 change write time                                                         0  
  131.        139 redo synch writes                                                         1  
  132.        139 redo synch time                                                           0  
  133.        139 exchange deadlocks                                                        0  
  134.        139 free buffer requested                                                    15  
  135.        139 dirty buffers inspected                                                   0  
  136.        139 pinned buffers inspected                                                  0  
  137.        139 hot buffers moved to head of LRU                                          0  
  138.        139 free buffer inspected                                                     0  
  139.        139 commit cleanout failures: write disabled                                  0  
  140.        139 commit cleanout failures: block lost                                      0  
  141.        139 commit cleanout failures: cannot pin                                      0  
  142.        139 commit cleanout failures: hot backup in progress                          0  
  143.        139 commit cleanout failures: buffer being written                            0  
  144.        139 commit cleanout failures: callback failure                                0  
  145.        139 commit cleanouts                                                          2  
  146.        139 commit cleanouts successfully completed                                   2  
  147.        139 recovery array reads                                                      0  
  148.        139 recovery array read time                                                  0  
  149.        139 CR blocks created                                                         0  
  150.        139 current blocks converted for CR                                           0  
  151.        139 switch current to new buffer                                              1  
  152.        139 write clones created in foreground                                        0  
  153.        139 write clones created in background                                        0  
  154.        139 write clones created for recovery                                         0  
  155.        139 recovery block gets from cache                                            0  
  156.        139 physical reads cache prefetch                                             0  
  157.        139 physical reads prefetch warmup                                            0  
  158.        139 prefetched blocks aged out before use                                     0  
  159.        139 prefetch warmup blocks aged out before use                                0  
  160.        139 prefetch warmup blocks flushed out before use                             0  
  161.        139 physical reads retry corrupt                                              0  
  162.        139 physical reads direct (lob)                                               0  
  163.        139 physical writes direct (lob)                                              0  
  164.        139 cold recycle reads                                                        0  
  165.        139 shared hash latch upgrades - no wait                                      3  
  166.        139 shared hash latch upgrades - wait                                         0  
  167.        139 physical reads for flashback new                                          0  
  168.        139 calls to kcmgcs                                                          11  
  169.        139 calls to kcmgrs                                                           0  
  170.        139 calls to kcmgas                                                           3  
  171.        139 calls to get snapshot scn: kcmgss                                        94  
  172.        139 redo blocks read for recovery                                             0  
  173.        139 redo k-bytes read for recovery                                            0  
  174.        139 redo k-bytes read for terminal recovery                                   0  
  175.        139 redo entries                                                              4  
  176.        139 redo size                                                              1756  
  177.        139 redo entries for lost write detection                                     0  
  178.        139 redo size for lost write detection                                        0  
  179.        139 redo size for direct writes                                               0  
  180.        139 redo buffer allocation retries                                            0  
  181.        139 redo wastage                                                              0  
  182.        139 redo writes                                                               0  
  183.        139 redo blocks written                                                       0  
  184.        139 redo write time                                                           0  
  185.        139 redo blocks checksummed by FG (exclusive)                                 0  
  186.        139 redo blocks checksummed by LGWR                                           0  
  187.        139 redo log space requests                                                   0  
  188.        139 redo log space wait time                                                  0  
  189.        139 redo ordering marks                                                       0  
  190.        139 redo subscn max counts                                                    0  
  191.        139 redo write broadcast ack time                                             0  
  192.        139 redo write broadcast ack count                                            0  
  193.        139 redo k-bytes read total                                                   0  
  194.        139 redo k-bytes read (memory)                                                0  
  195.        139 redo k-bytes read total by LNS                                            0  
  196.        139 redo k-bytes read (memory) by LNS                                         0  
  197.        139 file io service time                                                      0  
  198.        139 file io wait time                                                    210653  
  199.        139 gc cr blocks served                                                       0  
  200.        139 gc cr block read wait time                                                0  
  201.        139 gc cr block build time                                                    0  
  202.        139 gc cr block flush time                                                    0  
  203.        139 gc cr block send time                                                     0  
  204.        139 gc current blocks served                                                  0  
  205.        139 gc current block pin time                                                 0  
  206.        139 gc current block flush time                                               0  
  207.        139 gc current block send time                                                0  
  208.        139 gc cr blocks received                                                     0  
  209.        139 gc cr block receive time                                                  0  
  210.        139 gc current blocks received                                                0  
  211.        139 gc current block receive time                                             0  
  212.        139 gc local grants                                                           0  
  213.        139 gc remote grants                                                          0  
  214.        139 gc kbytes sent                                                            0  
  215.        139 gc kbytes saved                                                           0  
  216.        139 gc blocks compressed                                                      0  
  217.        139 gc blocks lost                                                            0  
  218.        139 gc claim blocks lost                                                      0  
  219.        139 gc blocks corrupt                                                         0  
  220.        139 gc CPU used by this session                                               0  
  221.        139 gc reader bypass grants                                                   0  
  222.        139 total number of slots                                                     0  
  223.        139 Effective IO time                                                         0  
  224.        139 Number of read IOs issued                                                 0  
  225.        139 background checkpoints started                                            0  
  226.        139 background checkpoints completed                                          0  
  227.        139 number of map operations                                                  0  
  228.        139 number of map misses                                                      0  
  229.        139 flashback log writes                                                      0  
  230.        139 flashback log write bytes                                                 0  
  231.        139 cell physical IO bytes saved during optimized file creation               0  
  232.        139 cell physical IO bytes saved during optimized RMAN file restore           0  
  233.        139 cell physical IO bytes eligible for predicate offload                     0  
  234.        139 cell physical IO bytes saved by storage index                             0  
  235.        139 cell smart IO session cache lookups                                       0  
  236.        139 cell smart IO session cache hits                                          0  
  237.        139 cell smart IO session cache soft misses                                   0  
  238.        139 cell smart IO session cache hard misses                                   0  
  239.        139 cell smart IO session cache hwm                                           0  
  240.        139 cell num smart IO sessions in rdbms block IO due to user                  0  
  241.        139 cell num smart IO sessions in rdbms block IO due to big payload           0  
  242.        139 cell num smart IO sessions using passthru mode due to user                0  
  243.        139 cell num smart IO sessions using passthru mode due to cellsrv             0  
  244.        139 cell num smart IO sessions using passthru mode due to timezone            0  
  245.        139 cell num smart file creation sessions using rdbms block IO mode           0  
  246.        139 cell physical IO interconnect bytes returned by smart scan                0  
  247.        139 cell session smart scan efficiency                                        0  
  248.        139 Batched IO vector read count                                              0  
  249.        139 Batched IO vector block count                                             0  
  250.        139 Batched IO single block count                                             0  
  251.        139 Batched IO zero block count                                               0  
  252.        139 Batched IO block miss count                                               0  
  253.        139 Batched IO double miss count                                              0  
  254.        139 Batched IO (full) vector count                                            0  
  255.        139 Batched IO (space) vector count                                           0  
  256.        139 Batched IO (bound) vector count                                           0  
  257.        139 Batched IO same unit count                                                0  
  258.        139 Batched IO buffer defrag count                                            0  
  259.        139 Batched IO slow jump count                                                0  
  260.        139 shared io pool buffer get success                                         0  
  261.        139 shared io pool buffer get failure                                         0  
  262.        139 temp space allocated (bytes)                                              0  
  263.        139 serializable aborts                                                       0  
  264.        139 transaction lock foreground requests                                      0  
  265.        139 transaction lock foreground wait time                                     0  
  266.        139 transaction lock background gets                                          0  
  267.        139 transaction lock background get time                                      0  
  268.        139 undo change vector size                                                 492  
  269.        139 transaction tables consistent reads - undo records applied                0  
  270.        139 transaction tables consistent read rollbacks                              0  
  271.        139 data blocks consistent reads - undo records applied                       0  
  272.        139 no work - consistent read gets                                          119  
  273.        139 cleanouts only - consistent read gets                                     0  
  274.        139 rollbacks only - consistent read gets                                     0  
  275.        139 cleanouts and rollbacks - consistent read gets                            0  
  276.        139 RowCR attempts                                                            0  
  277.        139 RowCR hits                                                                0  
  278.        139 RowCR - row contention                                                    0  
  279.        139 RowCR - resume                                                            0  
  280.        139 rollback changes - undo records applied                                   0  
  281.        139 transaction rollbacks                                                     0  
  282.        139 immediate (CURRENT) block cleanout applications                           0  
  283.        139 immediate (CR) block cleanout applications                                0  
  284.        139 deferred (CURRENT) block cleanout applications                            1  
  285.        139 commit txn count during cleanout                                          0  
  286.        139 active txn count during cleanout                                          0  
  287.        139 cleanout - number of ktugct calls                                         0  
  288.        139 immediate CR cleanouts (index blocks)                                     0  
  289.        139 deferred CUR cleanouts (index blocks)                                     0  
  290.        139 Commit SCN cached                                                         0  
  291.        139 Cached Commit SCN referenced                                              0  
  292.        139 Block Cleanout Optim referenced                                           0  
  293.        139 min active SCN optimization applied on CR                                 0  
  294.        139 auto extends on undo tablespace                                           0  
  295.        139 drop segment calls in space pressure                                      0  
  296.        139 total number of undo segments dropped                                     0  
  297.        139 doubling up with imu segment                                              0  
  298.        139 tune down retentions in space pressure                                    0  
  299.        139 steps of tune down ret. in space pressure                                 0  
  300.        139 space was found by tune down                                              0  
  301.        139 space was not found by tune down                                          0  
  302.        139 commit batch/immediate requested                                          0  
  303.        139 commit batch requested                                                    0  
  304.        139 commit immediate requested                                                0  
  305.        139 commit batch/immediate performed                                          0  
  306.        139 commit batch performed                                                    0  
  307.        139 commit immediate performed                                                0  
  308.        139 commit wait/nowait requested                                              0  
  309.        139 commit nowait requested                                                   0  
  310.        139 commit wait requested                                                     0  
  311.        139 commit wait/nowait performed                                              0  
  312.        139 commit nowait performed                                                   0  
  313.        139 commit wait performed                                                     0  
  314.        139 global undo segment hints helped                                          0  
  315.        139 global undo segment hints were stale                                      0  
  316.        139 local undo segment hints helped                                           0  
  317.        139 local undo segment hints were stale                                       0  
  318.        139 undo segment header was pinned                                            0  
  319.        139 IMU commits                                                               0  
  320.        139 IMU Flushes                                                               0  
  321.        139 IMU contention                                                            0  
  322.        139 IMU recursive-transaction flush                                           0  
  323.        139 IMU undo retention flush                                                  0  
  324.        139 IMU ktichg flush                                                          0  
  325.        139 IMU bind flushes                                                          0  
  326.        139 IMU mbu flush                                                             0  
  327.        139 IMU pool not allocated                                                    0  
  328.        139 IMU CR rollbacks                                                          0  
  329.        139 IMU undo allocation size                                                144  
  330.        139 IMU Redo allocation size                                                  0  
  331.        139 IMU- failed to get a private strand                                       0  
  332.        139 Misses for writing mapping                                                0  
  333.        139 segment dispenser load tasks                                              0  
  334.        139 segemnt dispenser load empty                                              0  
  335.        139 segment dispenser allocations                                             0  
  336.        139 segment cfs allocations                                                   0  
  337.        139 segment chunks allocation from disepnser                                  0  
  338.        139 segment total chunk allocation                                            0  
  339.        139 TBS Extension: tasks created                                              0  
  340.        139 TBS Extension: tasks executed                                             0  
  341.        139 TBS Extension: files extended                                             0  
  342.        139 TBS Extension: bytes extended                                             0  
  343.        139 total number of times SMON posted                                         0  
  344.        139 SMON posted for undo segment recovery                                     0  
  345.        139 SMON posted for txn recovery for other instances                          0  
  346.        139 SMON posted for instance recovery                                         0  
  347.        139 SMON posted for undo segment shrink                                       0  
  348.        139 SMON posted for dropping temp segment                                     0  
  349.        139 segment prealloc tasks                                                    0  
  350.        139 segment prealloc ops                                                      0  
  351.        139 segment prealloc bytes                                                    0  
  352.        139 segment prealloc time (ms)                                                0  
  353.        139 segment prealloc ufs2cfs bytes                                            0  
  354.        139 table scans (short tables)                                                4  
  355.        139 table scans (long tables)                                                 0  
  356.        139 table scans (rowid ranges)                                                0  
  357.        139 table scans (cache partitions)                                            0  
  358.        139 table scans (direct read)                                                 0  
  359.        139 table scan rows gotten                                                   80  
  360.        139 table scan blocks gotten                                                  3  
  361.        139 table fetch by rowid                                                     58  
  362.        139 table fetch continued row                                                 0  
  363.        139 cluster key scans                                                        16  
  364.        139 cluster key scan block gets                                              16  
  365.        139 rows fetched via callback                                                 4  
  366.        139 cell scans                                                                0  
  367.        139 cell blocks processed by cache layer                                      0  
  368.        139 cell blocks processed by txn layer                                        0  
  369.        139 cell blocks processed by data layer                                       0  
  370.        139 cell blocks processed by index layer                                      0  
  371.        139 cell commit cache queries                                                 0  
  372.        139 cell transactions found in commit cache                                   0  
  373.        139 cell blocks helped by commit cache                                        0  
  374.        139 cell blocks helped by minscn optimization                                 0  
  375.        139 cell blocks skipped due to chained rows                                   0  
  376.        139 cell simulated physical IO bytes eligible for predicate offload           0  
  377.        139 cell simulated physical IO bytes returned by predicate offload            0  
  378.        139 cell simulated session smart scan efficiency                              0  
  379.        139 cell CUs sent uncompressed                                                0  
  380.        139 cell CUs sent compressed                                                  0  
  381.        139 cell CUs sent head piece                                                  0  
  382.        139 cell CUs processed for uncompressed                                       0  
  383.        139 cell CUs processed for compressed                                         0  
  384.        139 cell IO uncompressed bytes                                                0  
  385.        139 queue update without cp update                                            0  
  386.        139 index crx upgrade (prefetch)                                              0  
  387.        139 index crx upgrade (found)                                                 0  
  388.        139 index crx upgrade (positioned)                                            0  
  389.        139 leaf node splits                                                          0  
  390.        139 leaf node 90-10 splits                                                    0  
  391.        139 branch node splits                                                        0  
  392.        139 root node splits                                                          0  
  393.        139 failed probes on index block reclamation                                  0  
  394.        139 recursive aborts on index block reclamation                               0  
  395.        139 index reclamation/extension switch                                        0  
  396.        139 native hash arithmetic execute                                            0  
  397.        139 native hash arithmetic fail                                               0  
  398.        139 lob reads                                                                 0  
  399.        139 lob writes                                                                0  
  400.        139 lob writes unaligned                                                      0  
  401.        139 cell index scans                                                          0  
  402.        139 index fast full scans (full)                                              0  
  403.        139 index fast full scans (rowid ranges)                                      0  
  404.        139 index fast full scans (direct read)                                       0  
  405.        139 index fetch by key                                                       24  
  406.        139 index scans kdiixs1                                                      44  
  407.        139 queue splits                                                              0  
  408.        139 queue flush                                                               0  
  409.        139 queue position update                                                     0  
  410.        139 queue single row                                                          0  
  411.        139 queue ocp pages                                                           0  
  412.        139 queue qno pages                                                           0  
  413.        139 heap block compress                                                       0  
  414.        139 HSC OLTP Space Saving                                                     0  
  415.        139 HSC OLTP Compressed Blocks                                                0  
  416.        139 HSC IDL Compressed Blocks                                                 0  
  417.        139 HSC Compressed Segment Block Changes                                      0  
  418.        139 HSC Heap Segment Block Changes                                            2  
  419.        139 HSC OLTP Non Compressible Blocks                                          0  
  420.        139 HSC OLTP positive compression                                             0  
  421.        139 HSC OLTP negative compression                                             0  
  422.        139 HSC OLTP recursive compression                                            0  
  423.        139 HSC OLTP inline compression                                               0  
  424.        139 HSC OLTP Drop Column                                                      0  
  425.        139 HSC OLTP Compression skipped rows                                         0  
  426.        139 HSC OLTP compression block checked                                        0  
  427.        139 Heap Segment Array Inserts                                                0  
  428.        139 Heap Segment Array Updates                                                0  
  429.        139 securefile allocation bytes                                               0  
  430.        139 securefile allocation chunks                                              0  
  431.        139 securefile direct read bytes                                              0  
  432.        139 securefile direct write bytes                                             0  
  433.        139 securefile direct read ops                                                0  
  434.        139 securefile direct write ops                                               0  
  435.        139 securefile inode read time                                                0  
  436.        139 securefile inode write time                                               0  
  437.        139 securefile inode ioreap time                                              0  
  438.        139 securefile bytes non-transformed                                          0  
  439.        139 securefile number of non-transformed flushes                              0  
  440.        139 securefile bytes encrypted                                                0  
  441.        139 securefile bytes cleartext                                                0  
  442.        139 securefile compressed bytes                                               0  
  443.        139 securefile uncompressed bytes                                             0  
  444.        139 securefile bytes deduplicated                                             0  
  445.        139 securefile create dedup set                                               0  
  446.        139 securefile destroy dedup set                                              0  
  447.        139 securefile add dedupd lob to set                                          0  
  448.        139 securefile rmv from dedup set                                             0  
  449.        139 securefile reject deduplication                                           0  
  450.        139 securefile dedup prefix hash match                                        0  
  451.        139 securefile number of flushes                                              0  
  452.        139 securefile dedup flush too low                                            0  
  453.        139 securefile dedup callback oper final                                      0  
  454.        139 securefile dedup hash collision                                           0  
  455.        139 securefile dedup fits inline                                              0  
  456.        139 CC CUs Compressed                                                         0  
  457.        139 CC Query Low CUs Compressed                                               0  
  458.        139 CC Query High CUs Compressed                                              0  
  459.        139 CC Archive CUs Compressed                                                 0  
  460.        139 CC Compressed Length Compressed                                           0  
  461.        139 CC Decompressed Length Compressed                                         0  
  462.        139 CC Rows Compressed                                                        0  
  463.        139 CC Rows Not Compressed                                                    0  
  464.        139 CC CU Row Pieces Compressed                                               0  
  465.        139 CC CUs Decompressed                                                       0  
  466.        139 CC Query Low CUs Decompressed                                             0  
  467.        139 CC Query High CUs Decompressed                                            0  
  468.        139 CC Archive CUs Decompressed                                               0  
  469.        139 CC Compressed Length Decompressed                                         0  
  470.        139 CC Decompressed Length Decompressed                                       0  
  471.        139 CC Columns Decompressed                                                   0  
  472.        139 CC Total Columns for Decompression                                        0  
  473.        139 CC Total Rows for Decompression                                           0  
  474.        139 CC Pieces Buffered for Decompression                                      0  
  475.        139 CC Total Pieces for Decompression                                         0  
  476.        139 CC DML CUs Decompressed                                                   0  
  477.        139 CC Scan CUs Decompressed                                                  0  
  478.        139 CC Turbo Scan CUs Decompressed                                            0  
  479.        139 CC Rowid CUs Decompressed                                                 0  
  480.        139 CC Analyze CUs Decompressed                                               0  
  481.        139 CC Dump CUs Decompressed                                                  0  
  482.        139 CC Check CUs Decompressed                                                 0  
  483.        139 CC Analyzer Calls                                                         0  
  484.        139 sql area purged                                                           2  
  485.        139 sql area evicted                                                          0  
  486.        139 CCursor + sql area evicted                                                0  
  487.        139 Noof Encrypt ops                                                        0  
  488.        139 Noof Decrypt ops                                                        0  
  489.        139 Noof XS Sessions Created                                                0  
  490.        139 Noof XS Sessions Attached                                               0  
  491.        139 Noof Namespaces Created                                                 0  
  492.        139 Noof User Callbacks Executed                                            0  
  493.        139 Noof Roles Enabled or Disabled                                          0  
  494.        139 Noof Principal Cache Misses                                             0  
  495.        139 Noof Principal Invalidations                                            0  
  496.        139 DX/BB enqueue lock foreground requests                                    0  
  497.        139 DX/BB enqueue lock foreground wait time                                   0  
  498.        139 DX/BB enqueue lock background gets                                        0  
  499.        139 DX/BB enqueue lock background get time                                    0  
  500.        139 Clusterwide global transactions                                           0  
  501.        139 Clusterwide global transactions spanning RAC nodes                        0  
  502.        139 Forwarded 2PC commands across RAC nodes                                   0  
  503.        139 GTX processes spawned by autotune                                         0  
  504.        139 GTX processes stopped by autotune                                         0  
  505.        139 session cursor cache hits                                                36  
  506.        139 session cursor cache count                                               20  
  507.        139 java call heap total size                                                 0  
  508.        139 java call heap total size max                                             0  
  509.        139 java call heap used size                                                  0  
  510.        139 java call heap used size max                                              0  
  511.        139 java call heap live size                                                  0  
  512.        139 java call heap live size max                                              0  
  513.        139 java call heap object count                                               0  
  514.        139 java call heap object count max                                           0  
  515.        139 java call heap live object count                                          0  
  516.        139 java call heap live object count max                                      0  
  517.        139 java call heap gc count                                                   0  
  518.        139 java call heap collected count                                            0  
  519.        139 java call heap collected bytes                                            0  
  520.        139 java session heap used size                                               0  
  521.        139 java session heap used size max                                           0  
  522.        139 java session heap live size                                               0  
  523.        139 java session heap live size max                                           0  
  524.        139 java session heap object count                                            0  
  525.        139 java session heap object count max                                        0  
  526.        139 java session heap live object count                                       0  
  527.        139 java session heap live object count max                                   0  
  528.        139 java session heap gc count                                                0  
  529.        139 java session heap collected count                                         0  
  530.        139 java session heap collected bytes                                         0  
  531.        139 cursor authentications                                                    8  
  532.        139 queries parallelized                                                      0  
  533.        139 DML statements parallelized                                               0  
  534.        139 DDL statements parallelized                                               0  
  535.        139 DFO trees parallelized                                                    0  
  536.        139 Parallel operations not downgraded                                        0  
  537.        139 Parallel operations downgraded to serial                                  0  
  538.        139 Parallel operations downgraded 75 to 99 pct                               0  
  539.        139 Parallel operations downgraded 50 to 75 pct                               0  
  540.        139 Parallel operations downgraded 25 to 50 pct                               0  
  541.        139 Parallel operations downgraded 1 to 25 pct                                0  
  542.        139 PX local messages sent                                                    0  
  543.        139 PX local messages recv'd                                                  0  
  544.        139 PX remote messages sent                                                   0  
  545.        139 PX remote messages recv'd                                                 0  
  546.        139 buffer is pinned count                                                    9  
  547.        139 buffer is not pinned count                                              194  
  548.        139 no buffer to keep pinned count                                            0  
  549.        139 workarea memory allocated                                              1245  
  550.        139 workarea executions - optimal                                            17  
  551.        139 workarea executions - onepass                                             0  
  552.        139 workarea executions - multipass                                           0  
  553.        139 LOB table id lookup cache misses                                          0  
  554.        139 parse time cpu                                                            3  
  555.        139 parse time elapsed                                                       26  
  556.        139 parse count (total)                                                      87  
  557.        139 parse count (hard)                                                        8  
  558.        139 parse count (failures)                                                    2  
  559.        139 parse count (describe)                                                    0  
  560.        139 frame signature mismatch                                                  0  
  561.        139 execute count                                                            97  
  562.        139 bytes sent via SQL*Net to client                                     384449  
  563.        139 bytes received via SQL*Net from client                                20349  
  564.        139 SQL*Net roundtrips to/from client                                      1164  
  565.        139 bytes sent via SQL*Net to dblink                                          0  
  566.        139 bytes received via SQL*Net from dblink                                    0  
  567.        139 SQL*Net roundtrips to/from dblink                                         0  
  568.        139 bytes via SQL*Net vector to client                                        0  
  569.        139 bytes via SQL*Net vector from client                                      0  
  570.        139 bytes via SQL*Net vector to dblink                                        0  
  571.        139 bytes via SQL*Net vector from dblink                                      0  
  572.        139 sorts (memory)                                                           39  
  573.        139 sorts (disk)                                                              0  
  574.        139 sorts (rows)                                                             21  
  575.        139 OTC commit optimization attempts                                          0  
  576.        139 OTC commit optimization hits                                              0  
  577.        139 OTC commit optimization failure - setup                                   0  
  578.        139 cell flash cache read hits                                                0  
  579.        139 Workload Capture: size (in bytes) of recording                            0  
  580.        139 Workload Capture: dbtime                                                  0  
  581.        139 Workload Capture: user calls                                              0  
  582.        139 Workload Capture: user calls flushed                                      0  
  583.        139 Workload Capture: unreplayable user calls                                 0  
  584.        139 Workload Capture: user txns                                               0  
  585.        139 Workload Capture: user logins                                             0  
  586.        139 Workload Capture: unsupported user calls                                  0  
  587.        139 Workload Capture: errors                                                  0  
  588.        139 Workload Replay: dbtime                                                   0  
  589.        139 Workload Replay: network time                                             0  
  590.        139 Workload Replay: think time                                               0  
  591.        139 Workload Replay: time gain                                                0  
  592.        139 Workload Replay: time loss                                                0  
  593.        139 Workload Replay: user calls                                               0  
  594.        139 Workload Replay: deadlocks resolved                                       0  
  595.   
  596. 588 rows selected.  
  597.   
  598. SQL>  


阅读(3135) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~