Query Tuning -- Dba Style

explain plan for ....

select * from table(dbms_xplan.display());

select * from dba_tables where table_name in ('C_HDR_PARENT_TB','C_LI_TB');
select * from dba_indexes where table_name in ('C_HDR_PARENT_TB','C_LI_TB');