10053 Trace || dbms_sqlidiag
From: Krishnaprasad Yadav <chrishna0007_at_gmail.com>
Date: Mon, 28 Mar 2022 12:11:02 +0530
Message-ID: <CAO8FHeU=P4rnkp+qTwYC4QW+ki7zyyisNiErWtjejtFGSjm-UQ_at_mail.gmail.com>
Hi Experts ,
);
end;
/
Date: Mon, 28 Mar 2022 12:11:02 +0530
Message-ID: <CAO8FHeU=P4rnkp+qTwYC4QW+ki7zyyisNiErWtjejtFGSjm-UQ_at_mail.gmail.com>
Hi Experts ,
Please let us know what value we need for p_component to use for generating 10053 when we use the dbms_sqldiag package.
begin
dbms_sqldiag.dump_trace ( p_sql_id => '…' , p_child_number => … , p_component => 'Optimizer', -- or 'Compiler' ====? p_file_id => 'CBO_TRACE'
);
end;
/
During the issue time a query plan is changed and causes a huge pile in the database , which P_component is preferred to get 10053 trace to get cause of plan change
Regards,
krishna
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 28 2022 - 08:41:02 CEST