首页 / 数据库 / MySQL / Oracle 组件 系列 小结

Oracle 组件的信息可以通过v$option 和 dba_registry 查看：

--查看v$option:V$OPTION displaysOracle Database options and features. Typically, although not always, optionsmust be separately licensed, whereas features come with the product and areenabled based on the product that is running （Standard Edition, EnterpriseEdition, and so on）.SQL> select * from v$option;PARAMETER                                VALUE------------------------------------------------------Partitioning                             TRUEObjects                                  TRUEReal Application Clusters                FALSEAdvanced replication                     TRUEBit-mapped indexes                       TRUEConnection multiplexing                  TRUEConnection pooling                       TRUEDatabase queuing                         TRUEIncremental backup and recovery          TRUEInstead-of triggers                      TRUEParallel backup and recovery             TRUE PARAMETER                                VALUE------------------------------------------------------Parallel execution                       TRUEParallel load                            TRUEPoint-in-time tablespace recovery        TRUEFine-grained access control              TRUEProxy authentication/authorization       TRUEChange Data Capture                      TRUEPlan Stability                           TRUEOnline Index Build                       TRUECoalesce Index                           TRUEManaged Standby                          TRUEMaterialized view rewrite                TRUE PARAMETER                                VALUE------------------------------------------------------Materialized view warehouse refresh      TRUEDatabase resource manager                TRUESpatial                                  TRUEAutomatic Storage Management             FALSEExport transportable tablespaces         TRUETransparent Application Failover         TRUEFast-Start Fault Recovery                TRUESample Scan                              TRUEDuplexed backups                         TRUEJava                                     TRUEOLAP Window Functions                    TRUE PARAMETER                                VALUE------------------------------------------------------Block Media Recovery                     TRUEFine-grained Auditing                    TRUEApplication Role                         TRUEEnterprise User Security                 TRUEOracle Data Guard                        TRUEOracle Label Security                    FALSEOLAP                                     TRUEBasic Compression                        TRUEJoin index                               TRUETrial Recovery                           TRUEData Mining                              TRUE PARAMETER                                VALUE------------------------------------------------------Online Redefinition                      TRUEStreams Capture                          TRUEFile Mapping                             TRUEBlock Change Tracking                    TRUEFlashback Table                          TRUEFlashback Database                       TRUETransparent Data Encryption              TRUEBackup Encryption                        TRUEUnused Block Compression                 TRUEOracle Database Vault                    FALSEResult Cache                             TRUE PARAMETER                                VALUE------------------------------------------------------SQL Plan Management                      TRUESecureFiles Encryption                   TRUEReal Application Testing                 TRUEFlashback Data Archive                   TRUEDICOM                                    TRUEActive Data Guard                        TRUEServer Flash Cache                       TRUEAdvanced Compression                     TRUEXStream                                  TRUEDeferred Segment Creation                TRUE65 rows selected.SQL> 

1 2 下一页

Oracle Binary Options 说明Oracle 10g Rac root.sh Failure at final check of Oracle CRS stack 10 解决方法相关资讯      Oracle组件  本文评论 查看全部评论 （0）

表情： 姓名： 匿名字数 <div id="footbar"> 版权所有©石家庄振强科技有限公司2024 <a href="https://beian.miit.gov.cn" target="_blank">冀ICP备08103738号-5</a> <a href="/storage/sitemap.xml">网站地图</a> </div> </div> <script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/cm.js"></script> <script> var _mtj = _mtj || []; (function () { var mtj = document.createElement("script"); mtj.src = "https://node12.aizhantj.com:21233/tjjs/?k=p2tceukth5c"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(mtj, s); })(); </script> </body> </html>