测试增大db_files参数值(页 1) - ORACLE等数据库 - LoveUnix 最强AIX小机技术论坛,UNIX,Linux,存储,数据库,中间件,开发,管理

2007-1-5 16:17 Ryan Yakov

测试增大db_files参数值

其实就是一句话，用alter system set db_files=xxx scope=spfile就可以了。
但是网络上有很多人说要修改重建控制文件才能完成云云。
此处就是测试。

在本机的hz2004实例上测试db_files参数扩充。

1。启动本机实例 net start oracleservicehz2004

2。sqlplus "/ as sysdba"
SQL> show parameter db_file;

NAME                               TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
db_file_multiblock_read_count       integer                16
db_file_name_convert                string
db_files                            integer                200

3。SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
C:\ORACLE\ORADATA\HZ2004\SYSTEM01.DBF
C:\ORACLE\ORADATA\HZ2004\UNDOTBS01.DBF
C:\ORACLE\ORADATA\HZ2004\INDX01.DBF
C:\ORACLE\ORADATA\HZ2004\TOOLS01.DBF
C:\ORACLE\ORADATA\HZ2004\USERS01.DBF
C:\HZ2004DATA\HZ2004_CZRK.ORA
C:\HZ2004DATA\HZ2004_MLP.ORA
C:\HZ2004DATA\HZ2004_HXX.ORA
C:\HZ2004DATA\HZ2004_SFZ.ORA
C:\HZ2004DATA\HZ2004_PRM.ORA
C:\HZ2004DATA\HZ2004_PIC.ORA
C:\HZ2004DATA\HZ2004_SYS.ORA
C:\HZ2004DATA\HZ2004_IDX.ORA

13 rows selected

4。选定hz2004_sfz表空间进行测试，增加db_file(默认值为200)-13个文件（就是187个），以达到最大值。
每个数据文件1M。

ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\001.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\002.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\003.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\004.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\005.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\006.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\007.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\008.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\009.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\010.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\011.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\012.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\013.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\014.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\015.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\016.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\017.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\018.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\019.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\020.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\021.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\022.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\023.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\024.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\025.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\026.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\027.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\028.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\029.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\030.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\031.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\032.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\033.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\034.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\035.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\036.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\037.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\038.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\039.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\040.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\041.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\042.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\043.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\044.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\045.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\046.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\047.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\048.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\049.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\050.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\051.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\052.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\053.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\054.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\055.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\056.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\057.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\058.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\059.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\060.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\061.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\062.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\063.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\064.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\065.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\066.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\067.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\068.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\069.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\070.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\071.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\072.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\073.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\074.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\075.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\076.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\077.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\078.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\079.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\080.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\081.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\082.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\083.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\084.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\085.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\086.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\087.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\088.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\089.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\090.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\091.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\092.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\093.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\094.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\095.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\096.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\097.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\098.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\099.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\100.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\101.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\102.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\103.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\104.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\105.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\106.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\107.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\108.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\109.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\110.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\111.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\112.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\113.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\114.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\115.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\116.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\117.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\118.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\119.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\120.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\121.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\122.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\123.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\124.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\125.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\126.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\127.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\128.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\129.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\130.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\131.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\132.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\133.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\134.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\135.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\136.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\137.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\138.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\139.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\140.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\141.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\142.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\143.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\144.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\145.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\146.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\147.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\148.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\149.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\150.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\151.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\152.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\153.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\154.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\155.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\156.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\157.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\158.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\159.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\160.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\161.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\162.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\163.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\164.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\165.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\166.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\167.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\168.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\169.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\170.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\171.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\172.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\173.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\174.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\175.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\176.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\177.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\178.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\179.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\180.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\181.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\182.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\183.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\184.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\185.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\186.ORA' SIZE 1M AUTOEXTEND OFF;
ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\187.ORA' SIZE 1M AUTOEXTEND OFF;

5。查看此时的数据文件数。
SQL> select count(1) from dba_data_files;

      COUNT(1)
      ----------
            200

6。再次增两个数据文件，查看是否报错。
SQL>ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\188.ORA' SIZE 1M AUTOEXTEND OFF;

   ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\188.ORA' SIZE 1M AUTOEXTEND OFF

   ORA-00059: 超出 DB_FILES 的最大值

