| 原文链接： 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语句恢复正常的数据库操作。(责任编辑：admin) |