Oracle day2day db information queries

oracle-day2day.sql

-- db version and other information

SELECT * FROM V$VERSION;

SELECT * FROM PRODUCT_COMPONENT_VERSION;

SELECT SYS_CONTEXT('USERENV','SERVICE_NAME') FROM DUAL;

SELECT * FROM GLOBAL_NAME;

-- database instance, host name, version, status, startup time etc.	
SELECT * FROM V$INSTANCE;

SELECT * FROM V$PARAMETER;

SELECT * FROM V$SESSION;

-- get the list of sql statements executed & executing*. 
SELECT * FROM V$SQL ORDER BY LAST_LOAD_TIME DESC;

-- Database time zone and system date
SELECT DBTIMEZONE, SYSDATE FROM DUAL;