Forum Stats

  • 3,824,847 Users
  • 2,260,430 Discussions
  • 7,896,330 Comments

Discussions

Enhancement of Performance page in OEM for SQL

raviraushan
raviraushan Member Posts: 2 Green Ribbon
edited May 27, 2020 6:49AM in Database Ideas - Ideas

Hi,

Currently when we monitor the performance from OEM for top sqls under performance tab or search the specific sql to check the performance it doesn't provide granular input on sql performance (say on which line of the plan it spent most of the time or on which objects it spent more time or event experienced by each line etc).If these additional information can be in-corporate when we click to check the individual sqls it will be good starting point to troubleshoot any sql performance issue. These information can be pulled from gv$active_session_history or dba_hist_active_sess_history view.

Thanks & Regards,

Ravi Raushan

raviraushanthisissanjeeva
2 votes

Active · Last Updated