Interested to Buy Any Domain ? << Click Here >> for more details...
What are the new features in Oracle 10g. Compared to Oracle
9i?
- 1 Answers
- 9945 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What is bulk collect in pl sql?
Why is there a need for sqlcode and sqlerrm variables?
How do I make my sql query run faster?
What are the types of subqueries?
How do I view a sql trace file?
What is rownum?
What is inner join in sql?
List different type of expressions with the example.
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
How do I view tables in sql developer?
Explain the select statement in sql?
How do I find duplicates in two columns?
How to read/write files from pl/sql?
how tsql statements can be written and submitted to the database engine? : Transact sql
