Thank you so much for all your inputs.

Unfortunately, we will be running on 8i for a while before upgrading to 9i to take advantage of the MAX_ESTIMATED_EXEC_TIME.

Tamilselvan,
If you have an idea how to do it, I will be glad to see your procedures. Thank you in advance!

My boss said you guys are wonderful and that we should cancel the Oracle Support and pay you guys instead!!

Just wonder... are you guys (advisors & moderators) doing this full-time? I mean giving technical advice. I found you all have great Oracle knowledge and give excellent advice. Your help is greatly appreciated.