PATCH 1. More space and memory than previous versions 2. Does not support SVRMGRL and Connect InterNal3.DBCA and SYS account security enhancements 4. Server parameter file SPFile automatically manages database initialization file Such as: ALTER SESTEM SET OPEN_CURSORS = 1000 scope = both5 introduced Automatic Undo management simplifies the rollback rollback segment management process step:. 1) create undo tablespace 2) set init parameters: UNDO_MANAGEMENT, UNDO_TABLESPACE, UNDO_SUPPRESS_ERRORS 3) Restart database
6. Space allocation that can be restored to hang a period of time due to space, SUCH AS: Alter Session Enable Resumable
7. Introduce the default temporary table space instead of default is the SYSTEM table space
8. OMF (Oracle Managed Files) function, eliminating the cumbersome manual manual management database files .Note: Need The Following Parameters: 1) DB_CREATE_FILE_DEST: Create all database data files 2) DB_CREATE_ONLINE_LOG_DIST_N: You can use multiple online Redo logs and control files Define up to N = 5 positions
9. Dynamic memory management. You can use the alter system command to dynamically change many memory configurations: You cannot dynamically change some parameters such as java_pool, db_block_buffer_pool_keep, buffer_pool_recycle, and set the SGA_MAX_SIZE parameter must turn off the restart database instance
10. Support multiple database blocks. 9I Allows each TableSpace to assign different blockspaces to each TableSpace (excluding system, temporary, undo, rollback segment table space)
11. Cursor Sharing Settings Parameters Cursor_sharing = force or CURSOR_SHARING = Similar, convert the literal value of the SQL statement into bind variables, reduce the time to analyze SQL
12. Self-adjusted PGA parameters: PGA_AGGREGATE_TARGET
13. Online redefine tables utilize new DBMS_REDEFINITION packages
14. Remove the table space with data files (Including Contents and DataFiles) There are many new features, see Oracle 9i Admin Guide.
