col STARTUP_TIME for a19 col VERSION for a11 col DB_NAME for a8 col INSTANCE_NAME for a15 col HOST_NAME for a12 select INSTANCE_NUMBER, to_char(STARTUP_TIME, 'DD/MM/YYYY HH24:MI:SS') as STARTUP, VERSION, DB_NAME, INSTANCE_NAME, HOST_NAME from DBA_HIST_DATABASE_INSTANCE order by STARTUP_TIME;