DBAsupport.com : Oracle 9i Central : Oracle Time Zone

select DBTIMEZONE from dual;
ALTER database SET TIME_ZONE = 'UTC';

select SESSIONTIMEZONE from dual;
alter session set TIME_ZONE='-03:00';