Home » RDBMS Server » Server Utilities » Disable Oracle Feature (11.2.04 WIndow s 2012 R2)
Disable Oracle Feature [message #679088] Mon, 03 February 2020 09:07 Go to next message
rajesh_b
Messages: 20
Registered: December 2019
Junior Member
Kindly update how to disable below features 


Advanced Compression |Oracle Utility Datapump (Export) |NO_CURRENT_USAGE|2020.02.02_06.44.19|1571512636|11.2.0.4.0 | 2| 4|TRUE |2020.01.26_04.42.05|2020.02.02_06.44.19|compression used: 0 times
Advanced Security    |Oracle Utility Datapump (Export) |NO_CURRENT_USAGE|2020.02.02_06.44.19|1571512636|11.2.0.4.0 | 2| 4|TRUE |2020.01.26_04.42.05|2020.02.02_06.44.19|encryption used: 0 times

I am using below options
EXPDP xxx/xxx@xxxlty  DIRECTORY=BCK_DIR DUMPFILE=backupdev.DMP LOGFILE=backupdev.LOG flashback_time=systimestamp compression=none encryption=none 

Re: Disable Oracle Feature [message #679091 is a reply to message #679088] Mon, 03 February 2020 10:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I'm afraid there are no ways to disable the feature, just do not use the options that activate them.

As the report you showed say, with the options you use, you currently do not use these features.

Re: Disable Oracle Feature [message #679127 is a reply to message #679091] Sat, 08 February 2020 05:37 Go to previous messageGo to next message
rajesh_b
Messages: 20
Registered: December 2019
Junior Member
[code/
Thankyou for the reply.
Eventhough I am not usign it, The Detected usage and current usage has some values and currently used is also TRUE.
Is there is any way to make it as FALSE
[/code]
Re: Disable Oracle Feature [message #679128 is a reply to message #679127] Sat, 08 February 2020 05:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post the query you executed, what I see is "NO_CURRENT_USAGE" and "compression used: 0 times", "encryption used: 0 times".

Re: Disable Oracle Feature [message #679129 is a reply to message #679128] Sat, 08 February 2020 06:31 Go to previous messageGo to next message
rajesh_b
Messages: 20
Registered: December 2019
Junior Member
 options_packs_usage_statistics.sql

---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
------- Name        :  options_packs_usage_statistics.sql
-------                MOS DOC ID 1317265.1

MC: copyrighted script removed

[Updated on: Sat, 08 February 2020 07:27] by Moderator

Report message to a moderator

Re: Disable Oracle Feature [message #679130 is a reply to message #679129] Sat, 08 February 2020 07:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please do not post copyrighted materials.

What is important are the parts I pointed.

Re: Disable Oracle Feature [message #679132 is a reply to message #679130] Sat, 08 February 2020 23:31 Go to previous messageGo to next message
rajesh_b
Messages: 20
Registered: December 2019
Junior Member
It is using DBA_FEATURE_USAGE_STATISTICS  , but I didnt see the advanced compression and advanced security options when I query the view directly. It only shows Oracle Utility datapumt (Export) and (Import)


SQL> select name,detected_usages,currently_used,last_usage_date,description,feature_info from DBA_FEATURE_USAGE_STATISTICS order by name;

NAME                              DETECTED_USAGES|CURRENTLY_USED|LAST_USAGE_DATE|DESCRIPTION |FEATURE_INFO
-----------------------------|---------------    |--------------|---------------|------------|
Oracle Utility Datapump (Export) |  3|TRUE       |2020.02.09_06.46.38|Oracle Utility Datapump (Export) has been used.|Oracle Utility Datapump (Export) invoked: 24 times, compression used: 0 times, e


But the query which I am using is poviding the advanced compression 

Advanced Compression |Oracle Utility Datapump (Export)|NO_CURRENT_USAGE  2020.02.09_06.46.38|1571512636|11.2.0.4.0 |  3| 5|TRUE|2020.01.26_04.42.05|2020.02.09_06.46.38|compression used: 0 times

[Edit MC: MOS query removed]

[Updated on: Sun, 09 February 2020 00:37] by Moderator

Report message to a moderator

Re: Disable Oracle Feature [message #679133 is a reply to message #679132] Sun, 09 February 2020 00:36 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I told you to NOT post copyrighted materials.

And I told you (twice) that there is no problem.
If you don't understand the query you use and its output then don't use it.

Previous Topic: Permission denied while scanning ASM disks
Next Topic: Parfile expdp problem
Goto Forum:
  


Current Time: Thu Mar 28 13:42:39 CDT 2024