Oracle database

From Oracle FAQ

Jump to: navigation, search

The Oracle database is Oracle Corporation's flagship database product.

Contents

[edit] Database Editions

The Oracle database server is available in the following editions:

[edit] Oracle Enterprise Edition

Oracle's top-end database server product for big enterprise customers.

[edit] Oracle Standard Edition

Four-processor version of Oracle Database, including full clustering support (Real Application Clusters).

[edit] Oracle Standard Edition One

Two-processor version of Standard Edition at an attractive entry-level price. Real Application Clusters is included with Standard Edition One.

[edit] Oracle Personal Edition

Full-featured version for individuals, compatible with the entire Oracle Database family (except Real Application Clusters).

[edit] Oracle Express Edition

Free version of Oracle that is limited to 1 processor, 1 GB RAM and 4 GB of data. For more info, see Oracle XE.

[edit] Database Options

The following optional database options can be purchased separately. These options are only available with the Enterprise Edition (the only exception is RAC):

[edit] Partitioning Option

The partitioning option allows DBAs to split large tables into more manageable sub-tables (partitions). Some of the advantages offered:

  • Partitions can be stored in different tablespaces;
  • Partitions can be added/ removed while users are working;
  • Data can be selected from targeted partitioned without having to scan all partitions for rows (partition pruning).

[edit] Spatial Option

The Spatial option store geographical information (GPS coordinates for instance) with records.

[edit] Real Application Clusters Option

Real Application Clusters (RAC) - formerly called Oracle Parallel Server (OPS) - allows more than one instance to mount and open an Oracle database. RAC can only be used on special clustered systems.

[edit] Advanced Security Option

Oracle Advanced Security (ASO), formerly called the Advanced Networking Option, provides a suite of security features to protect a company's network by providing network encryption, authentication solutions, single sign-on services, and support for other security protocols. ASO is only available with Oracle Enterprise Edition.

[edit] Oracle Label Security

Row level security based on stringent government and commercial requirements; sensitivity labels (i.e. confidential, doctor-patient only, top secret) provide better intellectual property protection and privacy.

[edit] Oracle OLAP

Oracle OLAP is a complete set of analytical functions fully integrated within the database.

[edit] Oracle Data Mining

Oracle Data Mining offers embedded data mining for classifications, predictions, and associations to build advanced business intelligence applications.

[edit] Database Vault

A new option to Oracle Database 10g Release 2 Enterprise Edition that lets you control who, when, and where data and applications can be accessed, protecting against the most common security threat like malicious internal users.

[edit] Total Recall

Total Recall is based on Oracle's Flashback feature and will allow users to query data "AS OF" an earlier time in the past. This will allow companies to "archive" data for auditing and regulatory compliance. For more info, see Oracle Total Recall.

[edit] Advanced Compression

Option used to compress data. For more info, see Oracle Advanced Compression.

[edit] Real Application Testing (RAT)

RAT can be used to capture, analyze and replay database transactions. For more info, see Real Application Testing.

[edit] Database features

A database feature, in contrast with an option, is provided free with the database software.

Most DBA's and developers work with multiple versions of Oracle at any particular time. To see what features were introduced in each version, refer to the version pages: Oracle 2, Oracle 3, Oracle 4, Oracle 5, Oracle 6, Oracle 7, Oracle 8, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g.

[edit] Database version history

The major Oracle versions, with their latest patch-sets are:

If running on one of the above releases, it is recommended to always install the latest patch-set.

[edit] Currently supported versions

Oracle 9iR2 was desupported on 31 July 2007. However, customers on Oracle 9.2.0.8 received free Extended Support until July 31, 2008. For details about this, see http://www.oracle.com/features/hp/database-9i-support.html

Oracle 10g Release 1 will be desupported on 31 January 2009.

Currently, Oracle 10g Release 2 and Oracle 11g are fully supported.

[edit] Also see

Retrieved from "http://www.orafaq.com/wiki/Oracle_database"
Personal tools