记录下查看oracle的开机时间

SELECT
to_char(startup_time, 'YYYY-MM-DD HH24:MI:SS') AS "启动时间",
trunc(sysdate - startup_time) AS "运行天数",
trunc(mod(sysdate - startup_time,1)*24) AS "运行小时数",
trunc(mod(sysdate - startup_time,1)*24*60) AS "运行分钟数"
FROM
v$instance;