undo segment的创建、在线以及extent的分配原则。

doc解释的很清楚,看doc吧

The number of undo segments created and brought online is a function of the SESSIONS parameter. The algorithm is roughly 1 undo segment for each 5 sessions. All undo segments are placed online when the sessions parameter is set to 46 or greater. The lower limit was not tested, as the minimum value for the sessions parameter in the test database was 16, which was derived from the minimum number of processes (10) for the database. These are sized according to the autoallocate algorithm for locally managed tablespaces. The basic algorithm is that the first 16 extents are 64k in size. The subsequent allocation method is the next 63 extents of 1m, the next 120 extents of 8m and all additional extents at 64m.

[@more@]

When the undo tablespace is created, a number of undo segments are created. These are named using the _SYSSMU$ algorithm. Because of the new name, some commands (alter system dump undo header) require that the undo segment name be enclosed in double quotes. The number of undo segments created and brought online is a function of the SESSIONS parameter. The algorithm is roughly 1 undo segment for each 5 sessions. All undo segments are placed online when the sessions parameter is set to 46 or greater. The lower limit was not tested, as the minimum value for the sessions parameter in the test database was 16, which was derived from the minimum number of processes (10) for the database. These are sized according to the autoallocate algorithm for locally managed tablespaces. The basic algorithm is that the first 16 extents are 64k in size. The subsequent allocation method is the next 63 extents of 1m, the next 120 extents of 8m and all additional extents at 64m. The first block of the first undo extent is reserved as the header and not indicated in the data dictionary views. As with Oracle 8, the second block of the undo segment is not used initially and may or may not be allocated at a later time. This is one of those anomalies that has no consistent pattern and is therefore hard to explain.

--=====================================

SQL> connect / as sysdba
已连接。
SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> show parameter process

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 25
SQL> show parameter session

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
session_cached_cursors integer 20
session_max_open_files integer 10
sessions integer 170
shared_server_sessions integer
SQL> select segment_name,segment_id,status from dba_rollback_segs order by statu
s;

SEGMENT_NAME SEGMENT_ID STATUS
------------------------------ ---------- ----------------
_SYSSMU19$ 19 OFFLINE
_SYSSMU18$ 18 OFFLINE
_SYSSMU20$ 20 OFFLINE
RBS2 2 OFFLINE
_SYSSMU12$ 12 ONLINE
_SYSSMU13$ 13 ONLINE
_SYSSMU14$ 14 ONLINE
_SYSSMU15$ 15 ONLINE
_SYSSMU16$ 16 ONLINE
_SYSSMU17$ 17 ONLINE
_SYSSMU11$ 11 ONLINE

SEGMENT_NAME SEGMENT_ID STATUS
------------------------------ ---------- ----------------
_SYSSMU4$ 4 ONLINE
_SYSSMU3$ 3 ONLINE
SYSTEM 0 ONLINE
_SYSSMU1$ 1 ONLINE

已选择15行。

SQL>

--当processes=25时,实例启动时自动online了10个undo segment(rbs2是手段管理的,system是系统的都不需要管)还有3个是offline,25个processes对应的sessions是:25×1.1+5=33 33/5=7事实上安装doc的解释online 7个其实就够了...

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1020835/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/19602/viewspace-1020835/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值