原文链接
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