are 2 OEM (Oracle Enterprise Manager): One for local management (OEM
Database Control) and one for central management (OEM
(a mandatory tablespace) is added in Oracle 10g and keeps metadata for
various tools like LOGMNR, RMAN (Repository catalogue).
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.
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.
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.
10g we can write to an external table (in 9i is possible only to read from an
10g we can transport
tablespaces between different platforms
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).
Shared Memory Management (ASMM):
(in 10.2.0) will be auto-tuned. However some SGA components must be manually sized (DB_KEEP_CACHE_SIZE,
FIXED SGA and ASM instance buffer
Use spfile if you want Oracle to
remember the sizes of auto-tuned parameters across instance shutdowns.
(see Metalink Note:295626.1 )
10g we have a new process MMON
which gather statistics by default at every one hour. The statistics
are stored in AWR.
10g we can use Automatic Undo
Management (AUM). However the manual undo management is used by
default value for OPTIMIZER_MODE
is ALL_ROWS. The rule based
optimizer is unsupported, but technically could be used.
addition to ADDM recommendations we can use SQL Tuning Advisor (STA) or SQL
Access Advisor (SAA: advices on indexes and materialized views).
less files to manage
package (DBMS_FILE_TRANSFER) to
copy files directly from the database level.
Private Database (VPD):
can apply some security rules directly on column levels.