Here's one of mine, Connor... SQL> select to_char(min(logon_time),'DD/MM/YYYY HH24:MI:SS') started, 2 round(sysdate-min(logon_time),2) days 3 from v$session; STARTED DAYS ------------------- ---------- 01/02/2012 14:08:27 224.71 SQL> Kellyn Pot'Vin Senior Technical Consultant Enkitec DBAKevlar.com RMOUG Director of Training Days 2013 ~Tombez sept fois, se relever huit! ________________________________ From: Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx> To: oracle-l <oracle-l@xxxxxxxxxxxxx>; mcdonald.connor@xxxxxxxxx Sent: Thursday, September 13, 2012 5:26 AM Subject: Re: uptime We are on x64 Windows and we NEVER restart our servers. >>> Connor McDonald <mcdonald.connor@xxxxxxxxx> 9/13/12 12:32 AM >>> Hi all, I need to convince a client that they dont need restart their Oracle db (and their Windows server) every night. Can anyone send me: select to_char(min(logon_time),'DD/MM/YYYY HH24:MI:SS') started, round(sysdate-min(logon_time),2) days from v$session for any long-in-the-tooth Windows server they've got... Thanks, Connor -- Connor McDonald =========================== blog: connormcdonald.wordpress.com web: http://www.oracledba.co.uk "If you are not living on the edge, you are taking up too much room." - Jayne Howard -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l