Oracle9i New Features

　　原文鏈接
　　
　　a/
　　是編號為A文檔的概括
　　前些天看到有人問I的新功能就隨手翻譯了一下有的地方不准確或者是錯誤的大家多包涵不清楚的地方請參考文檔謝謝
　　
　　Oraclei Release () New Features
　　Oraclei brings a major new release of the Oracle database server It includ
　　es features to make the database more available More online operations reduce the need for offline maintenance Management of the database requires less effort Oraclei can automatically create and manage the underlying operating system files required by the database There is a theme of self management
　　Oraclei帶來了一次Oracle數據庫服務器的主要升級它包括了可以使數據庫更可靠更多的在線操作替代了離線維護管理數據庫更有效的新特性Oraclei自動管理數據庫需要的操作系統文件這是自動管理的主題
　　
　　Performance is enhanced The Database Resource Manager has new options that allow for more granular control of resources The performance level required of a resource consumer group can be better sustained Partitioning enhancements allow tables and indexes to be better partitioned for performance Security enhancements are an important part of this release Applications have available more and finer grained methods of implementing security and auditing
　　
　　性能得到增強數據庫資源管理器擁有新的選項允許對資源進行更好的控制一組資源消費所要求的性能水平可以得到持續滿足分區增強允許表和索引為性能更好的分區安全增強是這次升級的重要部分應用程序擁有更多更好的執行安全和審計的方法
　　
　　The following are summaries of the new features of Oraclei that are discussed in this book
　　下面是Oraclei新特性的總結
　　
　　Online redefinition of tables
　　The new DBMS_REDEFINITION PL/SQL package provides a mechanism to redefine ta
　　bles online When a table is redefined online it is accessible to DML durin
　　g much of the redefinition process This provides a significant increase in
　　availability compared to traditional methods of redefining tables that require tables to be taken offline
　　 在線重定義表
　　新的PL/SQL包DBMS_REDEFINITION提供了在線重定義表的機制當表被在線重定義的時候在重定義進程中的大多數時刻對DML是可用的與傳統的要求表先離線再重新定義的方法相比顯著地提高了可用性
　　
　　ONLINE option for ANALYZE VALIDATE STRUCTURE statement
　　The ANALYZE statement can now perform validation while DML is ongoing within the object being analyzed
　　 ANALYZE VALIDATE STRUCTURE語句的ONLINE選項
　　ANALYZE語句現在可以在DML運行的時候提供確認當目標正在分析的時候
　　
　　Controlling Archive Log
　　Oracle now provides a timebased means of switching the current online redo log group In a primary/standby configuration where all noncurrent logs of the primary site are archived and shipped to the standby database this effectively limits the number of redo records as measured in time that will not be applied in the standby database
　　 控制歸檔日志
　　Oracle現在提供一種基於時間的方法用來切換目前的在線redo log組在primary/standby配置中既所有主站點非當前日志都被歸檔並傳到standby數據庫中它有效地限制了重做記錄的數量從時間上考慮它不使用在standby database上
　　
　　Suspending a database
　　Oraclei includes a database suspend/resume feature The ALTER SYSTEM SUSPEND statement suspends a database by halting all input and output (I/O) to dat
　　afiles and control files When the database is suspended all preexisting I/O
　　 operations are allowed to complete and any new database accesses are placed in a queued state The ALTER SYSTEM RESUME statement resumes normal databas
　　e operation
　　 掛起數據庫
　　Oracle包括數據庫掛起/恢復特性ALTER SYSTEM SUSPEND語句通過暫停所有對數據文件和控制文件的輸入輸出（I/O）掛起數據庫當數據庫被掛起時所有先前存在的I/操作被允許執行完畢並且任何新的請求被放在一個狀態隊列中ALTER SYSTEM RESUME語句恢復正常的數據庫操作
　　
　　Quiescing a database
　　Oraclei allows you to place the database into a quiesced state where only DBA transactions queries or PL/SQL statements are allowed This quiesced state allows you to perform administrative actions that cannot safely be done
　　 otherwise The ALTER SYSTEM QUIESCE RESTRICTED statement places a database into a quiesced state
　　 禁用數據庫
　　Oraclei允許擁護將數據庫置於一個禁用狀態只有DBA事務查詢或者PL/SQL語句可以執行這個狀態允許用戶進行在其他情況下不能保證安全的管理工作ALTER SYSTEM QUIESCE RESTRICTED語句將數據庫設置為禁用狀態
　　
　　Resumable Space Allocation
　　Oracle provides a means for suspending and later resuming the execution of
　　 large database operations in the event of space allocation failures This enables you to take corrective action instead of the Oracle database server returning an error to the user After the error condition is corrected the suspended operation automatically resumes
　　 空間分配可恢復
　　當大型數據庫操作在空間分配階段失敗時Oracle提供了一種先掛起一段時間後恢復執行的機制它可以允許糾正操作代替數據庫返回用戶一個錯誤當錯誤狀態被糾正時掛起的操作自動恢復
　　
　　More archiving destinations
　　The maximum number of destinations to which you can archive the online redo
　　log has been increased from to
　　 更多的歸檔目標文件
　　歸檔重做日志所用的目標文件的最大數量從個增加到個
　　
　　Automatic segment space management Locally managed tablespaces allow extents to be managed automatically by Oracle Oraclei allows free and used space within segments stored in locally managed tablespaces to also be managed automatically Using the SEGMENT SPACE
　　 MANAGEMENT clause of CREATE TABLESPACE you specify AUTO or MANUAL to specify the type of segment space management Oracle will use
　　 自動分段——空間管理
　　本地管理的表空間允許擴展段由Oracle自動管理Oraclei也允許本地表空間段中的free和used空間自動管理使用CREATE TABLESPACE的SEGMENT SPACE MANAGEMENT子句通過設置AUTO或MANUAL確定Oracle用來管理段空間所使用的方法
　　
　　Update of global indexes when partition maintenance is performed By default many table maintenance operations on partitioned tables invalida
　　te (mark UNUSABLE) global indexes You must then rebuild the entire global i
　　ndex or if partitioned all of its partitions Oraclei allows you to override this default behavior When you specify the UPDATE GLOBAL INDEX clause in your ALTER TABLE statement for the maintenance operation the global index is updated in conjunction with the base table operation
　　 維護分區的時候更新全局索引
　　在缺省情況下許多在分區表上進行的表維護操作使全局索引無效（標志為UNUSABLE）用戶必須重建全部的全局索引或者在在分區的情況下全部它的分區Oraclei允許用戶使其無效當用戶在維護操作的ALTER TABLE語句中聲明UPDATE GLOBAL INDEX子句時全局索引和基表操作一起更新
　　
　　Multiple block sizes
　　Oracle now supports multiple block sizes It has a standard block size as s
　　et by the DB_BLOCK_SIZE initialization parameter and additionally up to n
　　onstandard block sizes Nonstandard block sizes are specified when creating
　　tablespaces The standard block size is used for the SYSTEM tablespace and most other tablespaces Multiple block size support allows for the transporting of tablespaces with unlike block sizes between databases
　　 塊大小多樣化
　　Oracle現在支持多種塊的尺寸數據塊具有一個標准的大小建立表空間時在DB_BLOCK_SIZE初始化參數中設置標准塊大小用於SYSTEM表空間和大多數其他表空間多樣化的塊大小允許數據庫間具有不同塊大小的表空間傳輸
　　
　　Dynamic buffer cache
　　The size of the buffer cache subcomponent of the System Global Area is now dynamic The DB_BLOCK_BUFFERS initialization parameter ha
From:http://tw.wingwit.com/Article/program/Oracle/201311/18924.html