We have a complicated SQL which involves many joins and views. Each time the hard parse takes around 1 minute while the execution is only 10+ seconds. How can I stop the hard parse from happening? I tried creating a sql baseline and set it to "fixed", but the hard parse still happens. I also tried dbms_spm.configure('AUTO_CAPTURE_SQL_TEXT',v_sql_text,FALSE) but the sql text is too big to fit into the varchar2 parameter.