SQL>ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\189.ORA' SIZE 1M AUTOEXTEND OFF;

   ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\189.ORA' SIZE 1M AUTOEXTEND OFF

   ORA-00059: 超出 DB_FILES 的最大值

7。修改db_file参数为 db_file=203。

SQL> alter system set db_files=203 scope=spfile;

      系统已更改。

8。重启数据库。
SQL> shutdown normal;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup nomount;
ORACLE 例程已经启动。

Total System Global Area  101784276 bytes
Fixed Size                453332 bytes
Variable Size             75497472 bytes
Database Buffers          25165824 bytes
Redo Buffers                667648 bytes
SQL> alter database mount;

数据库已更改。

SQL> alter database open;

数据库已更改。

10。查看已经修改过的此参数值。
SQL> show parameter db_file;

NAME                               TYPE                VALUE
------------------------------------ --------------------- ------------------------------
db_file_multiblock_read_count       integer             16
db_file_name_convert                string
db_files                            integer             203

11。再次扩到202个文件。
SQL> ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\188.ORA' SIZE 1M AUTOEXTEND OFF;

Tablespace altered

SQL> ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\189.ORA' SIZE 1M AUTOEXTEND OFF;

Tablespace altered

12。再次扩到204个文件。
SQL> ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\190.ORA' SIZE 1M AUTOEXTEND OFF;

Tablespace altered

SQL> ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\191.ORA' SIZE 1M AUTOEXTEND OFF;

ALTER TABLESPACE "HZ2004_SFZ" ADD DATAFILE 'C:\HZ2004Data\191.ORA' SIZE 1M AUTOEXTEND OFF

ORA-00059: 超出 DB_FILES 的最大值

13。查看具体的文件分布情况，测试成功。
select file_name, tablespace_name, bytes from dba_data_files;

   FILE_NAME                         TABLESPACE_NAME    BYTES
