ORA-00059: maximum number of DB_FILES exceeded
来源:互联网 发布:人民大学网络教育 编辑:程序博客网 时间:2024/06/06 19:51
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as dw
SQL> ALTER TABLESPACE DW_OTH ADD DATAFILE '/oracle/oradata/bidw1/dw_oth15.dbf' SIZE 8000M;
ALTER TABLESPACE DW_OTH ADD DATAFILE '/oracle/oradata/bidw1/dw_oth15.dbf' SIZE 8000M
ORA-00059: maximum number of DB_FILES exceeded
SQL>
原因: init parameters 里的db_files不够大了
解决:
SQL> show parameter db_files;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 200
SQL> alter system set db_files=400 scope=spfile;
SQL>shutdown immediate;
SQL>startup;
SQL> show parameter db_files;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 400
答疑: db_files默认值为200,只是ORACLE对数据文件个数控制的一个参数。参数设置多少对ORACLE本身没有影响,但如果数据文件太多,可能会对ORACLE的性能有点影响,一般问题不大。
- ORA-00059: maximum number of DB_FILES exceeded
- ORA-00059: maximum number of DB_FILES exceeded
- ora-00059 maximum number of DB_FILES exceeded
- ORA-00059: maximum number of DB_FILES exceeded
- ORA-00059: maximum number of DB_FILES exceeded
- ORA-00059:maximum number of DB_FILES exceed 解决
- ORA-00059:maximum number of DB_FILES exceed 报错解决
- ORA-00018:maximum number of sessions exceeded
- ORA-00018: maximum number of sessions exceeded
- ORA-00018: maximum number of sessions exceeded
- ORA-00018: maximum number of sessions exceeded
- ORA-00020: maximum number of processes (%s) exceeded 的解决方法
- ORA-00020: maximum number of processes (%s) exceeded
- ORA-00018: maximum number of sessions exceeded 解决方法
- ORA-00020: maximum number of processes (500) exceeded
- ORA-00020:maximum number of processes (150) exceeded 错误解决方法
- ORA-00020: maximum number of processes (%s) exceeded问题解决过程
- ORA-00018:maximum number of sessions exceeded解决方法
- 解决ReportViewer在CHROME中不能正常显示
- 设计模式6大原则:里氏置换原则
- Android上使用OpenGLES2.0显示YUV数据
- FFMPEG框架分析
- C语言操作符优先级
- ORA-00059: maximum number of DB_FILES exceeded
- 《毛泽东》读书笔记
- JS对象转换为Jquery对象
- 关于跨线程传递MFC对象指针的探究
- android Camera分析
- Oracle 11g Interval分区
- 比特币作为中国最大的新型交易货币正在大幅下跌
- android跑马灯(xml)
- android面试题目大全<完结部分>,android笔试题目集锦