| AWR - licensing question [message #515599] |
Tue, 12 July 2011 05:43  |
 |
piotrtal
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa
|
Senior Member |
|
|
Hi,
I was supprised to read about licencing AWR in Oracle. I didn't know that it needs purchase additional licence for OracleTuningPack.
I supposed that if I use AWR on the package level (you know: executing snap procedures, select data from views, etc.) oracle don't need from me purchasing additional licence for this functionality.
we have Oracle 11g Engerprise Edition, and from the begining there was AWR installed and snapshoot was done every 30 minutes. I didn't realize that. I even did once a awrreport.
so what this means? i am uncompliant with oracle licencing now? should i disable this every 30 minutes snapshoting? should i purge some data from my AWR activity from the internall tables?
what is you experience with this topic. what have you done?
thanks.
|
|
|
|
| Re: AWR - licensing question [message #515601 is a reply to message #515599] |
Tue, 12 July 2011 05:57  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:I supposed that if I use AWR on the package level (you know: executing snap procedures, select data from views, etc.) oracle don't need from me purchasing additional licence for this functionality.
You suppose wrong, if you use ANY feature of AWR you need to purchase the pack.
Quote:we have Oracle 11g Engerprise Edition, and from the begining there was AWR installed and snapshoot was done every 30 minutes. I didn't realize that.
You can collect, this is free, but you cannot have a look to what you collected.
Quote:so what this means? i am uncompliant with oracle licencing now?
Quote:I even did once a awrreport
For this later part, yes, you were wrong.
Regards
Michel
[Updated on: Tue, 12 July 2011 05:59] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: AWR - licensing question [message #515618 is a reply to message #515611] |
Tue, 12 July 2011 07:50 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
To be clear, what you are suggesting is basically fraud and if oracle find out they will penalise you for it.
If you want you use AWR you have to pay for the license.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: AWR - licensing question [message #515707 is a reply to message #515660] |
Wed, 13 July 2011 00:38 |
 |
LNossov
Messages: 318
Registered: July 2011
Location: Germany
|
Senior Member |
|
|
You can find the check method for detecting of feature usage so:
SQL> select USG_DET_LOGIC from WRI$_DBU_FEATURE_METADATA
where name ='Automatic Workload Repository';
USG_DET_LOGIC
--------------------------------------------------------------------------------
select count(*), NULL, NULL from wrm$_snapshot
where dbid = (select dbid from v$database) and status = 0 and bitand(snap_flag, 1) = 1
and end_interval_time > (select max(last_sample_date) from wri$_dbu_usage_sample)
If awr snapshots will be created automatically, the flag is 0:
SQL> select distinct bitand(snap_flag, 1)
from wrm$_snapshot;
BITAND(SNAP_FLAG,1)
-------------------
0
Let us create a snapshot manually:
SQL> exec dbms_workload_repository.create_snapshot()
PL/SQL procedure successfully completed.
Then the flag is 1 for this new snapshot and Oracle will detect the feature usage:
SQL> select distinct bitand(snap_flag, 1) from wrm$_snapshot;
BITAND(SNAP_FLAG,1)
-------------------
1
0
So Oracle "can check" and CHECKS.
[Updated on: Wed, 13 July 2011 02:33] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: AWR - licensing question [message #515768 is a reply to message #515758] |
Wed, 13 July 2011 04:02 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
If I understood Oracle licensing, I would be a salesman (and rich) instead of a technician (and broke). But I'll have a go at clarifying this. It is important, because customers can be committed to a lot of expense if their implementation and support consultants tell them to use facilities for which they are not licensed.
Use of the AWR requires the diagnostic and tuning pack, on top of your Enterprise Edition licence. Only then can you look at the AWR views and tables, and run the various APIs. There are also a number of V$ views that are part of these packs. Some of these views (but not all) are listed in the Licensing Information doc which everyone should read,
http://www.oracle.com/pls/db112/to_toc?pathname=license.112%2Fe10594%2Ftoc.htm&remark=portal+%28Books%29
For example, without the packs you may not query v$active_session_history - even though it will be populated.
One problem is that Oracle staff do not always understand licensing. Sometimes, the first thing an Oracle consultant will do on your Standard Edition database is run an AWR report.
To conclude, don't believe anything you hear about licensing from anyone (certainly not me) unless you have it backed up in writing from Oracle. And when in doubt, assume that you can't use it.
|
|
|
|
| Re: AWR - licensing question [message #515770 is a reply to message #515758] |
Wed, 13 July 2011 04:06 |
|
piotrtal
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa
|
Senior Member |
|
|
this is output from my production serwer
SQL> select distinct bitand(snap_flag, 1) from wrm$_snapshot;
BITAND(SNAP_FLAG,1)
-------------------
0
so if we are talking not to use awr packages to be licence compliant - i am good.
i din't make snapshoot manually but they are done by the job internaly (every one hour)
SQL> SELECT snap_id, begin_interval_time FROM
2 (
3 SELECT * FROM DBA_HIST_SNAPSHOT
4 ORDER BY snap_id DESC
5 )
6 WHERE ROWNUM < 10
7 ;
SNAP_ID BEGIN_INTERVAL_TIME
---------- ---------------------------------------------------------------------------
3849 11/07/13 10:00:23,853
3848 11/07/13 09:00:10,782
3847 11/07/13 08:00:57,687
3846 11/07/13 07:00:44,421
3845 11/07/13 06:00:31,329
3844 11/07/13 05:00:18,222
3843 11/07/13 04:00:05,115
3842 11/07/13 03:00:52,242
3841 11/07/13 02:00:39,041
as i remeber i used @awrreport.sql script to generate raports from the stored awr statistics. is this also prohibited by oracle if i don't have licence for awr feature?
is this script write something to the database to know that i was use it?
|
|
|
|
| Re: AWR - licensing question [message #515775 is a reply to message #515770] |
Wed, 13 July 2011 04:09 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
As John says above, anything related to awr is licensed. If you don't have the license you can't use it. We will not tell you different.
Why don't you just use statspack instead - it's free.
|
|
|
|
| Re: AWR - licensing question [message #515780 is a reply to message #515770] |
Wed, 13 July 2011 04:13 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Piotr, you have to be very careful! This
Quote:is this script write something to the database to know that i was use it? reads as though you are more worried about being caught, than about staying licence compliant. Your clients will not thank you if commit them to a massive spend (though Oracle Corp might)
|
|
|
|
| Re: AWR - licensing question [message #515782 is a reply to message #515770] |
Wed, 13 July 2011 04:14 |
|
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:so if we are talking not to use awr packages to be licence compliant - i am good.
So you didn't read what I said, just what you want to hear/read.
The 2 queries you just executed are illegal (as well as running AWR report which execute a procedure in dbms_workload_repository package).
What Oracle knows that you use (at feature level) is in dba_feature_usage_statistics view (you are allowed to query).
Regards
Michel
[Updated on: Wed, 13 July 2011 04:15] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: AWR - licensing question [message #631771 is a reply to message #631750] |
Mon, 19 January 2015 10:58 |
 |
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
|
Senior Member |
|
|
Like everyone else here, I am not an Attorney and I am not offering any legal advice, and I am only partially versed with Oracle licensing, so I am just talking.
I am pretty sure it is true that any use of AWR requires a license. This simply agrees with what most here have already said.
But I am also just as sure that at least in the United States, the Court System has already dealt with this question. Any vendor who turns on a restricted use product by default will have difficulty in making a case against anyone who uses the product by accident or design. It is considered a deceptive practice. In this situation, it is a practice that preys upon the confusion generated by Oracle Corp. itself which has been attested to by everyone on this post most of who have decades of Oracle experience and yet admit that even after that much time, they still have no clue how Oracle licensing works (which is entirely Oracle's fault since they make it complicated as all get out).
I also believe that if your are using Oracle products for self edification only (just you, not your company, and not for making money or helping anyone else make money), then you can get all the software Oracle will let you download and you can use all the features. Thus you can have every product on the Oracle shelf, downloaded and installed on your PC if you want in order to teach it to yourself. This is one of the things that makes Oracle so great. There is no reason not to know it if you want to.
Although one can claim that everyone is responsible, as a Developer and DBA, it is not your job to know what products you can or can't use. For most of us, someone else does the negotiating/licensing etc. on what products they are allowed to install and make available. Thus, unless you know it to be part of your direct responsibilities to know otherwise, when a product feature is available to you, you may use it. If you were not supposed to use it, it should not have been turned on by the person who purchased/installed/managed the product at the operating system level, or more correctly, Oracle should have turned it off in the first place when they sold you the licenses and provided any specialized install scripts. Hence the legal disclaimer we often see on software ads, "You system administrator may have disabled specific product features...".
Quote:I was surprised to read about licensing AWR in Oracle.
This tells me, no one has told you that it is your job to worry about it. So unless you know otherwise, don't worry about it.
That is my advice anyway. Legal pundits may say I am treading a fine line here, but I for one am fed up with companies that do stupid stuff like activating products and features you did not buy and then trying to convince you later that even though they activated it, you should not have used it but since you did, now you must pay for it. This goes for even my beloved Oracle Corp.
YOU HAVE WON 10 MILLION DOLLARS might be what you hear if you have the winning ticket; Actor Portrayal: I am not an Oracle Professional, I am an actor portraying an Oracle Professional, and any resemblance to any real Oracle Professional living or dead is purely coincidence; actual details inside; dealer prep extra; not legal advice; no warranty express or implied; not fit for use for any particular purpose; terms subject to change without notice; to opt out reply to this email with the words OPT OUT in the title; children should be supervised when using this product; possible side effects include itching, burning, rash, infection, sterility, cancer, and death; slight imperfections are considered normal; objects in mirror are closer than they appear; no life guard on duty; package sold by weight not volume; action figures sold separately, alternative toy available for those under 3.
Kevin
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
