Oracle數(shù)據(jù)庫(kù)標(biāo)準(zhǔn)版與企業(yè)版的區(qū)別-創(chuàng)新互聯(lián)

轉(zhuǎn)載路徑為：/tupian/20230522/err_404.html />
QUESTION：
Oracle標(biāo)準(zhǔn)版和企業(yè)版相比較而言，在價(jià)格上是便宜多了。（生產(chǎn)用途）在這弱弱的問(wèn)一句，標(biāo)準(zhǔn)版和企業(yè)版相比少了哪些功能，如何查看？謝謝~
ANSWER：（這里是重點(diǎn)，點(diǎn)開(kāi)鏈接即可查看官方以及非官方的說(shuō)明）
Official answer is at:
/tupian/20230522/editions.htm />
Non-official answers:
http://www.dba-oracle.com/art_so_oracle_standard_enterprise_edition.htm
http://www.orafaq.com/faq/what_is_the_difference_between_the_enterprise_standard_and_personal_editions_of_oracle (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：（這里給出忠告，如果沒(méi)買企業(yè)版，不要使用，不然有可能承擔(dān)法律責(zé)任）
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.)

分享標(biāo)題：Oracle數(shù)據(jù)庫(kù)標(biāo)準(zhǔn)版與企業(yè)版的區(qū)別-創(chuàng)新互聯(lián)
地址分享：http://bm7419.com/article42/dgoghc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供全網(wǎng)營(yíng)銷推廣、企業(yè)網(wǎng)站制作、云服務(wù)器、做網(wǎng)站、域名注冊(cè)、品牌網(wǎng)站制作

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)