Hi,

I have a 250 lines query with lot of joins developed by our BO team for one of the BO reports. I tried to generate explain plan for that query but it just simply hanging there.

So, I stopped that and started generating explain plan with 10053 trace. It is running since last one and half hour and the trace file is now 50MB.

As I am using 10053 first time, I have no idea how much time it will take (but I am sure it should not be more than one and half hour). Any comments will be much appreciated.

Thanks,