An Open Letter to Larry Ellison on AWR and ASH Licensing
Please note this late-breaking news related to this story. Then still please sign our letter!
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 http://www.pythian.com/blogs/526/)
Please also help by publicizing this open letter on your own blog, on mailing lists, forums or anywhere else Oracle users congregate. We are hoping to achieve a critical mass of signatures by the morning of July 9; the letter will be couriered that day.
N.B. Please join us in signing this letter by placing your name and (optionally) your company affiliation(s), along with the word “SIGNATORY,” in a comment on this blog article. Comments that do not include this word will not be considered “signatures”.
June 29th, 2007 at 8:53 pm
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
June 29th, 2007 at 10:34 pm
SIGNATORY
I’m all for it and wish this would happen.
Will make us maybe even buy more oracle tools
June 30th, 2007 at 2:18 am
SIGNATORY
June 30th, 2007 at 3:14 am
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
June 30th, 2007 at 3:18 am
SIGNATORY
June 30th, 2007 at 4:15 am
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.
June 30th, 2007 at 4:18 am
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)
June 30th, 2007 at 5:07 am
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.
June 30th, 2007 at 8:38 am
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
June 30th, 2007 at 8:47 am
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……
June 30th, 2007 at 9:47 am
SIGNATORY
June 30th, 2007 at 10:53 am
SIGNATORY
June 30th, 2007 at 10:59 am
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.
June 30th, 2007 at 12:46 pm
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?
June 30th, 2007 at 1:12 pm
[…] Paul Vallee over at Pythian has posted An Open Letter to Larry Ellison on AWR and ASH Licensing. […]
June 30th, 2007 at 2:45 pm
SIGNATORY
Patrick Wolf, Sphinx IT Consulting
June 30th, 2007 at 3:11 pm
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.
June 30th, 2007 at 3:58 pm
SIGNATORY
June 30th, 2007 at 4:20 pm
[…] 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 […]
June 30th, 2007 at 4:51 pm
Forgot to include my
SIGNATORY
June 30th, 2007 at 5:20 pm
SIGNATORY
June 30th, 2007 at 5:22 pm
SIGNATORY
June 30th, 2007 at 11:08 pm
SIGNATORY.
Perhaps while we’re at it we can get partitioning included with EE!
June 30th, 2007 at 11:51 pm
SIGNATORY
July 1st, 2007 at 1:29 am
SIGNATORY
July 1st, 2007 at 2:14 am
SIGNATORY
July 1st, 2007 at 2:45 am
Flaco
9i/10g OCP
independent dba
July 1st, 2007 at 2:48 am
SIGNATORY
July 1st, 2007 at 3:50 am
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.
July 1st, 2007 at 4:44 am
SIGNATORY
July 1st, 2007 at 8:42 am
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.
July 1st, 2007 at 9:02 am
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
July 1st, 2007 at 3:41 pm
[…] Pack,价格不菲)。Pythian Group 的 Mark Brinsmead 日前发布了一篇 An Open Letter to Larry Ellison on AWR and ASH Licensing，阐述了 “这样收取 License 的方式导致用户接受 Oracle […]
July 1st, 2007 at 7:12 pm
SIGNATORY
July 2nd, 2007 at 12:26 am
SIGNATORY
July 2nd, 2007 at 3:14 am
SIGNATORY
Let everyone use this feature and let performance tuning techniques can be improved widely
July 2nd, 2007 at 5:00 am
SIGNATORY
July 2nd, 2007 at 5:57 am
SIGNATORY
July 2nd, 2007 at 6:33 am
[…] http://www.pythian.com/blogs/526/an-open-letter-to-larry-ellison-on-awr-and-ash-licensing […]
July 2nd, 2007 at 7:40 am
SIGNATORY
July 2nd, 2007 at 8:05 am
SIGNATORY
July 2nd, 2007 at 8:58 am
SIGNATORY
July 2nd, 2007 at 9:12 am
[…] 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 […]
July 2nd, 2007 at 9:27 am
SIGNATORY
July 2nd, 2007 at 9:27 am
SIGNATORY
July 2nd, 2007 at 9:46 am
SIGNATORY
July 2nd, 2007 at 9:50 am
SIGNATORY
July 2nd, 2007 at 10:01 am
SIGNATORY
July 2nd, 2007 at 10:09 am
SIGNATORY
July 2nd, 2007 at 10:13 am
[…] 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 […]
July 2nd, 2007 at 10:18 am
SIGNATORY
July 2nd, 2007 at 10:19 am
SIGNATORY
Jo Holvoet, AMI Semiconductor
July 2nd, 2007 at 10:22 am
SIGNATORY
Good luck with this effort.
July 2nd, 2007 at 10:25 am
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 ;).
July 2nd, 2007 at 10:28 am
SIGNATORY
July 2nd, 2007 at 10:29 am
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.
July 2nd, 2007 at 11:01 am
SIGNATORY
I’m a oracle employee, but … I support this personally.
July 2nd, 2007 at 11:17 am
SIGNATORY
Oracle Corp’s reputation is already not the best in some places, and things like this restriction sure don’t help.
July 2nd, 2007 at 11:21 am
AWR/ADDM/ASH charge your money!…
如果不是今天看到Fenng的给 Larry Ellison 的公开信，事关 AWR 与 ASH文章中提到Mark Brinsmead的这封公开信，我也不知道AWR/ADDM/ASH这样几乎完全内置在数据库中的功能也是需要额外收费的。
仔细查了….
July 2nd, 2007 at 11:25 am
SIGNATORY
July 2nd, 2007 at 11:59 am
SIGNATORY
July 2nd, 2007 at 12:14 pm
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.
July 2nd, 2007 at 12:42 pm
SIGNATORY
July 2nd, 2007 at 1:05 pm
Jeremiah, good point but I won’t be surprised if RAT will be a part of Diagnostic or Performance Tuning Packs.
July 2nd, 2007 at 1:07 pm
SIGNATORY
July 2nd, 2007 at 3:24 pm
SIGNATORY
July 2nd, 2007 at 3:29 pm
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.
July 2nd, 2007 at 5:01 pm
SIGNATORY
July 2nd, 2007 at 5:13 pm
SIGNATORY
July 2nd, 2007 at 5:43 pm
SIGNATORY
July 2nd, 2007 at 6:24 pm
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.
July 2nd, 2007 at 8:59 pm
SIGNATORY
July 2nd, 2007 at 10:11 pm
SIGNATORY
Larry, set the data free
July 2nd, 2007 at 11:30 pm
SIGNATORY
July 3rd, 2007 at 1:11 am
SIGNATORY
July 3rd, 2007 at 1:59 am
SIGNATORY
July 3rd, 2007 at 2:08 am
SIGNATORY
July 3rd, 2007 at 3:11 am
SIGNATORY
July 3rd, 2007 at 4:19 am
SIGNATORY
July 3rd, 2007 at 4:33 am
SIGNATORY
July 3rd, 2007 at 5:33 am
SIGNATORY
Larry, please make it free….
as I really was helped by the tools :)
regards
Ujang
@Indonesia
July 3rd, 2007 at 6:47 am
SIGNATORY
July 3rd, 2007 at 7:12 am
SIGNATORY
July 3rd, 2007 at 7:15 am
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.
July 3rd, 2007 at 7:26 am
SIGNATORY
July 3rd, 2007 at 8:35 am
SIGNATORY
Anssi Lehtinen
July 3rd, 2007 at 9:05 am
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.
July 3rd, 2007 at 9:28 am
SIGNATORY
July 3rd, 2007 at 11:08 am
SIGNATORY
July 3rd, 2007 at 11:23 am
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.
July 3rd, 2007 at 11:54 am
SIGNATORY
On behalf of myself and my company: Valentia GmbH, working for many of Oracle’s major accounts.
July 3rd, 2007 at 12:39 pm
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.
July 4th, 2007 at 8:09 am
SIGNATORY
Good luck!
July 4th, 2007 at 11:01 am
SIGNATORY
July 4th, 2007 at 3:31 pm
SIGNATORY
July 5th, 2007 at 12:31 am
SIGNATORY
July 5th, 2007 at 2:57 am
SIGNATORY
July 5th, 2007 at 3:06 am
SIGNATORY
Good Luck!
July 5th, 2007 at 5:36 am
SIGNATORY
July 5th, 2007 at 10:31 am
SIGNATORY
July 5th, 2007 at 11:44 am
Good luck with this effort. I strongly agree with the author.
July 6th, 2007 at 4:39 am
SIGNATORY
July 6th, 2007 at 1:44 pm
[…] open letter to Larry Ellison from Mark Brinsmead of Pythian has provoked a deluge of signatories and supporting blog articles. […]
July 6th, 2007 at 1:53 pm
SIGNATORY
July 6th, 2007 at 2:23 pm
SIGNATORY
Good Luck with this effort.
July 6th, 2007 at 4:17 pm
[…] 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 […]
July 6th, 2007 at 11:07 pm
SIGNATORY
Should I consider myself lucky that my employer, the University of Ottawa accepted to pay for OEM and the management packs?
July 7th, 2007 at 3:07 pm
SIGNATORY
July 8th, 2007 at 1:31 pm
SIGNATORY
July 9th, 2007 at 5:57 am
It’s crazy not to have this important info available as part of the enterprise license.
SIGNATORY
July 9th, 2007 at 7:47 am
SIGNATORY
July 9th, 2007 at 11:03 am
SIGNATORY
July 9th, 2007 at 11:17 am
SIGNATORY
ditto
July 9th, 2007 at 11:30 am
SIGNATORY
July 9th, 2007 at 11:33 am
SIGNATORY
July 9th, 2007 at 11:34 am
Good luck.
July 9th, 2007 at 11:40 am
A required item to preserve.
July 9th, 2007 at 11:55 am
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
July 9th, 2007 at 12:00 pm
SIGNATORY
July 9th, 2007 at 12:08 pm
SIGNATORY
July 9th, 2007 at 12:10 pm
SIGNATORY
July 9th, 2007 at 12:10 pm
SIGNATORY
July 9th, 2007 at 12:17 pm
SIGNATORY
July 9th, 2007 at 12:22 pm
SIGNATORY
July 9th, 2007 at 12:22 pm
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.
July 9th, 2007 at 12:30 pm
SIGNATORY
July 9th, 2007 at 12:30 pm
Given the nice easy-to-use performance tools included with Microsoft SQL Server, it seems odd that Oracle would charge additional fees.
Dennis Williams
July 9th, 2007 at 12:31 pm
SIGNATORY
July 9th, 2007 at 12:58 pm
Strongly agree with the author.
July 9th, 2007 at 12:58 pm
It seems strange to require additional licensing for a tool whose infrastructure is included with the database.
July 9th, 2007 at 1:11 pm
While I think something this useful should be part of the base product, it should be part of Enterprise as the least.
SIGNATORY
July 9th, 2007 at 1:13 pm
SIGNATORY
July 9th, 2007 at 1:18 pm
SIGNATORY
Absolutely agree, Mark !
July 9th, 2007 at 1:42 pm
SIGNATORY
July 9th, 2007 at 1:43 pm
SIGNATORY
July 9th, 2007 at 2:18 pm
SIGNATORY
July 9th, 2007 at 2:27 pm
SIGNATORY
July 9th, 2007 at 2:49 pm
SIGNATORY
July 9th, 2007 at 3:26 pm
SIGNATORY
July 9th, 2007 at 3:29 pm
Ram Srinivasan
SIGNATORY
Abslutely agree with the contents of the letter to Mr.Ellison.
July 9th, 2007 at 4:24 pm
I agree. This data collected belongs to the owner of the database and should be freely available to the customer.
July 9th, 2007 at 5:28 pm
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
July 9th, 2007 at 8:21 pm
SIGNATORY
支持
July 9th, 2007 at 8:32 pm
SIGNATORY
July 9th, 2007 at 9:06 pm
SIGNATORY
July 10th, 2007 at 12:22 am
SIGNATORY
July 10th, 2007 at 6:19 am
SIGNATORY
July 10th, 2007 at 7:20 am
SIGNATORY
July 10th, 2007 at 7:35 am
SIGNATORY
AWR and ASH is the brain of Oracle 10g. Oracle Corp. shouldn’t sell the body without the brain to anybody.
July 10th, 2007 at 8:03 am
SIGNATORY
July 10th, 2007 at 8:23 am
SIGNATORY
July 10th, 2007 at 8:32 am
I do not believe that I can anything new to the comments already posted. Hopefully Larry is listening.
July 10th, 2007 at 9:51 am
SIGNATORY
July 10th, 2007 at 10:32 am
SIGNATORY
July 10th, 2007 at 10:44 am
Signatory
July 10th, 2007 at 11:21 am
Computing Services
Adams State College
SIGNATORY
July 10th, 2007 at 12:15 pm
SIGNATORY
July 10th, 2007 at 2:51 pm
SIGNATORY
July 11th, 2007 at 6:38 am
SIGNATORY
July 11th, 2007 at 8:39 am
SIGNATORY
July 11th, 2007 at 10:25 am
SIGNATORY
July 11th, 2007 at 11:31 am
At least let us disable the features if we cannot use.
SIGNATORY.
July 11th, 2007 at 11:47 am
SIGNATORY
July 11th, 2007 at 3:43 pm
SIGNATORY
July 12th, 2007 at 3:27 am
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
July 12th, 2007 at 6:34 am
SIGNATORY
July 12th, 2007 at 8:16 pm
SIGNATORY
July 13th, 2007 at 6:54 am
SIGNATORY
July 13th, 2007 at 10:04 am
SIGNATORY
July 13th, 2007 at 3:23 pm
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.
July 18th, 2007 at 4:06 am
SIGNATORY
July 18th, 2007 at 6:07 pm
SIGNATORY
This has to be one of the only cases where selecting from an existing table is technically a license violation.
July 19th, 2007 at 6:33 am
SIGNATORY
July 19th, 2007 at 2:12 pm
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.
July 23rd, 2007 at 4:11 am
The Oracle licensing is far to complicated. This should be redesigned by Oracle.
July 23rd, 2007 at 5:36 am
SIGNATORY
July 24th, 2007 at 6:07 am
SIGNATORY
July 30th, 2007 at 10:41 am
SIGNATORY
July 30th, 2007 at 1:17 pm
SIGNATORY
August 6th, 2007 at 5:11 am
SIGNATORY
August 9th, 2007 at 10:11 am
SIGNATORY
August 13th, 2007 at 2:18 pm
SIGNATORY
If they keep adding licenses we’ll end up rebuilding most of their tuning tools.
I hope they reconsider this.
August 14th, 2007 at 5:15 am
[…] “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. […]
August 14th, 2007 at 6:52 am
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.
August 14th, 2007 at 11:50 am
[…] 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 […]
August 14th, 2007 at 10:35 pm
SIGNATORY
August 15th, 2007 at 8:23 am
SIGNATORY
August 21st, 2007 at 1:38 am
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
August 21st, 2007 at 3:16 am
Pascal Oegerli, Edorex Informatik AG, 3072 Ostermundigen, Switzerland
August 21st, 2007 at 4:02 am
Signatory
August 30th, 2007 at 9:48 am
SIGNATORY
August 31st, 2007 at 2:12 am
SIGNATORY
August 31st, 2007 at 2:08 pm
SIGNATORY
September 4th, 2007 at 5:42 am
SIGNATORY
September 5th, 2007 at 8:36 am
SIGNATORY
September 12th, 2007 at 8:27 am
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.
September 13th, 2007 at 9:22 am
SIGNATORY
September 19th, 2007 at 3:39 pm
SIGNATORY
October 2nd, 2007 at 8:58 am
SIGNATORY
October 19th, 2007 at 10:46 am
[…] bringt der offene Brief der Pythian Group “An Open Letter to Larry Ellison on AWR and ASH Licensing” doch noch […]
December 27th, 2007 at 5:21 am
SIGNATORY
February 3rd, 2008 at 11:33 pm
Signatory
March 7th, 2008 at 1:43 pm
SIGNATORY
March 14th, 2008 at 8:17 am
SIGNATORY
March 27th, 2008 at 3:41 pm
SIGNATORY
March 28th, 2008 at 1:18 am
SIGNATORY
Good initiative..hope Larry Listens to it..
March 31st, 2008 at 11:33 pm
I am all for AWR and ASH to be kept out of licensing.
April 1st, 2008 at 6:01 am
good effort, appreciate. Looking forward for good news from Oracle
May 22nd, 2008 at 12:21 pm
SIGNATORY
July 20th, 2008 at 1:28 pm
SIGNATORY (Forbrich Computer Consulting Ltd. - Canada)
August 28th, 2008 at 2:32 pm
SIGNATORY
September 7th, 2008 at 4:04 pm
SIGNATORY
September 16th, 2008 at 6:42 pm
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.
November 5th, 2008 at 10:09 am
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.
November 5th, 2008 at 11:12 am
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.
November 12th, 2008 at 8:46 am
SIGNATORY
Lets ask Tom Kyte?
ps: is it coincedence - CAPTCHA asked me to type two words: scandal pretty ?