I have worked on Explain Plan before to add indexes for multi join queries.
For eg :
explain plan for
select * from mytable;
select * from
table(dbms_xplan.display);
Usually the above statements will give the plan of mytable.
But in this new database which I started working the output shows as some other log table instead of the table I give in explain plan.
Please advise.