wrong table
Hi,
Can somebody modify below script so that I can run in 10.2.0.4?I am getting below error:
SQL> select
2 substr(n_major, 3) major,
3 substr(n_minor, 3) minor,
4 wait_event,
5 round(time/100) seconds,
6 substr(to_char(100 * ratio_to_report(time) over (), '99.00'), 2) || '%' pct
7 from
8 (
9 select /*+ ordered use_hash(b) */
10 '1 CPU time' n_major,
11 decode(t.ksusdnam,
12 'redo size', '2 reloads',
13 'parse time cpu', '1 parsing',
14 '3 execution'
15 ) n_minor,
16 'n/a' wait_event,
17 decode(t.ksusdnam,
18 'redo size', nvl(r.time, 0),
19 'parse time cpu', t.ksusgstv - nvl(b.time, 0),
20 t.ksusgstv - nvl(b.time, 0) - nvl(r.time, 0)
SQL> select
2 substr(n_major, 3) major,
3 substr(n_minor, 3) minor,
4 wait_event,
5 round(time/100) seconds,
6 substr(to_char(100 * ratio_to_report(time) over (), '99.00'), 2) || '%' pct
7 from
8 (
9 select /*+ ordered use_hash(b) */
10 '1 CPU time' n_major,
11 decode(t.ksusdnam,
12 'redo size', '2 reloads',
13 'parse time cpu', '1 parsing',
14 '3 execution'
15 ) n_minor,
16 'n/a' wait_event,
17 decode(t.ksusdnam,
18 'redo size', nvl(r.time, 0),
19 'parse time cpu', t.ksusgstv - nvl(b.time, 0),
20 t.ksusgstv - nvl(b.time, 0) - nvl(r.time, 0)
0