An Architect's vision

With Oracle Database 11g Release 2 (11.2.0.x), it is not possible to deinstall/remove a specific licensable option from an already installed database Oracle home. However, users can choose to enable or disable a specific licensable option using the chopt tool. The chopt tool is a command-line utility that is located in the ORACLE_HOME/bin directory. The syntax for chopt is: chopt [ enable | disable] db_option The possible values for db_option are described in the following table: Value Description _________________________________________________ dm Oracle Data Mining RDBMS Files dv Oracle Database Vault lbac Oracle Label Security olap Oracle OLAP partitioning Oracle Partitioning rat Oracle Real Application Testing _________________________________________________ For example, to enable the Oracle Label Security option in your Oracle binary files, stop the database, run the following command, and start the dat...

Installation of Oracle Database 11g Release 2 installs all the licensable options. Though installed, not all the licensable options are enabled by default. During installation, installer gives an option for users to enable the licensable options that are not enabled in a default installation. Users can also choose to disable some licensable options that are enabled by default. (Please refer to "Licensing Information" document released for the specific Oracle Database release for a list of options licensed under each specific database edition.) Once the installation is done, users can still disable or enable some licensable options. This article explains how to enable or disable a specific licensable option from an already installed Oracle home. Solution With Oracle Database 11g Release 2 (11.2.0.x), it is not possible to deinstall/remove a specific licensable option from an already installed database Oracle home. However, users can choose to enable or disable a specific ...

SQL> select parameter,value from v$option where upper(parameter) like '%PARTITION%'; SQL> Select decode(count(*), 0, 'No', 'Yes') Partitioning from ( select 1 from dba_part_tables where owner not in ('SYSMAN', 'SH', 'SYS', 'SYSTEM') and rownum = 1 );

1. Oracle Real Application Clusters 2. Automatic Workload Management

Standard Edition(SE) or Standard Edition One (SE1)is dependent on No. of sockets per server. It has no dependency with No. of cores per socket. Example - On a 2 processor system you simply need 2 licenses. However, if you use Enterprise Edition you need to take the number of cores into account as well.

Named User (NU) licensing limits the number of individuals authorized to use Oracle on any server. 1. Oracle Database Standard Edition ONE: 5 Named User Plus licenses 2. Oracle Database Standard Edition: 5 Named User Plus licenses 3. Oracle Database Enterprise Edition: 25 Named User Plus licenses per CPU 4. Oracle Application Server Standard Edition ONE: 5 Named User Plus licenses 5. All other Oracle Application Server products: 10 Named User Plus licenses per CPU

1. Oracle Data Guard—Redo Apply 2. Oracle Data Guard—SQL Apply 3. Oracle Data Guard—Snapshot Standby 4. Oracle Active Data Guard 5. Rolling Upgrades—Patch Set, Database, and Operating System 6. Online index rebuild 7. Online index-organized table organization 8. Online table redefinition 9. Duplexed backup sets 10. Block change tracking for fast incremental backup 11. Unused block compression in backups 12. Block-level media recovery 13. Lost Write Protection 14. Parallel backup and recovery 15. Tablespace point-in-time recovery 16. Trial recovery 17. Fast-start fault recovery 18. Flashback Table 19. Flashback Database 20. Flashback Transaction 21. Flashback Transaction Query 22. Oracle Total Recall 23. Client Side Query Cache 24. Query Results Cache 25. PL/SQL Function Result Cache 26. In-Memory Database Cache 27. SQL Plan Management 28. Support for Oracle Exadata Storage Server 29. Support for Oracle Exadata Storage Server Software 30. Advanced Security O...

1. Oracle Active Data Guard 2. Oracle Total Recall 3. In-Memory Database Cache 4. Advanced Security Option 5. Oracle Label Security 6. Oracle Database Vault 7. Oracle Change Management Pack 8. Oracle Configuration Management Pack 9. Oracle Diagnostic Pack 10. Oracle Tuning Pack 11. Oracle Provisioning and Patch Automation Pack 12. Oracle Real Application Testing 13. Oracle Partitioning 14. Oracle OLAP 15. Oracle Data Mining 16. Oracle Advanced Compression 17. Oracle Spatial

SQL> select parameter,value from v$option where upper(parameter) like '%PARTITION%'; SQL> Select decode(count(*), 0, 'No', 'Yes') Partitioning from ( select 1 from dba_part_tables where owner not in ('SYSMAN', 'SH', 'SYS', 'SYSTEM') and rownum = 1 );