This content has been marked as final. Show 5 replies
I don't think this has anything to do with Exadata. There's a bug that has the same symptoms as your case, but it does not have any workaround, nor it is fixed yet.
Are the statistics gathered on your dictionary ?Did you try to force RBO on the query (hint or alter session)?
Yes I have tried using RBO /+RULE/ on the select statement..but still it did not work...Can you please let me know the bug reference number..
The bug is 12355993 (fairly recent one).
Please indicate if the bugnummer stated in this thread is applicable. Then you could flag it as resolved (this thread, not your issue).
A more structural approach to your problem would be to investigate what the 'hanging' session is doing. There's no indication in this thread you did that. Tanel Poder's snapper can be used for this. A modified version with a begin and end snap functionality is snap
From the bug, it seems the query is very slow, taking almost an hour to finish. So it's not hanging.