In Oracle 11g , we are experiencing a rare situation as :
I am inserting millions of records in a sequence of tables and issues commit immediately after each table insert.
In the next step I am querying those tables joining multiple tables from the above inserted ones, and we observed that the query takes long time to execute and mostly fails.
To my surprise, these same queries performs perfectly well after some hours.
Can somebody explain the reasons for this ?