This content has been marked as final. Show 2 replies
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
Edited by: Mark D Powell on Apr 19, 2013 6:17 AM
1 person found this helpful
Bala T wrote: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?
I am using 18.104.22.168 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
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...