Excessive Hard Parsing after migration 10g => 11g (New AIX server)
Hi ,
Is it normal to have 31,6% DB time of hard parsing ?
Any idea ( scripts to monitor hard parsing , bind variables , cursors behavior ...) to resolve this issue in 11.2.0.4 : after migration via exp/imp from 10g to 11g on a new AIX server ?
possible root causes ?
Best regards.
GD.
Time Model System Stats DB/Inst: ADMINST Snaps: 1975-1985
-> Ordered by % of DB time desc, Statistic name
Statistic Time (s) % DB time
----------------------------------- -------------------- ---------
sql execute elapsed time 3,251.1 99.5
DB CPU 1,414.6 43.3
parse time elapsed 1,057.4 32.4
hard parse elapsed time 1,031.6 31.6
PL/SQL execution elapsed time 221.6 6.8
repeated bind elapsed time 2.7 .1
sequence load elapsed time 2.1 .1
hard parse (sharing criteria) elaps 1.2 .0