1 C:\ORACLE\ORADATA\HZ2004\SYSTEM01.DBF SYSTEM             262144000
2 C:\ORACLE\ORADATA\HZ2004\UNDOTBS01.DBF UNDOTBS1    209715200
3 C:\ORACLE\ORADATA\HZ2004\INDX01.DBF INDX             26214400
4 C:\ORACLE\ORADATA\HZ2004\TOOLS01.DBF TOOLS             10485760
5 C:\ORACLE\ORADATA\HZ2004\USERS01.DBF USERS             26214400
6 C:\HZ2004DATA\HZ2004_CZRK.ORA          HZ2004_CZRK    146800640
7 C:\HZ2004DATA\HZ2004_MLP.ORA          HZ2004_MLP    10485760
8 C:\HZ2004DATA\HZ2004_HXX.ORA          HZ2004_HXX    10485760
9 C:\HZ2004DATA\HZ2004_SFZ.ORA          HZ2004_SFZ    13631488
10 C:\HZ2004DATA\HZ2004_PRM.ORA          HZ2004_PRM    167772160
11 C:\HZ2004DATA\HZ2004_PIC.ORA          HZ2004_PIC    115343360
12 C:\HZ2004DATA\HZ2004_SYS.ORA          HZ2004_SYS    10485760
13 C:\HZ2004DATA\HZ2004_IDX.ORA          HZ2004_IDX    335544320
14 C:\HZ2004DATA\001.ORA                   HZ2004_SFZ    1048576
15 C:\HZ2004DATA\002.ORA                   HZ2004_SFZ    1048576
16 C:\HZ2004DATA\003.ORA                   HZ2004_SFZ    1048576
17 C:\HZ2004DATA\004.ORA                   HZ2004_SFZ    1048576
18 C:\HZ2004DATA\005.ORA                   HZ2004_SFZ    1048576
19 C:\HZ2004DATA\006.ORA                   HZ2004_SFZ    1048576
20 C:\HZ2004DATA\007.ORA                   HZ2004_SFZ    1048576
21 C:\HZ2004DATA\008.ORA                   HZ2004_SFZ    1048576
22 C:\HZ2004DATA\009.ORA                   HZ2004_SFZ    1048576
23 C:\HZ2004DATA\010.ORA                   HZ2004_SFZ    1048576
24 C:\HZ2004DATA\011.ORA                   HZ2004_SFZ    1048576
25 C:\HZ2004DATA\012.ORA                   HZ2004_SFZ    1048576
26 C:\HZ2004DATA\013.ORA                   HZ2004_SFZ    1048576
27 C:\HZ2004DATA\014.ORA                   HZ2004_SFZ    1048576
28 C:\HZ2004DATA\015.ORA                   HZ2004_SFZ    1048576
29 C:\HZ2004DATA\016.ORA                   HZ2004_SFZ    1048576
30 C:\HZ2004DATA\017.ORA                   HZ2004_SFZ    1048576
31 C:\HZ2004DATA\018.ORA                   HZ2004_SFZ    1048576
32 C:\HZ2004DATA\019.ORA                   HZ2004_SFZ    1048576
33 C:\HZ2004DATA\020.ORA                   HZ2004_SFZ    1048576
34 C:\HZ2004DATA\021.ORA                   HZ2004_SFZ    1048576
35 C:\HZ2004DATA\022.ORA                   HZ2004_SFZ    1048576
36 C:\HZ2004DATA\023.ORA                   HZ2004_SFZ    1048576
37 C:\HZ2004DATA\024.ORA                   HZ2004_SFZ    1048576
38 C:\HZ2004DATA\025.ORA                   HZ2004_SFZ    1048576
39 C:\HZ2004DATA\026.ORA                   HZ2004_SFZ    1048576
40 C:\HZ2004DATA\027.ORA                   HZ2004_SFZ    1048576
41 C:\HZ2004DATA\028.ORA                   HZ2004_SFZ    1048576
42 C:\HZ2004DATA\029.ORA                   HZ2004_SFZ    1048576
43 C:\HZ2004DATA\030.ORA                   HZ2004_SFZ    1048576
44 C:\HZ2004DATA\031.ORA                   HZ2004_SFZ    1048576
45 C:\HZ2004DATA\032.ORA                   HZ2004_SFZ    1048576
46 C:\HZ2004DATA\033.ORA                   HZ2004_SFZ    1048576
47 C:\HZ2004DATA\034.ORA                   HZ2004_SFZ    1048576
48 C:\HZ2004DATA\035.ORA                   HZ2004_SFZ    1048576
49 C:\HZ2004DATA\036.ORA                   HZ2004_SFZ    1048576
50 C:\HZ2004DATA\037.ORA                   HZ2004_SFZ    1048576
51 C:\HZ2004DATA\038.ORA                   HZ2004_SFZ    1048576
52 C:\HZ2004DATA\039.ORA                   HZ2004_SFZ    1048576
53 C:\HZ2004DATA\040.ORA                   HZ2004_SFZ    1048576
54 C:\HZ2004DATA\041.ORA                   HZ2004_SFZ    1048576
55 C:\HZ2004DATA\042.ORA                   HZ2004_SFZ    1048576
56 C:\HZ2004DATA\043.ORA                   HZ2004_SFZ    1048576
57 C:\HZ2004DATA\044.ORA                   HZ2004_SFZ    1048576
58 C:\HZ2004DATA\045.ORA                   HZ2004_SFZ    1048576
59 C:\HZ2004DATA\046.ORA                   HZ2004_SFZ    1048576
60 C:\HZ2004DATA\047.ORA                   HZ2004_SFZ    1048576
61 C:\HZ2004DATA\048.ORA                   HZ2004_SFZ    1048576
62 C:\HZ2004DATA\049.ORA                   HZ2004_SFZ    1048576
63 C:\HZ2004DATA\050.ORA                   HZ2004_SFZ    1048576
64 C:\HZ2004DATA\051.ORA                   HZ2004_SFZ    1048576
65 C:\HZ2004DATA\052.ORA                   HZ2004_SFZ    1048576
66 C:\HZ2004DATA\053.ORA                   HZ2004_SFZ    1048576
67 C:\HZ2004DATA\054.ORA                   HZ2004_SFZ    1048576
68 C:\HZ2004DATA\055.ORA                   HZ2004_SFZ    1048576
69 C:\HZ2004DATA\056.ORA                   HZ2004_SFZ    1048576
70 C:\HZ2004DATA\057.ORA                   HZ2004_SFZ    1048576
71 C:\HZ2004DATA\058.ORA                   HZ2004_SFZ    1048576
72 C:\HZ2004DATA\059.ORA                   HZ2004_SFZ    1048576
73 C:\HZ2004DATA\060.ORA                   HZ2004_SFZ    1048576
74 C:\HZ2004DATA\061.ORA                   HZ2004_SFZ    1048576
75 C:\HZ2004DATA\062.ORA                   HZ2004_SFZ    1048576
76 C:\HZ2004DATA\063.ORA                   HZ2004_SFZ    1048576
77 C:\HZ2004DATA\064.ORA                   HZ2004_SFZ    1048576
78 C:\HZ2004DATA\065.ORA                   HZ2004_SFZ    1048576
79 C:\HZ2004DATA\066.ORA                   HZ2004_SFZ    1048576
80 C:\HZ2004DATA\067.ORA                   HZ2004_SFZ    1048576
81 C:\HZ2004DATA\068.ORA                   HZ2004_SFZ    1048576
82 C:\HZ2004DATA\069.ORA                   HZ2004_SFZ    1048576
83 C:\HZ2004DATA\070.ORA                   HZ2004_SFZ    1048576
84 C:\HZ2004DATA\071.ORA                   HZ2004_SFZ    1048576
85 C:\HZ2004DATA\072.ORA                   HZ2004_SFZ    1048576
86 C:\HZ2004DATA\073.ORA                   HZ2004_SFZ    1048576
87 C:\HZ2004DATA\074.ORA                   HZ2004_SFZ    1048576
88 C:\HZ2004DATA\075.ORA                   HZ2004_SFZ    1048576
89 C:\HZ2004DATA\076.ORA                   HZ2004_SFZ    1048576
90 C:\HZ2004DATA\077.ORA                   HZ2004_SFZ    1048576
91 C:\HZ2004DATA\078.ORA                   HZ2004_SFZ    1048576
92 C:\HZ2004DATA\079.ORA                   HZ2004_SFZ    1048576
93 C:\HZ2004DATA\080.ORA                   HZ2004_SFZ    1048576
94 C:\HZ2004DATA\081.ORA                   HZ2004_SFZ    1048576
95 C:\HZ2004DATA\082.ORA                   HZ2004_SFZ    1048576
96 C:\HZ2004DATA\083.ORA                   HZ2004_SFZ    1048576
97 C:\HZ2004DATA\084.ORA                   HZ2004_SFZ    1048576
98 C:\HZ2004DATA\085.ORA                   HZ2004_SFZ    1048576
99 C:\HZ2004DATA\086.ORA                   HZ2004_SFZ    1048576
100 C:\HZ2004DATA\087.ORA                   HZ2004_SFZ    1048576
101 C:\HZ2004DATA\088.ORA                   HZ2004_SFZ    1048576
102 C:\HZ2004DATA\089.ORA                   HZ2004_SFZ    1048576
103 C:\HZ2004DATA\090.ORA                   HZ2004_SFZ    1048576
104 C:\HZ2004DATA\091.ORA                   HZ2004_SFZ    1048576
105 C:\HZ2004DATA\092.ORA                   HZ2004_SFZ    1048576
106 C:\HZ2004DATA\093.ORA                   HZ2004_SFZ    1048576
107 C:\HZ2004DATA\094.ORA                   HZ2004_SFZ    1048576
108 C:\HZ2004DATA\095.ORA                   HZ2004_SFZ    1048576
109 C:\HZ2004DATA\096.ORA                   HZ2004_SFZ    1048576
110 C:\HZ2004DATA\097.ORA                   HZ2004_SFZ    1048576
111 C:\HZ2004DATA\098.ORA                   HZ2004_SFZ    1048576
112 C:\HZ2004DATA\099.ORA                   HZ2004_SFZ    1048576
113 C:\HZ2004DATA\100.ORA                   HZ2004_SFZ    1048576
114 C:\HZ2004DATA\101.ORA                   HZ2004_SFZ    1048576
115 C:\HZ2004DATA\102.ORA                   HZ2004_SFZ    1048576
116 C:\HZ2004DATA\103.ORA                   HZ2004_SFZ    1048576
117 C:\HZ2004DATA\104.ORA                   HZ2004_SFZ    1048576
118 C:\HZ2004DATA\105.ORA                   HZ2004_SFZ    1048576
119 C:\HZ2004DATA\106.ORA                   HZ2004_SFZ    1048576
120 C:\HZ2004DATA\107.ORA                   HZ2004_SFZ    1048576
121 C:\HZ2004DATA\108.ORA                   HZ2004_SFZ    1048576
122 C:\HZ2004DATA\109.ORA                   HZ2004_SFZ    1048576
123 C:\HZ2004DATA\110.ORA                   HZ2004_SFZ    1048576
124 C:\HZ2004DATA\111.ORA                   HZ2004_SFZ    1048576
125 C:\HZ2004DATA\112.ORA                   HZ2004_SFZ    1048576
126 C:\HZ2004DATA\113.ORA                   HZ2004_SFZ    1048576
127 C:\HZ2004DATA\114.ORA                   HZ2004_SFZ    1048576
128 C:\HZ2004DATA\115.ORA                   HZ2004_SFZ    1048576
129 C:\HZ2004DATA\116.ORA                   HZ2004_SFZ    1048576
130 C:\HZ2004DATA\117.ORA                   HZ2004_SFZ    1048576
131 C:\HZ2004DATA\118.ORA                   HZ2004_SFZ    1048576
132 C:\HZ2004DATA\119.ORA                   HZ2004_SFZ    1048576
133 C:\HZ2004DATA\120.ORA                   HZ2004_SFZ    1048576
134 C:\HZ2004DATA\121.ORA                   HZ2004_SFZ    1048576
135 C:\HZ2004DATA\122.ORA                   HZ2004_SFZ    1048576
136 C:\HZ2004DATA\123.ORA                   HZ2004_SFZ    1048576
137 C:\HZ2004DATA\124.ORA                   HZ2004_SFZ    1048576
138 C:\HZ2004DATA\125.ORA                   HZ2004_SFZ    1048576
139 C:\HZ2004DATA\126.ORA                   HZ2004_SFZ    1048576
140 C:\HZ2004DATA\127.ORA                   HZ2004_SFZ    1048576
141 C:\HZ2004DATA\128.ORA                   HZ2004_SFZ    1048576
142 C:\HZ2004DATA\129.ORA                   HZ2004_SFZ    1048576
143 C:\HZ2004DATA\130.ORA                   HZ2004_SFZ    1048576
144 C:\HZ2004DATA\131.ORA                   HZ2004_SFZ    1048576
145 C:\HZ2004DATA\132.ORA                   HZ2004_SFZ    1048576
146 C:\HZ2004DATA\133.ORA                   HZ2004_SFZ    1048576
147 C:\HZ2004DATA\134.ORA                   HZ2004_SFZ    1048576
148 C:\HZ2004DATA\135.ORA                   HZ2004_SFZ    1048576
149 C:\HZ2004DATA\136.ORA                   HZ2004_SFZ    1048576
150 C:\HZ2004DATA\137.ORA                   HZ2004_SFZ    1048576
151 C:\HZ2004DATA\138.ORA                   HZ2004_SFZ    1048576
152 C:\HZ2004DATA\139.ORA                   HZ2004_SFZ    1048576
153 C:\HZ2004DATA\140.ORA                   HZ2004_SFZ    1048576
154 C:\HZ2004DATA\141.ORA                   HZ2004_SFZ    1048576
155 C:\HZ2004DATA\142.ORA                   HZ2004_SFZ    1048576
156 C:\HZ2004DATA\143.ORA                   HZ2004_SFZ    1048576
157 C:\HZ2004DATA\144.ORA                   HZ2004_SFZ    1048576
158 C:\HZ2004DATA\145.ORA                   HZ2004_SFZ    1048576
159 C:\HZ2004DATA\146.ORA                   HZ2004_SFZ    1048576
160 C:\HZ2004DATA\147.ORA                   HZ2004_SFZ    1048576
161 C:\HZ2004DATA\148.ORA                   HZ2004_SFZ    1048576
162 C:\HZ2004DATA\149.ORA                   HZ2004_SFZ    1048576
163 C:\HZ2004DATA\150.ORA                   HZ2004_SFZ    1048576
164 C:\HZ2004DATA\151.ORA                   HZ2004_SFZ    1048576
165 C:\HZ2004DATA\152.ORA                   HZ2004_SFZ    1048576
166 C:\HZ2004DATA\153.ORA                   HZ2004_SFZ    1048576
167 C:\HZ2004DATA\154.ORA                   HZ2004_SFZ    1048576
168 C:\HZ2004DATA\155.ORA                   HZ2004_SFZ    1048576
169 C:\HZ2004DATA\156.ORA                   HZ2004_SFZ    1048576
170 C:\HZ2004DATA\157.ORA                   HZ2004_SFZ    1048576
171 C:\HZ2004DATA\158.ORA                   HZ2004_SFZ    1048576
172 C:\HZ2004DATA\159.ORA                   HZ2004_SFZ    1048576
173 C:\HZ2004DATA\160.ORA                   HZ2004_SFZ    1048576
174 C:\HZ2004DATA\161.ORA                   HZ2004_SFZ    1048576
175 C:\HZ2004DATA\162.ORA                   HZ2004_SFZ    1048576
176 C:\HZ2004DATA\163.ORA                   HZ2004_SFZ    1048576
177 C:\HZ2004DATA\164.ORA                   HZ2004_SFZ    1048576
178 C:\HZ2004DATA\165.ORA                   HZ2004_SFZ    1048576
179 C:\HZ2004DATA\166.ORA                   HZ2004_SFZ    1048576
180 C:\HZ2004DATA\167.ORA                   HZ2004_SFZ    1048576
181 C:\HZ2004DATA\168.ORA                   HZ2004_SFZ    1048576
182 C:\HZ2004DATA\169.ORA                   HZ2004_SFZ    1048576
183 C:\HZ2004DATA\170.ORA                   HZ2004_SFZ    1048576
184 C:\HZ2004DATA\171.ORA                   HZ2004_SFZ    1048576
185 C:\HZ2004DATA\172.ORA                   HZ2004_SFZ    1048576
186 C:\HZ2004DATA\173.ORA                   HZ2004_SFZ    1048576
187 C:\HZ2004DATA\174.ORA                   HZ2004_SFZ    1048576
188 C:\HZ2004DATA\175.ORA                   HZ2004_SFZ    1048576
189 C:\HZ2004DATA\176.ORA                   HZ2004_SFZ    1048576
190 C:\HZ2004DATA\177.ORA                   HZ2004_SFZ    1048576
191 C:\HZ2004DATA\178.ORA                   HZ2004_SFZ    1048576
192 C:\HZ2004DATA\179.ORA                   HZ2004_SFZ    1048576
193 C:\HZ2004DATA\180.ORA                   HZ2004_SFZ    1048576
194 C:\HZ2004DATA\181.ORA                   HZ2004_SFZ    1048576
195 C:\HZ2004DATA\182.ORA                   HZ2004_SFZ    1048576
196 C:\HZ2004DATA\183.ORA                   HZ2004_SFZ    1048576
197 C:\HZ2004DATA\184.ORA                   HZ2004_SFZ    1048576
198 C:\HZ2004DATA\185.ORA                   HZ2004_SFZ    1048576
199 C:\HZ2004DATA\186.ORA                   HZ2004_SFZ    1048576
200 C:\HZ2004DATA\187.ORA                   HZ2004_SFZ    1048576
201 C:\HZ2004DATA\188.ORA                   HZ2004_SFZ    1048576
202 C:\HZ2004DATA\189.ORA                   HZ2004_SFZ    1048576
203 C:\HZ2004DATA\190.ORA                   HZ2004_SFZ    1048576

