How to select sysdate of remote database

[DaPi]

. . . so let's look in memory.


a) does anyone know if elapsed time since v$instance.startup_time is stored anywhere?


b) VERY NASTY workaround - far from being bomb-proof:

IF you can uniquely identify the row in v$session (without using SYS_CONTEXT!) that belongs the the current session, e.g. by user & being remote:

 drop database link remote;  -- must be v.recent connection

create database link remote
connect to scott identified by tiger
using 'ORCL';

select to_char(logon_time, 'DD-MON-YYYY HH24:MI:SS') 
from v$session@remote
where osuser = 'NT AUTHORITY\SYSTEM'  -- under NT this is a remote connection
and   username = 'SCOTT';

It's a knotty problem . . .