跳过导航

Enhancement of Performance page in OEM for SQL

得分 20
您尚未投票。 Active

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

评论