What are the new features in Oracle 10g. Compared to Oracle 9i?

What are the new features in Oracle 10g. Compared to Oracle
9i?

Question Posted / selvaraj v

1 Answers
9332 Views
Polaris, I also Faced
E-Mail Answers

What are the new features in Oracle 10g. Compared to Oracle 9i?..

Answer / kebiraj

# Flashback Enhancements -Flashback Version Query, Flashback
Transaction Query, LOB Handling with Flashback, Setting up
for Flashback, Flashback Table, Flashback Drop Table and
Recycle Bin management.

# Backup and Recovery Enhancements - Flash Recovery Area,
Flashback Database (setup, flashback logs and use), Restore
Points, Simplified Recovery through RESETLOGS, Compressed
Backups, Change Tracking, Incrementally Updated Image
Copies, SWITCH DATABASE, New V$ Views, Encrypted Backups,
DROP DATABASE, CATALOG, Oracle Secure Backup and more.

# Automatic Storage Management - An introduction to Oracle's
new integrated file system and volume manager. Examples
illustrate the basic use of ASM, including creating disk
groups, fail groups, and using ASMCMD.

# Job Scheduler - Use the new DBMS_SCHEDULER package to
schedule jobs, including OS scripts. Examples illustrate
creating and scheduling jobs in both a Linux and a Windows
environment.

# SQL Enhancements - Regular expressions, DML error logging,
case-insensitive sort and search, MERGE enhancements, MODEL
queries, XQUERY and much more.

# PL/SQL Enhancements -The new optimizing compiler, compiler
warning messages, debugging improvements, native compilation
enhancements, UTL_MAIL and more.

# Performance and Tuning Features - Automatic SGA
Management, Automatic Workload Repository (AWR), Advisors
(ADDM, SQL Tuning Advisor, etc), Active Session History
data, new performance statistics (e.g. metrics and database
time), Thresholds and Server-Generated Alerts, CBO
Enhancements and much more.

# Security and Auditing Enhancements - Changes to the
CONNECT Role, FGAC Review, FGAC / VPD Enhancements, FGA
Review, Fine Grained Auditing Enhancements, Encryption
Enhancements, DBMS_CRYPTO Package (R1) and Transparent Data
Encryption (R2).

# Tablespace, Table and Segment Management - SYSAUX
tablespace, BIGFILE and SMALLFILE tablespaces,
database-level default tablespace, database-level default
temp tablespace, temp tablespace groups, multi-platform
transportable tablespace, renaming tablespaces, predicting
object growth, online table redefinition enhancements and
online segment shrink.

# Utilities (Data Pump) - An example-based introduction to
Data Pump, the next generation export / import utility. Also
covered: External Table and Logminer enhancements.

# SQL*Plus Enhancements - New predefined variables, SPOOL
command enhancements, AUTOTRACE enhancements and more.

# Miscellaneous Enhancements - Guaranteed UNDO retention,
ROLLBACK monitoring, Easy Connect (EZCONNECT) connections,
database high watermark recording, database feature usage
tracking and new and deprecated initialization parameters.

Is This Answer Correct ?

16 Yes

3 No

Post New Answer