2 Replies Latest reply: Apr 19, 2013 8:46 AM by User477708-OC RSS

    know which components having licence in database

    cherrydba
      Hi

      I am using 11.2.0.1 database on windows 2008 server. I would like to know which are all the tools/components that have licences to use in my database.
      Can i get licence information through any query?

      Thanks in Advance
      Bala
        • 1. Re: know which components having licence in database
          Mark D Powell
          Modern Oracle comes with a lot of extra-cost features enabled in the database by default (AWR for instance). What was purchased, what was installed, and what has been used are often different and the only way to really know what was purchased is to look at a copy of your CSI's.

          You can query dba_registry to if major components are installed in the database and you can query dba_feature_usage_statistics to see if specific features have been used.

          HTH -- Mark D Powell --

          PS - To determine which Oracle components need a separate license see the following
          http://download.oracle.com/docs/cd/B19306_01/license.102/b14199/toc.htm
          http://download.oracle.com/docs/cd/E11882_01/license.112/e10594/editions.htm#sthref192

          Edited by: Mark D Powell on Apr 19, 2013 6:17 AM
          • 2. Re: know which components having licence in database
            User477708-OC
            Bala T wrote:
            Hi

            I am using 11.2.0.1 database on windows 2008 server. I would like to know which are all the tools/components that have licences to use in my database.
            Can i get licence information through any query?

            Thanks in Advance
            Bala
            Are you asking what do you have licenced for use or what different features need a licence independent of whether youve got one or not?

            the only way to know if youre licenced is to check the invoice on the licence when you purchased from oracle, if you dont have this piece of paper, consult your local friendly oracle sales guy but be prepared to be audited shortly after so make sure your house is in order before you do this.

            to know what youve used before check the ever unreliable dba_features_usage table but this can be confusing as Oracle uses some features internally that trigger some usages here.

            other than that, to see what needs a licence...
            http://docs.oracle.com/cd/B28359_01/license.111/b28287/editions.htm#CJACGHEB