- 論壇徽章:
- 0
|
本文摘自
Oracle® Database Administrator's Guide
10g Release 2 (10.2)
Part Number B14231-02
控制SYSAUX的體積（Controlling the Size of the SYSAUX Tablespace）
SYS表空間中組件的數(shù)量(見表Table 2-2),還有這些組件占用的總空間量，這是組件占用的空間，反之，數(shù)據(jù)庫工作負(fù)載的性質(zhì)取決于所使用的特性或功能。
（The SYSAUX tablespace is occupied by a number of database components (see Table 2-2), and its total size is governed by the space consumed by those components. The space consumed by the components, in turn, depends on which features or functionality are being used and on the nature of the database workload.）
占用SYSAUX表空間最多的是自動(dòng)負(fù)載信息庫（Automatic Workload Repository，AWR）。AWR占用的空間取決于幾個(gè)因素，特定時(shí)間內(nèi)系統(tǒng)中的活動(dòng)會(huì)話數(shù)，快照的間隔，歷史數(shù)據(jù)保留周期。典型情況，平均30個(gè)并發(fā)活動(dòng)會(huì)話的AWR大約需要200MB到300MB的空間。通過修改快照的間隔和歷史記錄的保留周期你可以控制AWR的體積。管理AWR快照間隔和保留時(shí)間的更多資料參考Oracle 數(shù)據(jù)庫性能調(diào)優(yōu)手冊(cè)。
（The largest portion of the SYSAUX tablespace is occupied by the Automatic Workload Repository (AWR). The space consumed by the AWR is determined by several factors, including the number of active sessions in the system at any given time, the snapshot interval, and the historical data retention period. A typical system with an average of 30 concurrent active sessions may require approximately 200 to 300 MB of space for its AWR data. You can control the size of the AWR by changing the snapshot interval and historical data retention period. For more information on managing the AWR snapshot interval and retention period, please refer to Oracle Database Performance Tuning Guide.）
另一個(gè)占用SYSAUX表空間較多的是EM信息庫，這個(gè)倉庫是用于Oracle EM數(shù)據(jù)庫控制來存儲(chǔ)元數(shù)據(jù)，信息庫的體積取決于數(shù)據(jù)庫的活動(dòng)情況和信息庫中存儲(chǔ)的相關(guān)配置信息。
（Another major occupant of the SYSAUX tablespace is the embedded Enterprise Manager (EM) repository. This repository is used by Oracle Enterprise Manager Database Control to store its metadata. The size of this repository depends on database activity and on configuration-related information stored in the repository.）
在SYSAUX表空間中其它數(shù)據(jù)庫組件占用空間增長與它們相關(guān)的特性（例如，Oracle UltraSearch, Oracle文本, Oracle流）是否使用有關(guān)。如果這些特性沒有被使用，這些組件對(duì)于SYSAUX空間沒有顯著影響。
（Other database components in the SYSAUX tablespace will grow in size only if their associated features (for example, Oracle UltraSearch, Oracle Text, Oracle Streams) are in use. If the features are not used, then these components do not have any significant effect on the size of the SYSAUX tablespace.） |
|
免費(fèi)注冊(cè)
發(fā)表于 2011-08-10 22:56
