Oracle資料庫標準版與企業版的區別
轉載路徑為:http://www.itpub.net/thread-2067419-1-1.html
QUESTION:
Oracle標準版和企業版相比較而言,在價格上是便宜多了。(生產用途)在這弱弱的問一句,標準版和企業版相比少了哪些功能,如何檢視?謝謝~
ANSWER:(這裡是重點,點開連結即可檢視官方以及非官方的說明)
Official answer is at:
Non-official answers:
(an old article)
Any specific feature you're considering?
QUESTION:
Thank you for your prompt reply, which is very useful to me.
I got many unavailable features to explain my failures of using AWR and so on.(Oracle 11.2.0.4)
How can I use these features,such as Fast RMAN Compression (ZLIB),SQL Plan management and so on?Just use lincese and change parameter of database?
ANSWER:(這裡給出忠告,如果沒買企業版,不要使用,不然有可能承擔法律責任)
Listen to neverinit. Better safe than sorry.
If your client doesn't want to buy EE, just live with SE. In real experience, lack of AWR, Fast RMAN Compression (ZLIB),SQL Plan management is nothing serious. You can run a job to run Statspack, or gather stats with your own script. You can compress backup pieces with gzip. SE doesn't support SQL Plan Management but supports SQL outlines. (Oracle deprecates outlines in favor of SPM, maybe partially out of this greedy motive?) Just be clever in rolling your own tools and finding workarounds.
The only big problem is actually this fact: Oracle software is designed to have all fancy features readily usable EVEN IF YOU HAVE NOT PURCHASED IT. I say it's a big problem because if you accidentally use it, as shown in DBA_FEATURE_USAGE_STATISTICS, Oracle auditors (if you are audited) will get you! It takes a lot of legal talk to convince Oracle that you did it unintentionally and you may still end up paying the fine. This happened to an American university a few years ago. The correct software design should be such that if you haven't paid for a feature, the feature should not even be enabled for you.
QUESTION:
Thanks for your kind reminding,I will improve my skills of managing Oracle.
Besides, I will keep our client on our guard.Next week there will be an Oracle expert to check and optimize the environment,I wll ask him about the big problem and seek for a better solution.
ANSWER:
Oracle software is designed to have all fancy features readily usable EVEN IF YOU HAVE NOT PURCHASED IT.
To be more specific, Oracle is not doing this right in the sense that if your database is Enterprise Edition, the control_management_pack_access parameter has the default value 'DIAGNOSTIC+TUNING', even if you have not purchased licenses for these two options. I just experimented with
alter system set control_management_pack_access = none;
It indeed takes effect. A query against v$active_session_history no longer returns any row. But to my surprise, I can still run AWR report (@?/rdbms/admin/awrrpt.sql).
On the other hand, Oracle is right in not allowing Enterprise Edition features if your database is Standard Edition by setting that parameter to NONE by default. (I didn't verify but I'll trust the documentation.)
QUESTION:
Oracle標準版和企業版相比較而言,在價格上是便宜多了。(生產用途)在這弱弱的問一句,標準版和企業版相比少了哪些功能,如何檢視?謝謝~
ANSWER:(這裡是重點,點開連結即可檢視官方以及非官方的說明)
Official answer is at:
Non-official answers:
(an old article)
Any specific feature you're considering?
QUESTION:
Thank you for your prompt reply, which is very useful to me.
I got many unavailable features to explain my failures of using AWR and so on.(Oracle 11.2.0.4)
How can I use these features,such as Fast RMAN Compression (ZLIB),SQL Plan management and so on?Just use lincese and change parameter of database?
ANSWER:(這裡給出忠告,如果沒買企業版,不要使用,不然有可能承擔法律責任)
Listen to neverinit. Better safe than sorry.
If your client doesn't want to buy EE, just live with SE. In real experience, lack of AWR, Fast RMAN Compression (ZLIB),SQL Plan management is nothing serious. You can run a job to run Statspack, or gather stats with your own script. You can compress backup pieces with gzip. SE doesn't support SQL Plan Management but supports SQL outlines. (Oracle deprecates outlines in favor of SPM, maybe partially out of this greedy motive?) Just be clever in rolling your own tools and finding workarounds.
The only big problem is actually this fact: Oracle software is designed to have all fancy features readily usable EVEN IF YOU HAVE NOT PURCHASED IT. I say it's a big problem because if you accidentally use it, as shown in DBA_FEATURE_USAGE_STATISTICS, Oracle auditors (if you are audited) will get you! It takes a lot of legal talk to convince Oracle that you did it unintentionally and you may still end up paying the fine. This happened to an American university a few years ago. The correct software design should be such that if you haven't paid for a feature, the feature should not even be enabled for you.
QUESTION:
Thanks for your kind reminding,I will improve my skills of managing Oracle.
Besides, I will keep our client on our guard.Next week there will be an Oracle expert to check and optimize the environment,I wll ask him about the big problem and seek for a better solution.
ANSWER:
Oracle software is designed to have all fancy features readily usable EVEN IF YOU HAVE NOT PURCHASED IT.
To be more specific, Oracle is not doing this right in the sense that if your database is Enterprise Edition, the control_management_pack_access parameter has the default value 'DIAGNOSTIC+TUNING', even if you have not purchased licenses for these two options. I just experimented with
alter system set control_management_pack_access = none;
It indeed takes effect. A query against v$active_session_history no longer returns any row. But to my surprise, I can still run AWR report (@?/rdbms/admin/awrrpt.sql).
On the other hand, Oracle is right in not allowing Enterprise Edition features if your database is Standard Edition by setting that parameter to NONE by default. (I didn't verify but I'll trust the documentation.)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31394774/viewspace-2142111/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle企業版和標準版的區別Oracle
- oracle標準版和企業版的區別!Oracle
- ORACLE標準版與企業版的差別(zt)Oracle
- ORACLE標準版與企業版的差別(轉載)Oracle
- Oracle企業版、標準版本、簡化版之間的區別Oracle
- 檢視Oracle資料庫是企業版還是標準版Oracle資料庫
- AIX 7.1 標準版,企業版,易捷版的區別AI
- 關於oracle10G標準版和企業版的區別Oracle
- SQL Server 2019企業版和標準版的區別?SQLServer
- Orace 的標準版&企業版9i&10g的區別[轉]
- ISAServer2006企業版與標準版區別及陣列布署Server陣列
- win10企業版與專業版區別 win10企業版與專業版哪個好Win10
- 小米手環5標準版和NFC版有什麼區別?小米手環5標準版和NFC版的區別介紹
- 華碩飛馬3標準版和高配版的區別
- Oracle Database 11G R2 標準版 企業版 下載地址OracleDatabase
- Win10企業版和專業版有什麼區別_win10企業版和專業版的區別詳解Win10
- Win10企業版、專業版和家庭版的區別Win10
- APP的測試版與正式版區別——蘋果企業簽名APP蘋果
- 小米MAX標準版與小米MAX高配版區別對比評測
- 小米MIX2標準版/高配版/尊享版的硬體配置區別
- vivo Xplay5標準版與旗艦版詳細區別對比評測
- SolidWorks軟體教育版和企業版的主要區別Solid
- 詳解Win10家庭版/專業版/企業版功能區別Win10
- Oracle標準資料庫稽核Oracle資料庫
- Gmail企業郵箱標準版(免費版)申請詳細攻略AI
- windows7家庭版,專業版,旗艦版,企業版版本區別Windows
- win10專業版和企業版的區別是什麼 win10專業版和企業版哪個好Win10
- vivo NEX旗艦版和標準版的區別 vivo NEX和旗艦版哪個好?
- 小米4S低配版和標準版區別對比介紹
- ORACLE資料庫標準審計Oracle資料庫
- win10企業版和教育版有什麼區別_win10企業版好還是教育版好Win10
- Java與資料庫 —— JDBC標準Java資料庫JDBC
- 關於Oracle資料庫與MySQL資料庫的幾點區別Oracle資料庫MySql
- win10專業版和win10企業版哪個好 win10企業版和專業版有什麼區別Win10
- SQL Server 2008 R2 中英文 MSDN 開發版/企業版/標準版SQLServer
- win10企業版和家庭版有什麼區別_win10企業版和家庭版哪個好Win10
- nubia Z11黑金版和標準版有何區別 nubia Z11黑金版評測
- python官方標準庫(中文版)Python