Originally posted by balajiyes
Hi Guys thanks for ur effort

My boss gave this query and wanted me to tune. I don't understand any thing...
Then it would benefit you to rewrite it using the advice I gave you above, and then test that query and see if the explain plan changed. By the way you are using manual undo and archivelog is turned off. You might want to do some research and change to automatic undo and turn on archivelog.