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