Saturday, May 9, 2020

How to check installed components and options in Oracle

How to check installed components and options in Oracle


To check which components are installed in a database:
SELECT * FROM DBA_REGISTRY;

To check which options are enabled:
SELECT * FROM V$OPTION;

To check which features are used:
SELECT * FROM DBA_FEATURE_USAGE_STATISTICS;

No comments:

Post a Comment