I do not see CARD, CPU values from the explain plan?

Did you analyze all tables and indexes?

Use this method:

delete from plan_table
/

explain plan for
select .......

select * from table(dbms_xplan.display)
/

When you post, use tag so that your writings will be formatted.

What is the value for optimizer_max_permutation?