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...... |