oracle 9i 后 maxdatafiles 与db_files的关系
Problem Description
-------------------
The "alert.log" file shows the following message:
kccrsz: expanded controlfile section 4 from 17 to 18 records
number of logical blocks in section remains at 2
Completed: alter tablespace tb1 add datafile
Solution Description
--------------------
Starting in Oracle8 the controlfile is automatically expanded.
A new datafile is added beyond the maxdatafiles limited specified
in the control file.
This also happens if new records are added to the "log_history" section of
the control files and there are no entries that could be replaced.
The routine that performs the expansion writes this message to the alert log.
The messages specifies the section that was expanded and the amount of
the expansion. Please note that this message cannot be turned off.
The automatic expansion only occurs up to the limit of the "init.ora" parameter
"DB_FILES".
References:
-----------
Server SQL Reference: create controlfile
Additional Search Words
-----------------------
kccrsz controlfile expanded
-------------------
The "alert.log" file shows the following message:
kccrsz: expanded controlfile section 4 from 17 to 18 records
number of logical blocks in section remains at 2
Completed: alter tablespace tb1 add datafile
Solution Description
--------------------
Starting in Oracle8 the controlfile is automatically expanded.
A new datafile is added beyond the maxdatafiles limited specified
in the control file.
This also happens if new records are added to the "log_history" section of
the control files and there are no entries that could be replaced.
The routine that performs the expansion writes this message to the alert log.
The messages specifies the section that was expanded and the amount of
the expansion. Please note that this message cannot be turned off.
The automatic expansion only occurs up to the limit of the "init.ora" parameter
"DB_FILES".
References:
-----------
Server SQL Reference: create controlfile
Additional Search Words
-----------------------
kccrsz controlfile expanded
oracle 9i 控制文件 maxdatafiles 会自动扩展 ，自动扩展的值不能超过db_files,
所以我们在规划数据库时，db_files的值一定要设置比较大。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7199859/viewspace-761661/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 《手把手教你用AI安装Oracle 19c（附详细步骤）》
- 《3小时手工安装Oracle，用AI只需15分钟》
- oracle 20c 不支持non-cdb架构
- 当删除oracle数据库user时发生row cache lock 等待事件
- 通过 Oracle_Cloud_Infrastructure oci 云认证考试
- ORA-32021: parameter value longer than 255 characters 解决方法
- online清理oracle 监听日志推荐的做法
- 分享查看统计信息非常好的脚本
- impdp 导入 schema的数据时会自动创建对应的用户
- 如何移动asm磁盘组内的数据文件到另外一个磁盘组
