Well, looking in v$instance in Oracle 8i is the easiest way of all.

I just wondered how it was done from v$Instance in Oracle 7 - and I too learnt a little more about data handling.

Why not just run:

select min(to_char(LOGON_TIME,'dd-mon-yyyy hh:mi:ss pm'))
from v$session

That's even easier still for Oracle 7... Although once you have a query written, any can be used just as quickly :)

[Edited by TerryD on 11-17-2000 at 12:37 PM]