Database Tuning (MOSC)

MOSC Banner

wrong table

edited Jun 30, 2011 12:06AM in Database Tuning (MOSC) 4 commentsAnswered
 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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center