Originally posted by quester
This only applies on the local machine, right? Not for the entire server....in which case alter session can do. I needed to change on the database level, not on the local machine or session.
At database level, modify init.ora and bounce the instance. You can't change it on fly.

Sanjay