Oracle Database (10gR2) Setup Queries
SELECT * FROM global_name; 

SELECT * FROM v$database;

SELECT * FROM v$version;  --> Version

SELECT host_name FROM v$instance;

SELECT * FROM v$thread;

SELECT * FROM v$option;

SELECT * FROM v$parameter;

SELECT * FROM v$parameter2;

SELECT parameter, value FROM nls_session_parameters; --> NLS Session Parameters

SELECT parameter, value FROM nls_instance_parameters; --> NLS Instance Parameters

SELECT parameter, value FROM nls_database_parameters; --> NLS Database Parameters


SELECT parameter, value FROM v$nls_parameters; --> NLS Parameters


SELECT * FROM database_properties ORDER BY property_name; --> Database Properties

SELECT * FROM product_component_version; --> Product Component Version

Oracle registered trademark of Oracle Corporation.

Last Revised On: November 08, 2013

  3104