oracle 9i 后maxdatafiles与db_files的关系

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:156

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

oracle 9i 控制文件 maxdatafiles 会自动扩展 ,自动扩展的值不能超过db_files,
所以我们在规划数据库时,db_files的值一定要设置比较大。

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】