Hi, although I’ve been using TOAD for Oracle for many years now, I’m not sure how to turn off the usage of all the options and possibilities that needs the license for diagnostic+tuning …
Please give me a desciption how to do it.
So many thanks in advance!
Best regards,
To.Ni.
Go to Options -> Windows. Find the ones with (OEM) in the name and uncheck them in the “Available” column. That will remove them from the menu.
Hi John, thank you! So, the meaning of “OEM” is not Oracle Enterprise Manager?
It is. Probably something like (Oracle Licensed Feature) would be a better description, but that’s a little long.
Okay. Thank you!
Viele Grüße / best regards
Torsten
Von: John Dorlon [mailto:bounce-jdorlon@toadworld.com]
Gesendet: Mittwoch, 22. November 2017 15:46
Betreff: RE: [Toad for Oracle - Discussion Forum] HOWTO - disable diagnostic and tuning options
RE: HOWTO - disable diagnostic and tuning options
Reply by John Dorlon
It is. Probably something like (Oracle Licensed Feature) would be a better description, but that’s a little long.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Afternoon All.
While you are disabling Toad from using Enterprise Edition extra cost options, did you know that the database silently enables some too?
I always run the following on new databases where we don’t want any surprises at audit time:
–=============================================
– ALWAYS Turn off extra cost options
– to get around Oracle licencing sneakiness!
–=============================================
alter system set control_management_pack_access=‘NONE’ scope=spfile;
alter system set enable_ddl_logging=false scope=both;
Reboot required afterwards.
The first turns off diagnostic and tuning in the database where it is enabled by default and the second turns off some other option who’s name escapes me at the moment. 
Cheers,
Norm.
–
Sent from my Android device with K-9 Mail. Please excuse my brevity.
@Norm,
Thx for this nice info-appreciated
Damir