1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Which options are installed on your Oracle database

Discussion in 'Server Administration and Options' started by Arju, Oct 24, 2008.

  1. Arju

    Arju Forum Expert

    Likes Received:
    Trophy Points:
    In three ways we can achieved.

    1)From Oracle Universal Installer: In OUI select installed products and click on list and expand, you will see a list of options installed in database.

    2)From v$option:
    Code (Text):
    SQL> set pages 100
    SQL> select * from v$option;

    PARAMETER                                                        VALUE
    ---------------------------------------------------------------- -----
    Partitioning                                                     TRUE
    Objects                                                          TRUE
    Real Application Clusters                                        FALSE
    Advanced replication                                             TRUE
    Bit-mapped indexes                                               TRUE
    Connection multiplexing                                          TRUE
    Connection pooling                                               TRUE
    Database queuing                                                 TRUE
    Incremental backup and recovery                                  TRUE
    Instead-of triggers                                              TRUE
    Parallel backup and recovery                                     TRUE
    Parallel execution                                               TRUE
    Parallel load                                                    TRUE
    Point-in-time tablespace recovery                                TRUE
    Fine-grained access control                                      TRUE
    Proxy authentication/authorization                               TRUE
    Change Data Capture                                              TRUE
    Plan Stability                                                   TRUE
    Online Index Build                                               TRUE
    Coalesce Index                                                   TRUE
    Managed Standby                                                  TRUE
    Materialized view rewrite                                        TRUE
    Materialized view warehouse refresh                              TRUE
    Database resource manager                                        TRUE
    Spatial                                                          TRUE
    Visual Information Retrieval                                     TRUE
    Export transportable tablespaces                                 TRUE
    Transparent Application Failover                                 TRUE
    Fast-Start Fault Recovery                                        TRUE
    Sample Scan                                                      TRUE
    Duplexed backups                                                 TRUE
    Java                                                             TRUE
    OLAP Window Functions                                            TRUE
    Block Media Recovery                                             TRUE
    Fine-grained Auditing                                            TRUE
    Application Role                                                 TRUE
    Enterprise User Security                                         TRUE
    Oracle Data Guard                                                TRUE
    Oracle Label Security                                            FALSE
    OLAP                                                             TRUE
    Table compression                                                TRUE
    Join index                                                       TRUE
    Trial Recovery                                                   TRUE
    Data Mining                                                      TRUE
    Online Redefinition                                              TRUE
    Streams Capture                                                  TRUE
    File Mapping                                                     TRUE
    Block Change Tracking                                            TRUE
    Flashback Table                                                  TRUE
    Flashback Database                                               TRUE
    Data Mining Scoring Engine                                       FALSE
    Transparent Data Encryption                                      TRUE
    Backup Encryption                                                TRUE
    Unused Block Compression                                         TRUE

    54 rows selected.
    TRUE mean we can use that option and FALSE mean we can't.

    3)From DBA_REGISTRY:
    Code (Text):
    SQL> select comp_name, status from dba_registry;

    COMP_NAME                                                              STATUS
    ---------------------------------------------------------------------- -----------
    Oracle Database Catalog Views                                          VALID
    Oracle Database Packages and Types                                     VALID
    Oracle Workspace Manager                                               VALID
    JServer JAVA Virtual Machine                                           VALID
    Oracle XDK                                                             VALID
    Oracle Database Java Packages                                          VALID
    Oracle Expression Filter                                               VALID
    Oracle Data Mining                                                     VALID
    Oracle Text                                                            VALID
    Oracle XML Database                                                    VALID
    Oracle Rules Manager                                                   VALID
    Oracle interMedia                                                      VALID
    OLAP Analytic Workspace                                                VALID
    Oracle OLAP API                                                        VALID
    OLAP Catalog                                                           VALID
    Spatial                                                                VALID
    Oracle Enterprise Manager                                              VALID
    17 rows selected.
  2. sameer

    sameer Forum Advisor

    Likes Received:
    Trophy Points:
    Available Options in Oracle

    To put the above post in proper perspective, an Oracle option is an extension to the capabilities of the Oracle server. An Oracle Option is however not the same thing as Oracle features.

    As mentioned above The v$option view shows which options are installed on a server. I will try to explain a few of them.

    This Refers to the ability to create user defined types.

    This Option applies to tables and indexes. If a table or an index is partitioned, several pieces of the same object can be in different segements and maybe even on different tablespaces.

    An integrated set of functions and procedures that enables spatial data to be stored, accessed, and analyzed quickly and efficiently.

    Real Application Clusters (RAC)
    The clustering option, previously known as Parallel Server.

    Advanced replication
    updateable materialized views and writeable materialized views require this option

    Bit-mapped indexes
    one of the several indexing methods is Bit-mapped indexes

    Database queuing
    This Integrates a message queue system with the database.

    Incremental backup and recovery
    Ability to backup only those data blocks that have changed since the last backup.

    Parallel backup and recovery
    RMAN can make parallelize backups of the database.

    Parallel execution
    With parallel execution, a single SQL statement can be processed by multible processes.

    Point-in-time tablespace recovery (TSPITR)
    Allows to recover a tablespace to a specific (prior) time that is different from the rest of the tablespaces.

    Fine-grained access control (FGAC)
    Defining policies to restrict what a user is allowed to see in a table.

    Proxy authentication/authorization
    Self Explanatory

    Plan Stability
    cost based optimizer may be affected by altering sort_area_size or bitmap_merge_area_size. This is prevented by Plan stability.

    Transparent Application Failover
    If a node in an Oracle Parallel Servers fails then the Transparent application failover migrates the connections (and sessions) to another node.

    Export transportable tablespaces
    For transportable tablespaces, this option is required
  3. Arju

    Arju Forum Expert

    Likes Received:
    Trophy Points:
    In the table DBA_REGISTRY the status may be,

    1)INVALID : Some problem in it.

    2) VALID: Working properly

    3) LOADING:The component is loading.

    4) LOADED: The component just loaded.

    5) UPGRADING:The component is in a process of upgrade.

    6) UPGRADED:The component has been upgrade.

    7) DOWNGRADING:The component is in a process of downgrade.

    8) DOWNGRADED:The component has been downgraded.

    9) REMOVING:Someone is uninstalling the component.

    10)REMOVED:The component has been unistalled.