And post here the generated execution plan together with its predicate part.
1. alter session set statistics_level=ALL; 2. execute your query; 3. select * from table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST'));
What would be the difference between what you asked, and what i did ?display_awr gets historical plans from awr - not something that is obviously relevant yet.
Edited by: Dom Brooks on Nov 13, 2012 1:36 PM
SELECT * FROM dba_hist_active_sess_history h WHERE sql_id = '<your sql id>' ORDER BY sample_time DESC;
We solve the things out;Prove it.
That was a bad index, we had to HINT for another index.