15 years ago, with the release of Oracle 7.0.12, Oracle gave the world—or at least its customers—something really great: the Oracle Wait Interface (OWI).
The OWI is one of the reasons that Oracle’s database product and its customer base are what they are today. It provides a clear, transparent, and above all useful view of what the database is doing and where it is spending its time. This level of instrumentation has allowed Oracle customers to not only tune their databases and applications but also to understand them.
Most importantly, this instrumentation was stored in performance views that were accessible by SQL so that tuning techniques could be invented and refined using the data that the wait interface provides. The wait interface revolutionized Oracle performance tuning, massively increased Oracle users’ ability to scale applications, and enabled Oracle to dominate the world-wide-web revolution thanks to the users’ new ability to genuinely understand the performance characteristics of their applications.
Over time, performance tools evolved from BSTAT/ESTAT reports to Statspack, both provided by Oracle to interpret OWI data. SQL tracing and session profiling using TKPROF and other utilities were the next tools that DBAs turned to, and they allowed an even deeper understanding of the functioning Oracle database. Neither the OWI data nor the interpretation tools were separately licensed. And in 10g, Oracle released Automated Workload Repository (AWR) and Active Session History (ASH), a revolution in the level of instrumentation provided by the database. However, Oracle decided to separately license both the data collected in the performance views and the interpretive tools in OEM. As a result, the true power of AWR and ASH have yet to be unleashed.
AWR and ASH boast a number of very useful capabilities already covered in great detail elsewhere. Unfortunately, the majority of Oracle customers have never been able to use even the most rudimentary capabilities because of licensing restrictions. In fact, these restraints not only prevent the majority of Oracle users from accessing AWR and its underlying data but they also leave customers with no supported means of turning AWR off.
(If you’re not already familiar with these restrictions, you can read about them in the Oracle 10g Licensing Information Manual, here, here, and many other places.)
What concerns us most is our belief that Oracle Corporation is missing out on a great opportunity to make an excellent product even better. These licensing terms are causing Oracle customers to adopt this otherwise excellent feature more slowly than they otherwise might, if at all. To give a statistically significant example, of Pythian’s 70 outsourced DBA-for-Oracle customers, so few have licensed the use of this feature as to approach zero. We assert that by relaxing the restrictions on accessing the data layer underlying AWR, Oracle may encourage more customers to purchase their “Diagnostic Pack,” the option still needed to access the advanced features of AWR, such as advisors and graphical analysis tools.
We believe that the Oracle database software is the best instrumented database software available. The fact that Oracle already leads the industry in this regard probably led to their decision to make this leap forward in instrumentation an extra-cost item. However, in the interest of making Oracle even better, we would like to invite readers to join us in signing the following open letter to Larry Ellison, CEO of Oracle Corporation. We plan to deliver this letter to Oracle Corporation by courier on July 10, the day before the planned announcement of Oracle 11g.
Dear Mr. Ellison,
On behalf of the community, please accept our congratulations on the release of Oracle 11g.
We are writing in the hope that you might seize the opportunity presented by the release of your next-generation database management software to review the licensing policy regarding access to the Automated Workload Repository (AWR) and Active Session History (ASH) features, at least for Oracle 11g.
We believe that AWR and ASH are breakthrough features and represent a leap forward in the already industry-leading instrumentation provided by Oracle. While we fully support your freedom to assess extra license fees for the advanced functions provided through the Diagnostic and Performance Tuning Packs of Oracle Enterprise Manager, we want to give voice to a consensus building among the Oracle user community that Oracle is missing its chance to capitalize on its lead in this area.
We are disappointed by the decision to restrict access, at least using SQL, to the lowest-level tables and views in which performance data, essentially our data, are recorded. Many of us are frustrated by the fact that AWR and ASH collect and retain this data regardless of our wishes, while we are not even able to look at it.
AWR and ASH are integral parts of Oracle, which is why there are no effective means of disabling them. They are even built in the Standard Edition, for which no way to license them exists. Consequently, Oracle customers are exposed to substantial licensing liabilities (since according to the licensing terms even a single accidental query of the data would entail a requirement to upgrade to the Enterprise Edition plus the Diagnostic Pack).
We believe that changing the licensing terms to allow customers to access the basic data in the tables and views underlying AWR and ASH would actually benefit Oracle’s sales by making Oracle databases substantially better instrumented and thus easier to manage than those built using any competitor’s RDBMS. This would also encourage customers to adopt the basic features of AWR and ASH and eventually become more likely to consider the advantages of licensing the more advanced features accessible through Oracle Enterprise Manager.
We hope that with this successful release of Oracle 11g your licensing team at Oracle Corporation will consider revising the licensing terms to allow us to access at least the lowest-level views and APIs of AWR and ASH in your current release. We believe that making this licensing change effective with the 11g release will assure that the rate of adoption of 11g will be substantially more rapid than otherwise because there is more pent-up demand for this feature today among Oracle performance enthusiasts than for any other in Oracle. In so doing, you will also make us more confident of our ability to assure our respective managements that we comply with with our Oracle licensing terms.
Yours truly,
Members of Oracle user community
(signed electronically at https://blog.pythian.coms/526/)
We are hoping to achieve a critical mass of signatures by the morning of July 9, 2007; the letter will be couriered that day.
253 Comments. Leave new
SIGNATORY
I’ll keep my fingers crossed and hope that this letter is taken into consideration when AWR licensing is discussed in Oracle.
Alex Gorbachev, The Pythian Group
SIGNATORY
I’m all for it and wish this would happen.
Will make us maybe even buy more oracle tools
SIGNATORY
SIGNATORY
Not holding any hopes: after all, Oracle seems to be hell bent
on reducing the “dba expense” by increasing their fees with
every opportunity…
but here goes anyway.
Nuno Pinto do Souto, DBVision P/L
SIGNATORY
SIGNATORY
Good luck with this effort.
I am lucky enough at the moment to work with a customer who has paid for the required licences. (Such sites do exist, but I suspect that the customer often doesn’t truly appreciate the benefits they’ve paid for.) That just makes me support this effort even more because I can see how *useful* this information is.
I could perhaps understand an extra payment for pretty graphs, but it’s difficult for me to accept that some data dictionary views can be queried and some can’t without paying extra and that I pay the system overhead without benefiting from the results.
You know, it wouldn’t surprise me to find some of Oracle’s own support analysts think that you can run awrrpt.sql without the Diagnostics licence. Mmmm, imagine if you actually witnessed that ;-)
Come on, Larry. You’ve got the best product already – think of the great publicity you would get from this. Why not charge for XML or Java in the database? It makes more sense!
P.S. Was bstat/estat really used to analyse OWI data? That’s not my recollection, but I could certainly be wrong.
SIGNATORY
ASH and AWR are seriously awesome tools to help diagnose what has (just) happened without requiring tracing.
I don’t mind if the GUI tools still require licenses, just let the V$ views and @?/rdbms/admin/*rpt*.sql be provided as part of a database license.
Paul Moen, The Pythian Group (Australia)
SIGNATORY
Freelance Oracle application development and performance consultant.
No question, this functionality makes a significant differentiation between manageability of Oracle RDBMS versus “other” – whether commercial or open source.
SIGNATORY
I have always thought Oracle support and even Oracle Security (the two most often maligned areas of Oracle) are great. My only real beef with Oracle over the last few years has been the restrictive licensing. I hope they read this and take action. I would actually like to see partitioning be part of the EE license and maybe an add on license for standard.
One thing at a time though. ;-)
Good luck,
LewisC
Mr Ellison, set our data free!…
Paul Vallee over at Pythian has posted An Open Letter to Larry Ellison on AWR and ASH Licensing. There is some good information in the entry about the history of the Oracle Wait Interface and database tuning. The letter is……
SIGNATORY
SIGNATORY
SIGNATORY
Another inconsistency is that AWR is installed and running in the free Oracle Express Edition (XE).
Snapshots are collected hourly, DBMS_WORKLOAD_REPOSITORY.create_snapshot works,
awrrpt.sql produces beautiful HTML reports, etc.
XE is supposed to be free without restrictions. I hope I haven’t just admitted to a license violation.
SIGNATORY
I would love a license violation make it to the courts – whether you can enforce that it is forbidden to look at a V$-table in your own database. Forbidding use a specific software, yes, there is precedence for that. But to “look” at some data? Would I be allowed to look at the datafile content?
[…] Paul Vallee over at Pythian has posted An Open Letter to Larry Ellison on AWR and ASH Licensing. […]
SIGNATORY
Patrick Wolf, Sphinx IT Consulting
Bravo Mark. Bravo!
Oracle is being short sighted about this. If we could look at the data, create our own queries, we could determine how valuable AWR/ASH are for our organization. We might then look at licensing the Diagnostic Pack so we don’t have to keep running sql over and over and over again.
SIGNATORY
[…] ASH Licensing – Letter to Larry Ellison Mark Brismead on the Pythian Group Blog presents an open letter to Larry Ellison regarding AWR (Automated Workload Repository) and ASH (Active Session History) licensing. This […]
Forgot to include my
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY.
Perhaps while we’re at it we can get partitioning included with EE!
SIGNATORY
SIGNATORY
SIGNATORY
Flaco
9i/10g OCP
independent dba
SIGNATORY
SIGNATORY
I run standard edition, so I can’t even buy the diagnostics pack. How silly is it to have a proportion of my database workload dedicated to generating performance data which I am not allowed to look at.
SIGNATORY
SIGNATORY
I think it is not bad that you cannot look at it, it is bad that the restriction is not technically supported and illegally uses the end-user resources while giving no benefits.
Solution might be in allowing querying the awr/ash tables and also permitting disabling functionality, but prohibiting use of the intelligent part (the packages mostly) of the packs.
SIGNATORY
It probably doesn’t come as a great surprise that someone who organised a petition that gathered over 150 signatories for Oracle to allow SE customers to use this data at all is in favour of this, but I am.
At the moment Oracle’s licensing position on this data is selling their competitor’s products. Either dedicated ones like quest, or simple network monitor tools. Come on Oracle get a grip.
Niall
SIGNATORY
SIGNATORY
SIGNATORY
Let everyone use this feature and let performance tuning techniques can be improved widely
SIGNATORY
SIGNATORY
[…] https://www.pythian.com/blogs/526/an-open-letter-to-larry-ellison-on-awr-and-ash-licensing […]
SIGNATORY
SIGNATORY
SIGNATORY
[…] was working on this post last week when the 10g AWR/ASH petition came online here. I’m of two minds about the issue. In the end, I think limiting access to this […]
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
[…] linkfest led me to a great Open Letter to Larry Ellison on AWR and ASH Licensing by Mark Brinsmead. I first had to understand the issue as I’ve made it a high priority to […]
SIGNATORY
SIGNATORY
Jo Holvoet, AMI Semiconductor
AWR/ADDM/ASH charge your money!…
[…]????????Fenng?? Larry Ellison ??????? AWR ? ASH?????Mark Brinsmead????????????AWR/ADDM/ASH??????????????????????????[…]
SIGNATORY
Good luck with this effort.
SIGNATORY
People have budgets for Oracle software. Even if they are properly licensing the Diagnostics Pack in order to get the AWR and ASH (and ADDM) functions today, by saving them money on Diagnostics Pack licenses, it’s quite likely they’ll spend the budget on other Oracle-licensed options.
Refactoring can and does happen–just like Oracle Enterprise User Security was included with 10g for the first time (instead of just with ASO).
May the force be with us ;).
SIGNATORY
Lot of useful information which can help troubleshoot performance related issues is available in AWR/ASH and I am sure Oracle Corp might have invested time and money in instrumenting these details. To really leverage and help everyone use this information, it would be really great and worth the efforts, it the licensing restrictions are relaxed.
SIGNATORY
I’m a oracle employee, but … I support this personally.
SIGNATORY
Oracle Corp’s reputation is already not the best in some places, and things like this restriction sure don’t help.
SIGNATORY
SIGNATORY
SIGNATORY
11g’s revolutionary feature is Real Application Testing (RAT), which includes Database Replay and SQL Workload Analyzer. Effective use of this feature set requires ASH/AWR data, so in order to even contemplate 11g’s core feature advance, customers will need access to ASH and AWR. Don’t hamstring your customers in a way that will result in unnecessarily poorly-performing Oracle databases around the world.
SIGNATORY
Jeremiah, good point but I won’t be surprised if RAT will be a part of Diagnostic or Performance Tuning Packs.
SIGNATORY
SIGNATORY
Please, help us make the industry acceptance of the Oracle database even larger by enabling us to make it better in the eyes of our co-workers, supervisors, and clients. When we win, Oracle wins. And we can win faster and more frequently when we can use all the tools that Oracle provides.
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
It is time Oracle Corp woke up to the fact that this useful tool is stymied by its own licensing terms. I would actually request that this be applied to 10g itself.
SIGNATORY
SIGNATORY
Larry, set the data free
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
Larry, please make it free….
as I really was helped by the tools :)
regards
Ujang
@Indonesia
SIGNATORY
SIGNATORY
SIGNATORY
I agree, this basic functionality would go further to impress if availble with the license than it does to generate revenue requiring a license.
SIGNATORY
SIGNATORY
Anssi Lehtinen
SIGNATORY
In a cost conscience marketplace the benefit from the extra functionality is a selling point for Oracle, but only if it isn’t cost prohibitive. What good are extra license fees if the cost of getting this functionality drove the clients to a competitor’s database product? You can’t sell the extras if you didn’t sell the base product.
It’s this type of functionality that differentiates Oracle from it’s competitors. Set the data free.
SIGNATORY
SIGNATORY
SIGNATORY
“Open” the access of this data and its benefits, in my case, would help to convince managers to buy OEM. Brochures and videos are not good enough as reasons to buy. In the meantime, we have to spend money and time buying several third party tools which most of the times only address a part of the whole.
SIGNATORY
On behalf of myself and my company: Valentia GmbH, working for many of Oracle’s major accounts.
SIGNATORY
The ASH & AWR v$ views should be included with the database license. Restricting them is like selling a car and telling your customer they’re not allowed to look at the guages on the dashboard.
At the absolute minimum, there should be an option to license the ASH & AWR views at a discount with Standard Edition, and there should be an option to simply & completely disable them in order to eliminate the performance & storage overhead for customers that can’t (Std. Ed.) or don’t license them.
SIGNATORY
Good luck!
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
Good Luck!
SIGNATORY
SIGNATORY
Good luck with this effort. I strongly agree with the author.
SIGNATORY
[…] open letter to Larry Ellison from Mark Brinsmead of Pythian has provoked a deluge of signatories and supporting blog articles. […]
SIGNATORY
SIGNATORY
Good Luck with this effort.
[…] week, in collaboration with several of my colleagues here at Pythian, I published an open letter to Larry Ellison. The response to this letter has been — well — surprising, both in volume and in […]
SIGNATORY
Should I consider myself lucky that my employer, the University of Ottawa accepted to pay for OEM and the management packs?
SIGNATORY
SIGNATORY
It’s crazy not to have this important info available as part of the enterprise license.
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
ditto
SIGNATORY
SIGNATORY
Good luck.
A required item to preserve.
SIGNATORY
Being a small Non-profit organization forces us to keep costs down – which is why we use Standard Edition. We tried to purchase Diagnostic pack, but were told we had to upgrade all databases to Enterprise Edition to use it – way too many $$$$ involved. So we purchased Confio’s Ignite for Oracle. It is an excellent alternative to Oracle’s packs if you are on Standard Edition
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
Another example of odd marketing is Partitioning. Many medium sized sites have a minimal number of tables large enough in size to be worth considering the license for Partitioning. If the license cost were significantly lower such that a proportionately higher number of customers decided to buy Partitioning as a result, Oracle could get more total revenue and also have more satisfied customers.
SIGNATORY
Given the nice easy-to-use performance tools included with Microsoft SQL Server, it seems odd that Oracle would charge additional fees.
Dennis Williams
SIGNATORY
Strongly agree with the author.
It seems strange to require additional licensing for a tool whose infrastructure is included with the database.
While I think something this useful should be part of the base product, it should be part of Enterprise as the least.
SIGNATORY
SIGNATORY
SIGNATORY
Absolutely agree, Mark !
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
Ram Srinivasan
SIGNATORY
Abslutely agree with the contents of the letter to Mr.Ellison.
I agree. This data collected belongs to the owner of the database and should be freely available to the customer.
SIGNATORY
I am working with a licensed site, but it seems ridiculous that it cant be disabled especially for SE clients who cant even buy a license, Something wrong there
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
AWR and ASH is the brain of Oracle 10g. Oracle Corp. shouldn’t sell the body without the brain to anybody.
SIGNATORY
SIGNATORY
I do not believe that I can anything new to the comments already posted. Hopefully Larry is listening.
SIGNATORY
SIGNATORY
Signatory
Computing Services
Adams State College
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
At least let us disable the features if we cannot use.
SIGNATORY.
SIGNATORY
SIGNATORY
IMHO:
Appealing to a sense of Fair Play might well fall on deaf ears.
Instead, how about adding to the Letter something along the lines of:
“If Oracle were to make access to AWR & ASH via SQL free, then Oracle would spend a lot less on Support costs, as more Customers would, themselves, be better able to diagnose & fix issues that must currently take up a lot of Oracle Support’s time. This would allow Oracle to invest more in the product, rather than answering relatively trivial Support calls.”
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
Having these tools in house has enhanced our ability to trouble shoot problems in the database. We now use OEM exclusively for our administration and performance tuning. From a purely marketing point of view Oracle would take a lot of business away from their competitors by offering this as part of the database product.
SIGNATORY
SIGNATORY
This has to be one of the only cases where selecting from an existing table is technically a license violation.
SIGNATORY
SIGNATORY
Allow more people to use the most useful parts of your product and more people will buy. This is like buying a Ferrari and having a limiter put in at 100Km/h.
The Oracle licensing is far to complicated. This should be redesigned by Oracle.
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
If they keep adding licenses we’ll end up rebuilding most of their tuning tools.
I hope they reconsider this.
[…] “Real Time SQL Monitoring” is a 11g Tuning Pack new feature. You can easily access it when the Tuning Pack is set. If a query is a “long” query, if it uses more than 5 seconds of CPU of I/O Wait or if it’s a parallel query (from the documentation), the plan execution statistics are kept by the engine and you can follow the query execution in Real Time. Note that it differs from V$SESSION_LONGOPS which enables you to follow one step of a query or other operations. Anyway, It’s very impressive even if it doesn’t look to be fully functional (Is it me ?). It’s just a shame that I won’t be able to access it for all the databases although we’ve already asked for. […]
SIGNATORY
I work for one of the largest oil companies in the world and due to these and a few other licensing practises by Oracle we are not using these features and have made SQL Server our strategic platform. I was involved in the licensing negotiations and as such know that Oracle talked themselves out of a few million dollars by trying to chase silly money we were unwilling to pay.
[…] six weeks ago, I wrote, with my colleagues here at Pythian, an open letter to Larry Ellison, imploring him and Oracle to free API-level access to Automated Workload Repository (AWR) and […]
SIGNATORY
SIGNATORY
SIGNATORY
I remember with Oracle 7 and the procedural option which was only an option.
But after a 7.x release PL/SQL was used to impelment some exp/imp internal routines and then had to be standard!
Karl
Pascal Oegerli, Edorex Informatik AG, 3072 Ostermundigen, Switzerland
Signatory
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
How about Oracle pay you for the cost of your CPU cycles used to gather statistics that you haven’t asked for, can’t use, and at 10g can’t turn off.
Oracle’s licensing is a joke. It’s too expensive, too complex, and too restrictive.
Anyway, definitely a signatory.
SIGNATORY
SIGNATORY
SIGNATORY
[…] bringt der offene Brief der Pythian Group “An Open Letter to Larry Ellison on AWR and ASH Licensing” doch noch […]
SIGNATORY
Signatory
SIGNATORY
SIGNATORY
SIGNATORY
SIGNATORY
Good initiative..hope Larry Listens to it..
I am all for AWR and ASH to be kept out of licensing.
good effort, appreciate. Looking forward for good news from Oracle
SIGNATORY
SIGNATORY (Forbrich Computer Consulting Ltd. – Canada)
SIGNATORY
SIGNATORY
SIGNATORY.
This is short-sightedness on the part of a company whose licensing costs already are among the highest in the industry and have a huge user population who lack the proper tools to understand performance tuning.
By restricting access and keeping performance troubleshooting a ‘black art’ of scripts and SQL-queries, the product is at a competitive disadvantage compared to other DBMS products.
SIGNATORY
Licensing terms like this are one of the reasons that I tell the Oracle sales people that all of our new projects are coming up on SQL Server. I prefer to administer Oracle, but their greed is pricing them out of my market.
SIGNATORY
It’s also borderline entrapment that the extra licensed options are built in just waiting to be used. I don’t know how many people I’ve had to tell to not put that fancy “partition” clause on their create table. The AWR/ASH views should definitely be accessible without licensing too.
It’s like selling a car without a dashboard, or worse with a dashboard, but you’ll get fined if you look at the speedometer.
SIGNATORY
Lets ask Tom Kyte?
ps: is it coincedence – CAPTCHA asked me to type two words: scandal pretty ?
SIGNATORY
SIGNATORY
Some features Oracle provide can be used without the proper license. This is not correct. If you are not allowd to use it, it should be disabled by default.
Since it is not disabled you should be free to use it.
This is an interesting view, Peter, and your logic sounds reasonable.
Sadly, logic and reason often have little to do licenses, contracts, or legal proceedings. I will not encourage you (or anybody else) to make any decisions based on this argument.
Note, by the way, that since this blog was originally published, Oracle released a patch that will allow you to *disable* (but not remove!) AWR without violating your license.
It seems that Oracle takes these licensing terms seriously, and I for one would not want to pit this particular argument against the legion of lawyers they can undoubtedly throw at this.
I agree 100%. SIGNATORY
Have you read the oracle documentation?
It does not say “You can not purchase any
options with Oracle Database Standard Edition”.
There are two versions of SE, SE one
and plain SE.
https://download.oracle.com/docs/cd/B19306_01/license.102/b14199/options.htm
It says “You cannot purchase any options with Oracle Database Standard Edition One or Oracle Express Edition. The Personal Edition includes all options except Oracle Real Application Clusters at no additional cost.”
So if you have licensed Diagnostic pack (management packs) per CPU, and if you Standard Edition (not ONE), the document does not disallow that?
Joe,
What an interesting point you raise. Yes, of course I have read the documentation. However, I confess that I probably never noticed this particular (and somewhat fine) point. (There is a reason that I do not try to hold myself up as an “expert” on this topic — Oracle licensing is so incredibly complex, I doubt *anybody* could be an “expert”.)
The document you refer to says *nothing* about the ability to license OEM packs for Standard Edition (proper), one way or the other.
A 10 minute review of the OLSA and the Oracle online store says nothing either.
It is possible that I have fallen into a trap about which I constantly warn others — I *may* have actually accepted an Oracle sales rep’s word on this subject. :-)
I distinctly recall begin told (falsely, of course) by Oracle Sales that Oracle Enterpise Manager (Grid Control) 10g could not be used at all with Enterprise Edition databases; the reason offered at the time was that the OEM “Packs” could not be purchased for Standard Edition databases. As I recall, the reason offered was “correct” (truthful) — at least at the time — but the overall statement was of course false, as the use of OEM “Packs” has never been mandatory.
It is quite possible that in the years since Oracle10g was first released, this particular licensing constraint was relaxed; however, it may be equally possible that the constraint never actually existed.
Nice.
I think I may look for an opportunity to look into this one further. The question is definitely quite interesting.
My objections concerning licensing of AWR, however, still stand — at least with respect to Oracle Standard Edition ONE.
Having had a few spare minutes, I can now address Joe’s question better. Still not fully, but at least “better”.
Joe, the text you quoted relates to Oracle Database “Options” (e.g., Partitioning), not to OEM “Packs”.
The text in the Oracle 10g licensing manual (which you can find for yourself here: https://download.oracle.com/docs/cd/B28359_01/license.111/b28287/options.htm#CIHDDBCG ) says this:
—————–
Oracle Management Packs
The sections that follow describe the Oracle management packs. The management packs can be purchased only with Enterprise Edition. The features in these packs are accessible through Oracle Enterprise Manager Database Control, Oracle Enterprise Manager Grid Control, and APIs provided with Oracle Database software.
——————-
So, my original comments *were* correct.
Your comments are still interesting, though, as they suggest that I should be able to license “Partitioning” (for example) for a Standard Edition (not SE-ONE) database. I have always held — rather strongly — the belief that this is not the case, so I will now have to check *that* out too.
Of course, there is nothing — that I know of — to prevent an arbitrarily wide gap between what the Oracle license *permits* and what Oracle Corp will actually *sell* you. ;-)
Actually,
I re-read the documentation.
And now I understand the difference
of licensing OPTIONS and Management Packs.
One might be able to license options,
but not management packs to
SE.
I heard from Oracle that Larry Ellison has said twice “NO” to whether management packs should be allowed to be licensed for SE.
At that point, many choose to use other tools and pay for a tool like Confio
to be able to monitor and debug Oracle SE performance.
SIGNATORY
SIGNATORY
SIGNATORY
I work mostly with AWR and ASH from SQL*PLUS command line and think Oracle should allow customers to AT LEAST use the V$ views and command line interface for AWR and ASH with SQL*PLUS without paying additional licenses for the tool. Maybe Oracle could just require license for OEM GUI interface and let us all continue to use AWR from SQL*PLUS? That would be wonderful!
SIGNATORY
SIGNATORY
Below is a quote from the licensing information document (10g). From these two paragraphs one must conclude that using any option with XE is not allowed:
– You can only use them when you buy them (except RAC for SE)
– You can not buy them for XE.
The leak in the text is that it does not exclude buying options for SE, but rest asured: Oracle won’t sell them to you if you don’t have EE licenses.
Quote:
You may not use the options, packs, or products described below without separately
purchased licenses. The fact that these options, packs, or products may be included in
product CDs or downloads or described in documentation that you receive does not
authorize you to use them without purchasing appropriate licenses.
– Oracle Database Options
All the Oracle Database options can be purchased with Oracle Database Enterprise
Edition. Oracle Real Application Clusters is included with Oracle Database Standard
Edition. You cannot purchase any options with Oracle Database Standard Edition One
or Oracle Express Edition. The Personal Edition includes all options except Oracle Real
Application Clusters at no additional cost.
End of quote
SIGNATORY
One of the main reason we choose to pay more for oracle standard edition, in stead of other databases is the ability to see what is going on inside the database, and tune our application accordingly. Without AWR report, we could use any other databases and treat the database internal as a black box.
William,
Remember that AWR is not the *only* way to access performance data.
In Standard Edition, you *must* install and use StatsPack. StatsPack reports are very similar in content and value to AWR reports, although slightly less detailed in a few categories.
Standard Edition + StatsPack is still probably going to meet your needs, and should be a good value.
Standard Edition + AWR is a (serious) licensing liability — the bill you receive from Oracle to bring your licenses into compliance will probably be absolutely breath-taking.
If you are presently using AWR on SE, I advise to stop immediately, and promptly install and configure StatsPack in its place.
In regards to awr, what oracle is doing is equivalent to extortion. There is no other way to describe it, and I am shocked that to this day they haven’t been sued for it.
The fact that they install all these views by default, and then expect the customer to be familiar enough with the terms not to use them, is simply absurd. It’s like putting your cash out on the street in front of your house and expect no one to take it.
SIGNATORY
Oracle has become arrogant and anti-customer. No company can become so big and powerfull that they can forever mistreat their customers without penalty.
I agree.
SIGNATORY
After an 11gR2 upgrade I was surprised to see that the Tuning Pack options were not there and especially surprised that I could not even purchase this for Standard Edition.
I request that this be available for the Standard Edition. Signed, Chris Leadbeater
Chris,
If this were a request I can grant, I surely would. But, alas, it is not within my power.
It is odd, isn’t it, for a feature to go from “free” in one release to “not available at any price” in the next ?
If you look, you can probably find 3rd party replacements for some things, but few of these will be “free”, either. (If you need things like stored plans, etc., you are just plain out of luck, though, I fear.)
Good luck!
I’m guessing this might be not be active any longer, but as a DBA, I’m really missing the AWR reports for SE, and want to voice my encouragement. Thanks.
SIGNATORY
SIGNATORY
Good luck… :-(
SIGNATORY
SIGNATORY
SIGNATORY.
Mr. Allison if is a business decision, required a different licence for the “Diagnostic Pack”, please give to the SE users the possibility to buy the Diagnostic Pack licence. Thanks
I truly believe that Oracle is the most brilliantly designed application in the history of mankind, I would request Mr Allison to allow the Oracle lovers to drill down the oracle capabilities using the AWR and ASH.
With Regards
Abuzar kamal