2007-1-7 20:38 boypoo

写的很认真,加个精华!

事实上,oracle文档说得很明白了
[quote]
DB_FILES[table=98%][tr]PropertyDescription[/tr][tr][td]Parameter type[/td][td]Integer[/td][/tr][tr][td]Default value[/td][td][font=新宋体]200[/font][/td][/tr][tr][td]Modifiable[/td][td]No[/td][/tr][tr][td]Range of values[/td][td]Minimum: the largest among the absolute file numbers of the datafiles in the database Maximum: operating system-dependent
[/td][/tr][tr][td]Basic[/td][td]No[/td][/tr][tr][td]Real Application Clusters[/td][td]Multiple instances must have the same value.[/td][/tr][/table]

[font=新宋体]DB_FILES[/font] specifies the maximum number of database files that can be opened for this database. The maximum valid value is the maximum number of files, subject to operating system constraint, that will ever be specified for the database, including files to be added by [font=新宋体]ADD DATAFILE[/font] statements.
If you increase the value of [font=新宋体]DB_FILES[/font], then you must shut down and restart all instances accessing the database before the new value can take effect. If you have a primary and standby database, then they should have the same value for this parameter.
[/quote]
上述内容贴自
[b]Oracle® Database Reference
10[i]g[/i] Release 2 (10.2)
[/b]Part Number B14237-01

页: [1]

查看完整版本: 测试增大db_files参数值