Australia photo & PC memo

Data Dictionary:

V$SHARED_SERVER_MONITOR
V$DISPATCHER
V$SHARED_SERVER
v$CIRCUIT

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';