Since last 6 months it was running ok..But suddenly since last two days it has started running long.
We have not changed any thing..

We have enough memory 8G RAM on sun sparc os 7.
Enough memory to oracle ver 8.1.7.3 also with SHMMAX 4G.

Thanks

Sanjay