| Differences Between Different Editions of Oracle Database 10G Release 1 |
| | Doc ID: | 271886.1 | Type: | BULLETIN |
| | Modified Date : | 16-OCT-2008 | Status: | PUBLISHED |
DIFFERENCE BETWEEN DIFFERENT EDITIONS OF ORACLE DATABASE 10G RELEASE 1
------------------------------------------------------------
The Oracle Database Product Family :
----------------------------------
Oracle Database is available in four editions, each suitable
for different development and deployment scenarios.
Oracle Database Standard Edition One :
------------------------------------
Oracle Database Standard Edition One delivers unprecedented ease of
use, power, and performance for workgroup, department-level, and Web
applications. Standard Edition One can only be licensed on servers with
a maximum capacity of two processors.
Oracle Database Standard Edition :
--------------------------------
Oracle Database Standard Edition delivers the unprecedented ease of
use, power, and performance of Standard Edition One, with support
for larger machines and clustering of services with Real Application
Clusters. Oracle Database Standard Edition can be licensed on single
servers or server clusters that have a maximum capacity of four
processors. Real Application Clusters is not included in the Standard
Edition of releases prior to Oracle Database 10g, nor is it an
available option with those earlier releases.When used in a clustered
server environment, Oracle Database Standard Edition requires the use
of Oracle Cluster Ready Services (CRS). Third-party clusterware
management solutions are not supported. In addition, Automatic
Storage Management (ASM) must be used to manage the data stored in
Oracle Database. Third-party volume managers and file systems are not
supported for this purpose. CRS and ASM are required in a clustered
server environment in order to facilitate the installation,
configuration, and support of Real Application Clusters on Standard
Edition.
Oracle Database Enterprise Edition :
----------------------------------
Oracle Database Enterprise Edition provides the performance,
availability, scalability, and security required for mission-critical
applications such as high-volume online transaction processing (OLTP)
applications, query-intensive data warehouses, and demanding Internet
applications. Oracle Database Enterprise Edition contains all of the
components of Oracle Database, and can be further enhanced with the
purchase of the options and packs.
Oracle Database Personal Edition :
--------------------------------
Oracle Database Personal Edition supports single-user development
and deployment environments that require full compatibility with
Oracle Database Standard Edition One, Oracle Database Standard Edition,
and Oracle Database Enterprise Edition.Personal Edition includes all of the
components that are included with Enterprise Edition, as well as all of
the options that are available with Enterprise Edition, with the exception
of the Oracle Real Application Clusters option, which cannot be used with
Personal Edition. Personal Edition is available on Windows 2000,
Windows NT, Windows XP, and Windows Server 2003 (32-bit and 64-bit
versions). The Management Packs are not included in Personal Edition.
Options :
=======
The following table lists the options available with this release.
Option 10G 10G 10G 10G Notes
Stand. Stand. Entrp. Pers.
Edit. Edit. Edit. Edit.
One
---------------------------------------------------------------------------------
Oracle N N Y Y Oracle Advanced
Advanced Security provides
Security network encryption
and a complete suite of
strong authentication
services to Oracle
Database.
Network encryption is
implemented using
industry-standard data
encryption and data
integrity algorithms.
---------------------------------------------------------------------------------
Oracle N N Y N The Oracle Change
Change Management Pack
Management enables database
Pack administrators to make
complex changes to
schema objects safely,
track changes to schemas
and databases over time,
make copies of schemas
or objects, and compare
and synchronize schemas
and databases.
---------------------------------------------------------------------------------
Oracle N N Y Y Oracle Data Mining
Data enables companies to
Mining build advanced business
intelligence applications
that mine corporate
databases, reveal new
patterns and relation-
ships, and integrate
that information into
business applications.
---------------------------------------------------------------------------------
Oracle N N Y N The Oracle Diagnostic
Diagnostics Pack provides automatic
Pack performance diagnostic
and advanced system
monitoring functionality.
---------------------------------------------------------------------------------
Oracle N N Y Y Oracle Label Security
Label provides sophisticated
Security and flexible security
based on row labels for
fine-grained access
control.
---------------------------------------------------------------------------------
Oracle N N Y Y Oracle OLAP is a scalable,
OLAP high-performance
calculation engine with
fully integrated
management and
administration for
delivering analytic
applications.
---------------------------------------------------------------------------------
Oracle N N Y Y Oracle Partitioning lets
Partitioning you store large tables as
retaining a single
application-level view of
individually managed smaller
pieces, while the data.
---------------------------------------------------------------------------------
Oracle N N N N Oracle Programmer provides
Programmer a rich set of interfaces for
developers who build
enterprise applications
that access and manipulate
Oracle Database.
---------------------------------------------------------------------------------
Oracle Y N Y N Oracle Real Application
Real Clusters (RAC) is a database
Application computing environment that
Clusters harnesses the processing
power of multiple
interconnected computers
using clustering technology.
---------------------------------------------------------------------------------
Oracle N N Y Y This option comprises an
Spatial integrated set of functions
and procedures that fac-
ilitate analysis based on
the spatial relationships
of associated data.
---------------------------------------------------------------------------------
Oracle N N Y N The Oracle Tuning Pack
Tuning provides database
Pack administrators with expert
performancemanagement for
the Oracle environment,
including SQL tuning and
storage optimizations.
---------------------------------------------------------------------------------
Oracle N N Y Y The Oracle Configuration
Configuration Management Pack enables
Management database administrators to
Pack track hardware and software
configuration information
for hosts and databases
managed by Enterprise
Manager.
---------------------------------------------------------------------------------
Features :
========
The following table lists the features available with this release.
Option 10G 10G 10G 10G Notes
Stand. Stand. Entrp. Pers.
Edit. Edit. Edit. Edit.
One
---------------------------------------------------------------------------------
VLDB, Data Warehousing, Business Intelligence:
=============================================
Data compression N N Y Y This feature provides the
ability to compress tables
and partitions.
---------------------------------------------------------------------------------
Bitmapped index N N Y Y This feature provides an
and bitmapped index type commonly used
join index in data warehouses for
columns with low cardinality,
such as 'Y' or 'N', to
dramatically improve
performance gains in a data
warehouse application.
---------------------------------------------------------------------------------
Export N N Y Y Quickly moves or creates a
transportable copy of tablespace data. A
tablespace transportable tablespace
can be "plugged in" to all
editions of the database.
(10g allows cross platform
transport of a tablespace)
---------------------------------------------------------------------------------
Import Y Y Y Y Quickly "plugs in" a
transportable transportable tablespace
tablespaces
---------------------------------------------------------------------------------
Asynchronous N N Y Y This feature provides a
change data framework for capturing
capture change data, publishing
it, and enabling
applications to subscribe
to the change data in a
controlled fashion.
Change capture occurs
asynchronously based on the
information in the Oracle
redo logs.
---------------------------------------------------------------------------------
Summary N N Y Y Summary management consists
management of mechanisms to define
materialized views and
dimensions, refresh and
query rewrite mechanisms,
which automatically
redirects queries to
stored materialized views,
improving query performance
dramatically. Also includes
a collection of materialized
view analysis and advisory
functions and procedures in
the DBMS_OLAP package or
via the SQL Access Advisor.
---------------------------------------------------------------------------------
Analytic functions Y Y Y Y Built-in SQL functions to
provide a variety of
sophisticated analytical
computations. These
include rank, moving
average, and ratio-to-
report, and many others.
---------------------------------------------------------------------------------
Automated parallel N N Y Y Automated parallel query
query degree optimization based on
system utilization.
---------------------------------------------------------------------------------
Descending indexes Y Y Y Y Provides better performance
when indexed data needs to
sorted in descending order.
---------------------------------------------------------------------------------
Direct Path Y Y Y Y Allows complete access to
Load API all load functionality via
OCI API for creation of
high performance load
programs.
---------------------------------------------------------------------------------
External tables Y Y Y Y Enables accessibility within
the database to external
data sources (such as flat
files) as read-only tables.
---------------------------------------------------------------------------------
Function-based Y Y Y Y Allows indexes to be created
indexes on expressions or functions.
---------------------------------------------------------------------------------
Long operations Y Y Y Y Progress of long running
monitor database and application
operations can be monitored
and information can be
displayed, such as percent
complete.
---------------------------------------------------------------------------------
Materialized views Y Y Y Y Create materialized views
and maintain using
complete and fast refresh
mechanisms.
---------------------------------------------------------------------------------
MERGE Y Y Y Y An incremental refresh of a
table requires two tasks:
New records are inserted
and existing records are
updated. MERGE allows
both tasks to be performed
simultaneously in a single
SQL statement.
---------------------------------------------------------------------------------
Optimizer Y Y Y Y Schema object statistics,
statistics used by the cost based
management optimizer can be copied
and moved to another
database.
---------------------------------------------------------------------------------
Pipelined table Y Y Y Y Allows result sets to be
functions pipelined back to calling
statement, dramatically
improving performance.
---------------------------------------------------------------------------------
Sample scan Y Y Y Y Scans of a sampling of
data to determine
approximate averages or
other data analysis
quickly even in extremely
large tables.
---------------------------------------------------------------------------------
Star query Y Y Y Y This algorithm utilizes
optimization B-tree indexes (not
bitmap indexes)
---------------------------------------------------------------------------------
Manageability :
=============
Database N N Y Y Database Resource Manager
Resource gives Oracle Database more
Manager control over resource
management decisions,
circumventing problems
arising from inefficient
operating system management.
---------------------------------------------------------------------------------
Parallel Operations :
===================
Parallel N N Y Y Oracle Database
query transparently distributes
query execution across
multiple processes,
resulting in excellent
performance.
---------------------------------------------------------------------------------
Parallel N N Y Y This feature no longer
DML requires the Oracle.
Partitioning option. DML
operations are transparent-
ly divided across multiple
processes.
---------------------------------------------------------------------------------
Parallel N N Y Y Indexes can be created using
index parallel processes,
build significantly improving
performance of the
operation.
---------------------------------------------------------------------------------
Parallel N N Y Y
statistics
gathering
---------------------------------------------------------------------------------
Parallel Data N N Y Y The new Data Pump Export and
Pump export Import utilities can each be
and import run in parallel, resulting
in better performance in
loading and unloading data
and metadata.
---------------------------------------------------------------------------------
Parallel N N Y Y Enables parallel Text index
text index creation on non-partitioned
creation as well as partitioned
tables.
---------------------------------------------------------------------------------
Parallel backup N N Y Y Allows both backup and
and recovery recovery to be run using
parallel processing.
---------------------------------------------------------------------------------
Parallel analyze N N Y Y The ANALYZE statement, used
to gather statistics on
tables, can be run using
parallel processing.
This feature requires
the Partitioning Option.
---------------------------------------------------------------------------------
Parallel bitmap N N Y Y This algorithm utilizes
star query single-table bitmap indexes
optimization and an advanced star query
join method, resulting in
excellent performance while
efficiently utilizing space.
---------------------------------------------------------------------------------
Parallel index N N Y Y Queries that use an index
scans can scan the index in
parallel with multiple
processes. This requires
the Partitioning Option.
---------------------------------------------------------------------------------
Parallel load Y Y Y Y Loads of data quickly with
multiple, parallel
processes.
---------------------------------------------------------------------------------
High Availability
=================
Oracle Data Guard N N Y Y Data Guard provides a
comprehensive set of
services that create,
maintain, manage, and
monitor one or more standby
databases to enable a
production Oracle Database
to survive disasters and
data corruption.
---------------------------------------------------------------------------------
Fast-start fault N N Y Y This feature provides fast
recovery and predictable recovery
from system failures.
---------------------------------------------------------------------------------
Online operations N N Y Y Online index maintenance
Online table organization
Online table redefinition
---------------------------------------------------------------------------------
Backup and recovery N N Y Y Block-level media recovery
Parallel backup and
recovery Change-aware
incremental backups
Duplexed backup sets
Point-in-time tablespace
recovery Trial recovery
---------------------------------------------------------------------------------
Oracle Flashback N N Y Y Oracle Flashback Table
features Oracle Flashback Database
Oracle Flashback
Transaction Query.
--------------------------------------------------------------------------------
Content Management :
==================
Dynamic Y Y Y Y Provides Web Service
Services Aggregation Transformation,
Administration, Definition
and Registration,
and Delivery. ICE 1.0
support.
---------------------------------------------------------------------------------
Oracle Database Y Y Y Y Creates heretical workspaces
Workspace Manager and uses metadata and views
to version enabled tables
in a long transaction
framework.
---------------------------------------------------------------------------------
Ultra Search Y Y Y Y Provides unified searching
across the Oracle database,
the Web (HTML), and external
data sources.
---------------------------------------------------------------------------------
Information Integration :
=======================
Oracle Streams N N Y Y Message queuing and apply
features of Oracle Streams
are available in Standard
Edition and Standard
Edition One, but change
capture is available only
in Enterprise Edition.
---------------------------------------------------------------------------------
Oracle Messaging N N Y Y Oracle Messaging Gateway
Gateway consists of an
administration package
for gateway configuration
and management and a
gateway agent that
processes propagation.
---------------------------------------------------------------------------------
Database Features :
=================
Advanced Queuing Y Y Y Y Provides direct support in
the database for high
performance queuing and
messaging operations,
integrated with LDAP.
---------------------------------------------------------------------------------
Database event Y Y Y Y Fires off database triggers,
triggers such as database startup or
shutdown triggers, DDL
statement triggers, and
logon/logoff triggers,
when the event occurs.
---------------------------------------------------------------------------------
DBMS_REPAIR Y Y Y Y Detects and corrects
package software and hardware
corruption early.
---------------------------------------------------------------------------------
Drop column Y Y Y Y Removes an unwanted column
from a table.
---------------------------------------------------------------------------------
Flashback Query Y Y Y Y Allows data to be queried
from a point in the past.
---------------------------------------------------------------------------------
Globalization Y Y Y Y Provides native language
Support support with enhanced
unicode capabilities.
---------------------------------------------------------------------------------
Index coalesce N N Y Y Defragments free space in
index leaf blocks
while a table is online.
---------------------------------------------------------------------------------
Index-organized Y Y Y Y Stores data in a table in
tables a B*-tree index structure
for better performance and
reduced storage.
---------------------------------------------------------------------------------
Instead-of Y Y Y Y Executes triggers instead
triggers of the DML that caused the
trigger to fire.
---------------------------------------------------------------------------------
LOB (large object) Y Y Y Y Provides datatypes and
support functionality for storing
and manipulating large
objects, such as images
or other unstructured data.
---------------------------------------------------------------------------------
Locally-managed Y Y Y Y Provides efficient
tablespaces storage management
functionality that
improves reliability and
reduces fragmentation.
---------------------------------------------------------------------------------
LogMiner Y Y Y Y Analyzes transaction log
information online to
enable auditing of
transactions and to "back
out" of individual
transactions.
---------------------------------------------------------------------------------
Plan Stability Y Y Y Y Allows execution plans for
SQL to be stored so that
the plan remains consistent
throughout schema changes,
database reorganizations,
and data volume changes.
---------------------------------------------------------------------------------
Quiesce database N N Y Y Allows for database
maintenance without it
forcing a shutdown.
---------------------------------------------------------------------------------
Reverse key Y Y Y Y Allows Indexed columns to
indexes be indexed on reversed
column values for better
index performance.
---------------------------------------------------------------------------------
Temporary tables Y Y Y Y Allows users to manipulate
data for the duration of a
transaction or session.
---------------------------------------------------------------------------------
Development :
===========
AppWizard for Y Y Y Y Simplifies development of
Visual Studio Oracle based applications
(NT only) using Visual Studio.
---------------------------------------------------------------------------------
Autonomous Y Y Y Y Eases complex transaction
transactions programming by enabling
Blocks of PL/SQL to commit
independently of each other.
---------------------------------------------------------------------------------
COM cartridge Y Y Y Y Allows PL/SQL developers to
(NT only) manipulate programmatically
COM objects through the OLE
Automation interface. Entry
points are exposed for
access to the methods
defined by the OLE
Automation interface for
easy application
integration.
---------------------------------------------------------------------------------
iSQL*Plus Y Y Y Y Provides three-tier
implementation of SQL*Plus
running in a web browser.
---------------------------------------------------------------------------------
Java Y Y Y Y Includes Java stored
procedures, methods, and
triggers: EJB, CORBA,
IIOP, HTTP, and native
Java compilation.
---------------------------------------------------------------------------------
JDBC drivers Y Y Y Y Provides JDBC access to
Oracle (JDBC is a Java
call-level interface to
SQL that is standards
compliant and supports
Oracle-specific features.)
---------------------------------------------------------------------------------
Microsoft Y Y Y Y Provides full native
Transaction integration with Microsoft
Server Transaction Server (MTS) to
Integration allow developers to deploy
(NT only) COM-based applications
using MTS against Oracle.
---------------------------------------------------------------------------------
Objects and Y Y Y Y Provides object relational
extensibility functionality, including
object types and methods
and enables database
extensibility via APIs
to database services and
functionality.
---------------------------------------------------------------------------------
PL/SQL native Y Y Y Y Allows PL/SQL byte code to
compilation be converted to C and
dynamically linked into
the database server.
---------------------------------------------------------------------------------
PL/SQL stored Y Y Y Y Provides mechanism to
procedures, deploy logic directly in
triggers the database.
---------------------------------------------------------------------------------
PL/SQL Server Y Y Y Y Server-side Web pages (in
Pages HTML or XML) with embedded
PL/SQL scripts, enabling
rapid development of
dynamic Web pages.
---------------------------------------------------------------------------------
User-defined Y Y Y Y Allows for user defined
aggregates aggregation functionality
such as group-by on object
types and collections to
allow efficient aggregation
for data cartridges.
---------------------------------------------------------------------------------
XML Y Y Y Y Stores XML documents in
the databases via SQL and
renders traditional database
data as XML documents.
---------------------------------------------------------------------------------
Distributed :
===========
Advanced N N Y Y Includes basic replication
Replication plus multi-master
replication functionality.
Advanced Replication
includes online DML during
replication environment
changes, Replication
Manager, and parallel
propagation to maximize
throughput.
---------------------------------------------------------------------------------
Basic Replication Y Y Y Y Provides bi-directional
replication with automated
conflict detection and
resolution supports
configurations that
include a single updatable
master site with multiple
updatable or read-only
snapshot sites.
---------------------------------------------------------------------------------
Distributed Y Y Y Y Allows queries to include
queries tables from multiple
databases.
---------------------------------------------------------------------------------
Distributed Y Y Y Y Allows transactions to
transactions include tables from
multiple databases and
includes transparent
two phase commit
functionality and
XA support.
---------------------------------------------------------------------------------
Heterogeneous Y Y Y Y Allows queries and
Services transactions to involve
Oracle and non-Oracle
databases transparently.
This functionality is used
by Oracle Transparent
Gateways.
---------------------------------------------------------------------------------
Networking :
==========
Connection Manager N N Y Y This feature provides
multiplexing, multiprotocol
connectivity, and network
access control.
---------------------------------------------------------------------------------
Multiprotocol N N Y Y This feature bridges Oracle
connectivity Net Services communities of
users that use different
network protocols such as
SPX/IPX, TCP/IP,
or LU6.2.
---------------------------------------------------------------------------------
High-speed N N Y Y Oracle protocol support
Infiniband now includes support
network support for the industry-standard
Sockets Direct Protocol
(SDP) for Infiniband
high-speed networks.
The SDP protocol is a
high-speed communication
protocol that speeds up
performance of client/
server and server/server
connections. By using
SDP, applications place
most of the messaging
burden upon the network
interface card, freeing
the CPU for other tasks.
---------------------------------------------------------------------------------
Connection pooling Y Y Y Y Enables the server to
time-out idle sessions
and use that connection
to service an active ses-
sion, resulting in more
efficient network usage.
---------------------------------------------------------------------------------
Oracle Net Y Y Y Y Enables heterogeneous,
Services distributed computing
across machines regardless
of vendor, operating
system, or hardware
architecture.
---------------------------------------------------------------------------------
System Management:
=================
Basic Standby Y Y Y Y Allows the DBA to manually
Database clone a database, and to
copy and to apply log files
to the standby. Users can
re-connect to standby
should primary system fail.
---------------------------------------------------------------------------------
Global index Y Y Y Y Automatically maintains
maintenance global indexes when DDL
during DDL operations are executed
operations against partitioned tables.
---------------------------------------------------------------------------------
Legato Storage Y Y Y Y Is an integrated functional-
Manager ity from Legato that allows
backups directly to tapes.
---------------------------------------------------------------------------------
Multiple Block Y Y Y Y Allows a database to have
Size more than one block size.
---------------------------------------------------------------------------------
Online backup Y Y Y Y Allows backups and recovery
and recovery operations to be run while
the database is online.
---------------------------------------------------------------------------------
Oracle Standard N N Y N Oracle Standard Management
Management Pack Pack includes scaled down
functionality from Change
Management, Diagnostics,
and Tuning Packs.
---------------------------------------------------------------------------------
Oracle Enterprise Y Y Y Y A single, integrated console
Manager that allows easy management
and monitoring of the Oracle
and non-Oracle database
environment.
---------------------------------------------------------------------------------
Oracle Fail Safe N N N N Simplifies deployment of
for Oracle highly available single-
on NT instance Oracle database
solutions on Microsoft
Windows NT clusters,
including those on Window
2000 Data Center 4+ nodes.
---------------------------------------------------------------------------------
Oracle Managed Y Y Y Y Automates creation and
Files deletion of physical
database components.
---------------------------------------------------------------------------------
Recovery Manager Y Y Y Y Simplifies setup and
management processes of
the entire backup and
recovery process with
easy to use, wizards
based functionality.
---------------------------------------------------------------------------------
Resumable Space Y Y Y Y Allows execution of large
Allocation database operations to be
suspended and resumed if
there is a repairable
failure.
---------------------------------------------------------------------------------
Standby Database N N Y Y Supports easy installation
GUI and configuration of Standby
and supports monitoring of
critical Standby operations.
---------------------------------------------------------------------------------
Transparent Y Y Y Y Allows complete masking of
Application many failures from end-users
Failover by preserving the state of
their application and
resuming any work that had
been in progress at the
time of failure.
---------------------------------------------------------------------------------
Unused index Y Y Y Y Allows database server to
identification track unused indexes.
---------------------------------------------------------------------------------
Security :
========
Virtual Private N N Y Y This feature provides
Database functionality to create
security policies that
implement row-level
security.
---------------------------------------------------------------------------------
Fine-grained N N Y Y This features allows the
auditing monitoring of database
access based on the
content of the data
accessed.
---------------------------------------------------------------------------------
Enterprise User N N Y Y This features allows the
Security definition of enterprise
users and roles.
---------------------------------------------------------------------------------
N-tier N N Y Y This feature preserves
authentication client identity
authorization throughout all tiers.
---------------------------------------------------------------------------------
Password management Y Y Y Y Provides password
expiration, complexity
and security policy
management.
---------------------------------------------------------------------------------
Encryption Toolkit Y Y Y Y Provides data value
encryption.
---------------------------------------------------------------------------------
Proxy Authentication Y Y Y Y Allows a user to manage
proxy authentication data
in order to authenticate
to multiple other
applications with a
single sign on.
---------------------------------------------------------------------------------
Source:
Oracle® Database Licensing Information 10g Release 1 (10.1)
Part Number B13552-01
Chapter 1 - Oracle Database Editions
No comments:
Post a Comment