Oracle9i New Features
2024-08-29 13:41:43
供稿：網友
原文鏈接：
http://download-west.Oracle.com/otndoc/oracle9i/901_doc/server.901/
a90117/whatsnew.htm
是編號為A90120-20文檔的概括
前些天看到有人問9I的新功能，就隨手翻譯了一下有的地方不準確或者是錯誤的，大家多包涵不清楚的地方請參考文檔，謝謝
Oracle9i Release 1 (9.0.1) New Features
Oracle9i 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. Oracle9i can automatically create and manage the underlying operating system files required by the database. There is a theme of self management.
Oracle9i帶來了一次Oracle數據庫服務器的主要升級。它包括了可以使數據庫更可靠，更多的在線操作替代了離線維護，治理數據庫更有效的新特性。Oracle9i自動治理數據庫需要的操作系統文件。這是自動治理的主題。
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 Oracle9i that are discussed in this book.
下面是Oracle9i新特性的總結。
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.
1. 在線重定義表
新的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.
2. ANALYZE VALIDATE STRUCTURE語句的ONLINE選項
ANALYZE語句現在可以在DML運行的時候提供確認，當目標正在分析的時候。
Controlling Archive Log
Oracle now provides a time-based 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.
3. 控制歸檔日志
Oracle現在提供一種基于時間的方法用來切換目前的在線redo log組。在primary/standby配置中，既所有主站點非當前日志都被歸檔并傳到standby數據庫中，它有效地限制了重做記錄的數量，從時間上考慮，它不使用在standby database上。
Suspending a database
Oracle9i 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.
4. 掛起數據庫
Oracle包括數據庫掛起/恢復特性。ALTER SYSTEM SUSPEND語句通過暫停所有對數據文件和控制文件的輸入輸出（I/O）掛起數據庫。當數據庫被掛起時，所有先前存在的I/9操作被答應執行完畢并且任何新的請求被放在一個狀態隊列中。ALTER SYSTEM RESUME語句恢復正常的數據庫操作。
Quiescing a database
Oracle9i 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
5. 禁用數據庫
Oracle9i答應擁護將數據庫置于一個禁用狀態，只有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.
6. 空間分配可恢復
當大型數據庫操作在空間分配階段失敗時，Oracle提供了一種先掛起，一段時間后恢復執行的機制。它可以答應糾正操作，代替數據庫返回用戶一個錯誤。當錯誤狀態被糾正時，掛起的操作自動恢復。
More archiving destinations
The maximum number of destinations to which you can archive the online redo
log, has been increased from 5 to 10.
7. 更多的歸檔目標文件
歸檔重做日志所用的目標文件的最大數量從5個增加到10個。
Automatic segment- space management Locally managed tablespaces allow extents to be managed automatically by Oracle. Oracle9i 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.
8. 自動分段——空間治理
本地治理的表空間答應擴展段由Oracle自動治理。
Oracle9i也答應本地表空間段中的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. Oracle9i 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.
9. 維護分區的時候更新全局索引
在缺省情況下，許多在分區表上進行的表維護操作使全局索引無效（標志為UNUSABLE）。用戶必須重建全部的全局索引，或者在在分區的情況下，全部它的分區。Oracle9i答應用戶使其無效。當用戶在維護操作的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 4 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.
10. 塊大小多樣化
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
