Ran in minutes in 11GR2 now takes hours in 12.1.0.2
We use QlikView to extract data from our E Business Suite database and have been doing so successfully for a while. However since I upgraded the database to 12c one or two of the extracting jobs are no longer completing.
I have run Gather Schema Stats and Even Gather Table Stats through the application (FND_STATS) and this hasn't made a difference. As far as I am aware the database startup parameters haven't changed.
What advise would you give to troubleshoot a poorly performing query in 12c. Are there any new features to simplify the process?