Instance Info

System Properties

select * from SYS.PROPS$;

Instance Info

SELECT *
FROM v$instance;