OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle Licensing (11.2.0.3,Linux X86_64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Licensing [message #628115]

Thu, 20 November 2014 04:23

preet_kumar
Messages: 204
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 ?

Report message to a moderator

Re: Oracle Licensing [message #628131 is a reply to message #628115]

Thu, 20 November 2014 05:13

John Watson
Messages: 8996
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?

Report message to a moderator

Re: Oracle Licensing [message #628133 is a reply to message #628115]

Thu, 20 November 2014 05:17

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Oracle Licensing [message #628136 is a reply to message #628133]

Thu, 20 November 2014 05:48

preet_kumar
Messages: 204
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 ?

Report message to a moderator

Re: Oracle Licensing [message #628140 is a reply to message #628136]

Thu, 20 November 2014 06:10

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Oracle Licensing [message #628142 is a reply to message #628136]

Thu, 20 November 2014 06:15

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

If you no longer use them, I wouldn't worry.

Report message to a moderator

Re: Oracle Licensing [message #628143 is a reply to message #628142]

Thu, 20 November 2014 06:20

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

Does that help

update dba_feature_usage_statistics set DETECTED_USAGES=0 where name = 'Automatic SQL Tuning Advisor';

Report message to a moderator

Re: Oracle Licensing [message #628144 is a reply to message #628143]

Thu, 20 November 2014 06:23

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

I would not recommend it.

Report message to a moderator

Previous Topic:	list materialized views that are rebuilding at this moment
Next Topic:	Monitoring Export Backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 18 17:32:55 CST 2026