Instance Info

System Properties

select * from SYS.PROPS$;

Instance Info

SELECT *
  FROM v$instance;