We are using automatic undo management and automatic memory management (pga aggregate target) both with much success.
-----Original Message----- Sent: Thursday, January 16, 2003 5:45 PM To: Multiple recipients of list ORACLE-L 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: Toepke, Kevin M 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).
