I tried to run the query it never came back, but one significant thing i see is CPU utilazation was 100%.

When I killed the session, CPU utilization was back to normal 2 to 3%.
I wonder this strange behaviour.

BTW, plan for the above 2 queries are same ( Every fixed table going for table scan ), so thers no Q of index being used or not.

Abhay.