Hi, Guys
I am trying to find out when Oracle change its time when time in OS was changed. As I can see it chanes time only when you reconnect.

Any ideas are very wellcome.
=============================

SVRMGR> select to_char(sysdate,'SS.MI.HH24 DD/MM/YYY') from dual;
TO_CHAR(SYSDATE,'S
------------------
05.45.14 05/07/002
1 row selected.
[oracle@mci oracle]$ date
Fri Jul 5 14:45:20 GMT 2002
[oracle@mci oracle]$ exit
exit
SVRMGR> select to_char(sysdate,'SS.MI.HH24 DD/MM/YYY') from dual;
TO_CHAR(SYSDATE,'S
------------------
25.45.14 05/07/002
1 row selected.

*********** Time changed, but Oracle does not ********

[oracle@mci oracle]$ date
Fri Jul 5 15:50:23 IST 2002
[oracle@mci oracle]$ exit
exit
SVRMGR> select to_char(sysdate,'SS.MI.HH24 DD/MM/YYY') from dual;
TO_CHAR(SYSDATE,'S
------------------
38.50.14 05/07/002
1 row selected.
SVRMGR> !
[oracle@mci oracle]$ date
Fri Jul 5 15:50:44 IST 2002

=== New session ==================================================

SVRMGR> connect internal;
Connected.
SVRMGR> select to_char(sysdate,'SS.MI.HH24 DD/MM/YYY') from dual;
TO_CHAR(SYSDATE,'S
------------------
40.53.15 05/07/002
1 row selected.
SVRMGR> !
[oracle@mci oracle]$ date
Fri Jul 5 15:53:43 IST 2002