zOs/WK/OPTHISEL

delete
    from oa1p.tQZ081OptHintPlan
    where explain_time = '2014-08-29-00.00.00.000000'
;X;
with p as
(
  select explain_time, count(*) cPlan
    from oa1p.tQZ081OptHintPlan p
    group by explain_time
)
, j as
( select value(q.explain_time, p.explain_time) explain
       , case when q.explain_time is null then 0 else 1 end cQuery
       , case when p.explain_time is null then 0 else cPlan end cPlan
       , q.desc
    from oa1p.tQZ080OptHintQuery q
      full outer join p
        on q.explain_time = p.explain_time
)
select min(explain) explain_min
       , microSecond(max(explain)) max
       , sum(cQuery) cQuery
       , sum(cPlan) cPlan
       , desc
       , max(explain) explain_max
    from j
    group by trunc_timestamp(explain, 'ss'), desc
    order by 1 desc, desc
;
select e from q
    order by 1 desc
;x;
    group by trunc_timestamp(explain_time, 'sec'), desc
)
, p as
( select explain_time, count(*) cPlan
    from oa1p.tQZ081OptHintPlan
    group by explain_time
)
select value(p.explain_time, q.explain_time), cPlan
        , cQuery, desc, descTo
    from q full outer join p
      on p.explain_time = q.explain_time
    order by 1 desc
;
with q as
( select min(explain_time) explain_min
       , max(explain_time) explain_max
       , count(*) cQuery
       , desc
    from oa1p.tQZ080OptHintQuery
    group by trunc_timestamp(explain_time, 'sec'), desc
)
with q as
( select explain_time, count(*) cQuery, min(desc) desc, max(desc) descTo
    from oa1p.tQZ080OptHintQuery
    group by explain_time
)
, p as
( select explain_time, count(*) cPlan
    from oa1p.tQZ081OptHintPlan
    group by explain_time
)
select value(p.explain_time, q.explain_time), cPlan
        , cQuery, desc, descTo
    from q full outer join p
      on p.explain_time = q.explain_time
    order by 1 desc
;
select *
    from oa1p.tQZ080OptHintQuery
    order by explain_time desc
;
commit
;x;
select *
    from oa1p.tQZ081OptHintPlan
    order by explain_time desc
;
commit
;x;
update oa1p.tQZ081OptHintPlan set explain_time = bind_time
    where explain_time is null
        or explain_time < '1111-11-11-11.11.11'
;
delete from oa1p.tQZ080OptHintQuery
    where explain_time in ('2014-08-08-15.44.50.000000'
                          ,'2014-08-06-16.23.11.000000')
;
delete from oa1p.tQZ081OptHintPlan
    where explain_time in ('2014-08-08-15.44.50.000000'
                          ,'2014-08-06-16.23.11.000000')
;
rollback
;x;
update OA1P.TQZ080OptHintQuery set query_text = ''
;
xelete from OA1P.TQZ080OptHintQuery
   where  explain_time = '2014-08-06-16.23.48.000000'
;
xelete from OA1P.TQZ081OptHintPlan
   where  explain_time = '2014-08-08-19.27.49.000000'
;
xpdate OA1P.TQZ080OptHintQuery
     set  explain_time = '2014-08-06-16.23.48.000000'
   where  explain_time = '2014-08-08-19.27.49.000000'
;