This content has been marked as final. Show 2 replies
dbaing wrote:Documents are self explanatory
In Oracle document:
DBA_REGISTRY displays information about the components loaded into the database
V$OPTION lists options that are installed with the Oracle server.
But I still don't quite get it. Anyone can explain?
Source -> http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2009.htm
V$OPTION This view lists database options and features. Typically, although not always, options must be separately purchased and installed, whereas features come with the product and are enabled based on the product that is running (Standard Edition, Enterprise Edition, or Personal Oracle). If you want to see a list of all installed options for the database, use the DBA_REGISTRY view.