Cool.. Thanks onceagain..
I am very clear now.
Since the answers were betn dynamic and static changes I was hoping to use alter system/session commands..
If it is init.ora it has to be bounced.

How do we check the performance after changes??

Any ideas? (Should we run a big job etc.,)..