-
Notifications
You must be signed in to change notification settings - Fork 2
/
ostat_tabscan.sql
34 lines (33 loc) · 1.38 KB
/
ostat_tabscan.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
set serveroutput on
col "Table Fetch/Scan" format a200
set arraysize 1
select output "Table Fetch/Scan" from table( pipe_ostat.pipe_xdiff(' with s as (select name,value from v$sysstat )
select name , decode(name,
''table fetch by rowid'' ,''FthByRowid'',
''table fetch continued row'' ,''FthContdRow'',
''table scan blocks gotten'' ,''BlksGot'',
''table scan disk IMC fallback'' ,''DskIMCFback'',
''table scan disk non-IMC rows gotten'' ,''DskNonIMCRows'',
''table scan rows gotten'' ,''RowsGot'',
''table scans (cache partitions)'' ,''(cache part)'',
''table scans (direct read)'' ,''(direct read)'',
''table scans (IM)'' ,''(IM)'',
''table scans (long tables)'' ,''(long tables)'',
''table scans (rowid ranges)'' ,''(rowid ranges)'',
''table scans (short tables)'' ,''(short tables)'',
name) display_name ,value ,''YES'' show ,''YES'' cumulative ,'''' formula from s where s.name in (
''table fetch by rowid'',
''table fetch continued row'',
''table scan blocks gotten'',
''table scan disk IMC fallback'',
''table scan disk non-IMC rows gotten'',
''table scan rows gotten'',
''table scans (cache partitions)'',
''table scans (direct read)'',
''table scans (IM)'',
''table scans (long tables)'',
''table scans (rowid ranges)'',
''table scans (short tables)''
)
',sample_cnt=>10000 ,SAMPLE_INTERVAL=>1 ,column_width=>5 ,debug=>0));
--',sample_cnt=>99999 ,SAMPLE_INTERVAL=>1 ,column_width=>8 ,debug=>0));