Chris,
I did but nothing significant change happend and even though I did restarted the db instances after that.
I am thinking of removing or droping temp tablespace and recreating it. But when I looked that table space dependencies I saw sys, system and Oracle Management Users are using that table space. I wondered removing that table space may effect running oracle database or I might
screwed up with oracle database.

Any thoughts.

SKM