| performance
enhancements |
| Query
rewrite: |
|
|
|
|
New query
rewrite features mean that you can force queries to always be re-written
(QUERY_REWRITE_ENABLED=FORCE option) and also force OLAP queries containing grouping
functions to be re-written as an equivalent "union all" statement for the groupings
(EXPAND_GSET_TO_UNION hint). |
|
| Data
compression: |
|
|
|
| Better data
segment compression ratios when reading into the buffer cache. |
|
| New
advisory service: |
|
|
|
| Shared Pool advisory
statistics (like the buffer cache advisory in 9i Release 1) can show how the shared pool
will perform in different circumstances. A similar advisory for the PGA_AGGREGATE_TARGET
is also available. A new advisory service is also included for tuning Mean Time To Recover
(MTTR) settings. All these advisory services can be visually accessed through the
Enterprise Manager. |
|
| Rollback
management: |
|
|
|
| In an effort to reduce administration overheads, it is now possible to have the system manage it's own rollback segments (now known as "undo" segments) by specifying the undo tablespace and undo management type in the parameter file. The system-managed undo tablespace is essentially a locally managed tablespace with space managed by a bitmap in the file header. |
|
| rman enhancements |
|
| Parameter
files: |
|
|
|
|
RMAN
can now backup Server Parameter Files. |
|
| Controlfile
autobackup:: |
|
|
|
| This
feature enables automatic backup of the controlfile and
spfile after structural changes have been made
to the database. |
|
| Archive
log management: |
|
|
|
| Can limit disk
space used by RMAN when restoring archive logs for recovery and when backing up, meaning
the DBA can set a space limit and then not have to worry about archive log space
management. |
|
| Tags: |
|
|
|
| Tags are now
automatically generated if not specifically assigned. |
|
| Dbnewid: |
|
|
|
|
|
| Can alter a
DBID or database name using the new DBNEWID utility. |
|
| New
views: |
|
|
|
| Include
V$database_block_corruption (rc_database_block_corruption) and v$database_incarnation
(rc_database_incarnation). |
|
| data integration enhancements |
|
| Oracle
Streams: |
|
|
|
|
Oracle Streams
is a new utility that essentially unites the old replication, data loading, message
queue management and event notification features under one integrated solution. |
| The
utility captures data (be it new data or changes to existing
data, events or messages) into a staging area where
they can be optionally manipulated as required. Data changes
can even be captured directly from the redo logs using the
Log Miner. |
| Once in the staging area,
information can be manipulated as required and is then consumed
either by an application (messages or events) or by an "apply engine"
which can apply data to the relevant database (including non-Oracle
databases through the Transparent Gateway). |
|
| enterprise manager enhancements |
|
| Manageability
enhancements: |
|
|
|
| This has now been
expanded to include all the new management features to become a one stop solution for all
the various manageability enhancements such as Oracle Streams, Oracle OLAP, XML DB
monitoring, SGA sizing, Real Application Clustering, Advanced Queuing, Log Miner,
and resumable space operations. |
| Also includes
the ability to display SQL statement results in graphical table format and data cloning
functions for duplicating schemas. |
|
| globilisation technologies |
|
| Multi-characterset support: |
|
|
|
| Release
9.2 sees further enhancements to Oracle's Unicode support,
including improved performance, Unicode
3.1 support for UTF-8 and UTF-16 datatypes, implicit and explicit
conversion between Unicode and non-Unicode datatypes and
supplementary support for an extra million characters. |
| In addition
PL/SQL Object types now support NCHAR datatypes and multi-language debugging features
are integrated into PL/SQL and Java. |
|
| business intelligence enhancements |
| A raft of new features include: |
|
|
| Partitioning: |
|
|
A new composite
List-Range partition type is available as well as new fast partition splitting capabilities. |
|
| Parallellism: |
|
|
|
| Parallel DML can be performed on non-partitioned tables. |
|
| OLAP: |
|
|
|
| Oracle
OLAP is now fully integrated into the database providing
all the scalability you would come
to expect from Oracle products. |
|
| |
<<
previous page |
|
|
|
020 8465 9100 
Sales
Enquiries
Other Enquiries
