2 Replies Latest reply: Apr 12, 2012 8:27 AM by user88831 RSS

    difference between v$option and dba_Registry

    user88831
      Hi Guys,

      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?

      thanks
        • 1. Re: difference between v$option and dba_Registry
          912595
          dbaing wrote:
          Hi Guys,

          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?

          thanks
          Documents are self explanatory
          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. 
          Source -> http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2009.htm
          • 2. Re: difference between v$option and dba_Registry
            user88831
            thanks. Understand that partitioning is an option. I see it in v$option but not dba_Registry. kindly advise.