Oracle With Examples : Oracle 10g: New Features Overview

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site  -> Oracle DBA

-> Oracle 10g: New Features Overview


 Oracle 10g: New Features Overview



Here are the main features in Oracle Database 10g:


        There are 2 OEM (Oracle Enterprise Manager): One for local management (OEM Database Control) and one for central management (OEM Grid Control).

        The SYSAUX (a mandatory tablespace) is added in Oracle 10g and keeps metadata for various tools like LOGMNR, RMAN (Repository catalogue).

        Flashback technology: a new type of recovery log, called a flashback log enables the Flashback database feature. The Flashback feature allows you to perform queries that return past data, or the history of changes on a particular table, to undo undesirable changes to a particular table. With flashback feature enabled is possible also to recover a table or the entire database to a previous point in time.

        Automatic Storage Management (ASM): Using ASM feature the DBA doesn’t need to maintain thousands of data files or to manage the I/O. All is done automatically and what we have to manage is an ASM instance and a few disk groups. The performance also is improved in the ASM feature.


        Data Pump technology:  enables a faster import/ export. Because the Duta Pump needs more time to start up, for small jobs, the old exp/imp may be faster.

        In 10g we can write to an external table (in 9i is possible only to read from an external tablespace)

        In 10g we can transport tablespaces between different platforms

        Automatic Database Diagnostic Monitor (ADDM): In Oracle 10g the statistics could be gathered automatically and saved in an Automatic Workload Repository (AWR). After these snapshots are taken ADDM run and creates reports about how the performance could be improved (on the hardware and database level).

        Automatic Shared Memory Management (ASMM): The DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, JAVA_POOL_SIZE, STREAMS_POOL_SIZE (in 10.2.0) will be auto-tuned. However some SGA components must be manually sized (DB_KEEP_CACHE_SIZE, DB_RECYCLE_CACHE_SIZE, DB_nK_CACHE_SIZE, LOG_BUFFER, FIXED SGA and ASM instance buffer cache). NOTE: Use spfile if you want Oracle to remember the sizes of auto-tuned parameters across instance shutdowns. (see Metalink Note:295626.1 )

        In 10g we have a new process MMON which gather statistics by default at every one hour. The statistics are stored in AWR.

        In 10g we can use Automatic Undo Management (AUM). However the manual undo management is used by default.


        The default value for OPTIMIZER_MODE is ALL_ROWS. The rule based optimizer is unsupported, but technically could be used.

        In addition to ADDM recommendations we can use SQL Tuning Advisor (STA) or SQL Access Advisor (SAA: advices on indexes and materialized views).

        Bigfile tablespace: less files to manage

        A new package (DBMS_FILE_TRANSFER) to copy files directly from the database level.

        Virtual Private Database (VPD): can apply some security rules directly on column levels.  -> Oracle DBA

-> Oracle 10g: New Features Overview

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...


     Copyright (c) 2018  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.