oracle_exadata_monitoring

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
oracle_exadata_monitoring [2020/12/04 14:58] – andonovjoracle_exadata_monitoring [2020/12/04 16:20] (current) – andonovj
Line 192: Line 192:
  
 As you can see, the "Cell smart Table scan" takes the majority of the time. (2.59 seconds out of 2.80 seconds) As you can see, the "Cell smart Table scan" takes the majority of the time. (2.59 seconds out of 2.80 seconds)
 +
 +<Code:bash|Smart Scan Monitoring>
 +SQL> col event format a35
 +SQL> select event, total_waits,
 +  2  time_waited/100 wait_secs, average_wait/100 avg_wait_secs
 +  3  from v$system_event where event like 'cell%';
 +
 +EVENT     TOTAL_WAITS  WAIT_SECS AVG_WAIT_SECS
 +----------------------------------- ----------- ---------- -------------
 +cell smart table scan    9992      164.9    .0165
 +cell statistics gather     384        .32    .0008
 +cell smart file creation   12855      78.46    .0061
 +cell single block physical read   13292      41.39    .0031
 +cell multiblock physical read    3354      38.98    .0116
 +cell list of blocks physical read      23        .77    .0334
 +
 +6 rows selected.
 +
 +Elapsed: 00:00:00.06
 +SQL> 
 +</Code>
  • oracle_exadata_monitoring.1607093902.txt.gz
  • Last modified: 2020/12/04 14:58
  • by andonovj