Re: Oracle 9i new features survey

We use the automated PGA space management, automated MTTR managemsnt, segment level stats, ausotmatic undo, automatic segment space management and list partitioning features predominantly; and they work like a charm.

Arup
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 16, 2003 5:44 PM

> Hi lister:
>
> Just want to know how well you adopt those 9i new features.
> (if you are already 9i)
> and what's your recommendations about those new features.
> (any pros and cons)
>
> TIA
>
> --DJ
> ITResource
>
> ==========================================================
>
> Oracle9i Database Release 1: New Features
>
> ANSI ISO SQL Support In Oracle9i
> Automatic Segment Free Space Management
> Automatic Undo Management
> Bitmap Join Indexes
> Data Guard
> Export And Import Enhancements In Oracle9i
> Flashback Query
> High Availability Enhancements in Oracle9i
> Index Organized Table (IOT) Enhancements in Oracle9i
> Index Skip Scanning
> LOB Enhancements In Oracle9i
> Logminer Enhancements In Oracle9i
> Memory Management In Oracle9i
> Metadata API
> Multiple Block Sizes
> Oracle Managed Files
> Partitioning Enhancements In Oracle9i
> Performance Enhancements In Oracle9i
> Persistent Initialization Parameters
> Real Application Clusters
> Recovery Enhancements In Oracle9i
> Recovery Manager (RMAN) Enhancements In Oracle9i
> Resource Manager Enhancements In Oracle9i
> Resumable Space Allocation
> Scalable Session Management
> Security Enhancements In Oracle9i
> SQL New Features In Oracle9i
> Workspace Management In Oracle9i
> Advanced Queuing In Oracle9i
> External Tables
> Heterogeneous Services
>
> Oracle9i Database Release 2: New Features
> Export BLOB Contents Using UTL_FILE
> DBMS_XPLAN
> Parse XML Documents
> Renaming Columns And Constraints
> UTL_FILE Enhancements
>
>
>
>
>
>
>
>
> _________________________________________________________________
> Protect your PC - get McAfee.com VirusScan Online
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: David Jones
> INET: djones1688_at_hotmail.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: arupnanda_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).