Home » RDBMS Server » Server Administration » Oracle Licensing (11.2.0.3,Linux X86_64)
Oracle Licensing [message #628115] Thu, 20 November 2014 04:23 Go to next message
preet_kumar
Messages: 199
Registered: March 2007
Senior Member
I realized that on our Production system the Tuning Pack was enabled which we never used and i have now disabled it changing parameter control_management_pack_access
But still the view dba_feature_usage_statistics shows the statistics and used column as YES.

Is there any option to remove this statistics.Does it need a Database restart ?
Re: Oracle Licensing [message #628131 is a reply to message #628115] Thu, 20 November 2014 05:13 Go to previous messageGo to next message
John Watson
Messages: 7255
Registered: January 2010
Location: Global Village
Senior Member
You could try deleting rows from the dictionary tables that populate the view, if you look at the view creation statement in catdbfus.sql you'll see what they are. I have no idea how dangerous that would be.
I don't see any point, though. You say that you have not done anything illegal, so what's the problem?
Re: Oracle Licensing [message #628133 is a reply to message #628115] Thu, 20 November 2014 05:17 Go to previous messageGo to next message
Michel Cadot
Messages: 65380
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Further more the view show how many times the feature has been used and when it was first and last used.
So if you had never used it there is no problem.

Re: Oracle Licensing [message #628136 is a reply to message #628133] Thu, 20 November 2014 05:48 Go to previous messageGo to next message
preet_kumar
Messages: 199
Registered: March 2007
Senior Member
Name Detected Usage
----------------------- --------------
Automatic SQL Tuning Advisor 50
EM Performance Page 48
SQL Monitoring and Tuning pages 1

Detected Usage > 1 and i see the above Names.To which pack do they belong and if i need license for them ?
Re: Oracle Licensing [message #628140 is a reply to message #628136] Thu, 20 November 2014 06:10 Go to previous messageGo to next message
Michel Cadot
Messages: 65380
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

When they have been used? If it was long ago, Oracle will not bother with that.
Otherwise, yes, you have to buy the Performances and Tuning pack.

Re: Oracle Licensing [message #628142 is a reply to message #628136] Thu, 20 November 2014 06:15 Go to previous messageGo to next message
gazzag
Messages: 908
Registered: November 2010
Location: Bristol, UK
Senior Member
If you no longer use them, I wouldn't worry.
Re: Oracle Licensing [message #628143 is a reply to message #628142] Thu, 20 November 2014 06:20 Go to previous messageGo to next message
preet_kumar
Messages: 199
Registered: March 2007
Senior Member
Does that help

update dba_feature_usage_statistics set DETECTED_USAGES=0 where name = 'Automatic SQL Tuning Advisor';
Re: Oracle Licensing [message #628144 is a reply to message #628143] Thu, 20 November 2014 06:23 Go to previous message
gazzag
Messages: 908
Registered: November 2010
Location: Bristol, UK
Senior Member
I would not recommend it.
Previous Topic: list materialized views that are rebuilding at this moment
Next Topic: Monitoring Export Backup
Goto Forum:
  


Current Time: Sun Feb 18 18:09:32 CST 2018

Total time taken to generate the page: 0.02386 seconds