A package runt for 4hours in PROD and 4 minutes in TEST

11.2.0.2

Hi,

We have a package which runs during our batch. In test the packages takes four minutes and in prod it takes four hours. There are two SQL:s that sticks out. One of them have the exact execution plan in both prod & test. The second SQL differe a little. The ONLY thing that differs is:

PROD runs index full scan index (unique)
and
TEST runs index fast full scan index (unique).

The table has less then 1000 rows.

The rest of the execution plan is the same.

Running the queries one by one goes fine.

I tried to trace the PROD but as the query takes four hours...the trace file was 1.5GB after 10 minutes. I checked the waits during the execution and I see alot of