Borndba

if you have used OEM, then you should have used sql tuning advisor. Sometime if the plan is very large you will not be able to implement the profile. You will get message like,
“There was a problem creating the SQL Profile setString can only process strings of less than 32766 chararacters”

Instead of implementing via OEM, use the below script to force the profile. But remember the tuning name what you have generated.

begin
dbms_output.put_line(
dbms_sqltune.accept_sql_profile(
task_name => 'sql_tuning_xyz',
name => 'manual_forcing',
replace => true,
force_match => true
)
);
end;
/

convert this post to pdf.