Database Tuning (MOSC)

MOSC Banner

Discussions

Execution Plan

in Database Tuning (MOSC) 16 commentsAnswered ✓

Dear Experts,

We are on 2 node RAC with version 19.17


1) We need your expertise in understanding event CPU and resmgr:cpu quantum (1)  from attached execution plan.

SELECT dbms_sqltune.report_sql_monitor(sql_id=>'5cmctchhudz7q',sql_exec_id=>16777839,sql_exec_start=> TO_DATE('05-jul-2023 12:22:35','dd-mon-yyyy hh24:mi:ss'),report_level=>'ALL') AS report FROM dual;

2) How can we get the bind variables from SQL monitor output.

Thanks,

SG

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.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center