View Single Post
  #6 (permalink)  
Old 08-03-2007, 11:17 AM
Murali Murali is offline
D-Web Master
 
Join Date: Feb 2007
Location: India-Chennai.
Posts: 386
Murali is on a distinguished road
Send a message via AIM to Murali
Default Re: Difference between Oracle 9i and 10g

Hi,

Here are some,

Automatic Database Diagnostic Monitor (ADDM).
a. To Produce the Automatic Database reports and Monitoring.
Automatic SQL Tuning.
a. New features to find the automated SQL Tuning Scripts.
DBMS_FILE_TRANSFER Package
a. Its an API to make binary copies of files on the local server or to transfer files between the local server and remote servers.
PL/SQL Enhancements
a. The compiled shared libraries are now stored in the database and extracted as necessary. This means they form part of the
normal backup and recovery process, require no manual maintenance.
b. Nested Tables comes with more flexibility with the enhancement of using collections comparison and types.
c. FOR ALL Syntax can be supportive for Non-Consecutive Index in collections.

And still many more......
__________________
-Murali..
Reply With Quote