No, it's not collecting stats. It's actually running your query, just not displaying results. That's the way AUTOTRACE works. If you just want the explain plan, use:
and then run a query over your plan_table.Code:explain plan set statement_id = 'foo1' for select * from xyz




Reply With Quote