SELECT 
	HOST_NAME,
	INSTANCE_NAME,
	TO_CHAR(STARTUP_TIME,'DD/MM/YYYY HH24:MI:SS') AS STARTUP_TIME ,  
	FLOOR(SYSDATE - STARTUP_TIME) || ' DIAS',
	TO_CHAR(SYSDATE,'DD/MM/YYYY HH24:MI:SS') AS COLETA 
FROM V$INSTANCE;

hostgator