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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).