熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle9i New Features

2013-11-13 22:22:38  來源: Oracle 

  原文鏈接
  
  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
  • 上一篇文章:

  • 下一篇文章:
  • 推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.