Oracle Database Options Report
Displays all Oracle database options and their installation status. Useful for checking which Oracle features are enabled or available in the current database instance.
oraclesqlreporting-analyticsv1.0.0
0 stars0 downloads15 views0 comments
By OracleDba • Created
Code
(14 lines)1234567891011121314
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/options.sql
-- Author : Tim Hall
-- Description : Displays information about all database options.
-- Requirements : Access to the V$ views.
-- Call Syntax : @options
-- Last Modified: 12/04/2013
-- -----------------------------------------------------------------------------------
COLUMN value FORMAT A20
SELECT *
FROM v$option
ORDER BY parameter;