MAX_DUMP_FILE_SIZE

来源：互联网发布：阿里健康大药房数据编辑：程序博客网时间：2024/05/16 08:31

MAX_DUMP_FILE_SIZE specifies the maximum size of trace files (excluding the alert file). Change this limit if you are concerned that trace files may use too much space.

MAX_DUMP_FILE_SIZE 指定trc文件的最大值（不包括alert文件）

A numerical value for MAX_DUMP_FILE_SIZE specifies the maximum size in operating system blocks.
单独一个数值的话指系统块的数目
A number followed by a K or M suffix specifies the file size in kilobytes or megabytes.
The special value string UNLIMITED means that there is no upper limit on trace file size. Thus, dump files can be as large as the operating system permits.

SQL>  alter system set max_dump_file_size= '1k' scope=spfile;System altered.SQL> startup force;ORACLE instance started.

SQL> create table liang(id int);Table created.SQL> show parameter max_dump_file_sizeNAME                                 TYPE------------------------------------ ----------------------VALUE------------------------------max_dump_file_size                   string1KSQL>

************************************************************************Thu Jan 22 03:34:15 2015create table liang(id int)Thu Jan 22 03:34:52 2015<span style="color:#ff0000;">Non critical error ORA-48913 caught while writing to trace file "/export/11g/diag/rdbms/orcl1/orcl/trace/orcl_j000_15547.trc"</span>Error message: ORA-48913: Writing into trace file failed, file size limit [1000] reachedWriting to the above trace file is disabled for now on...Thu Jan 22 03:39:14 2015Starting background process SMCOThu Jan 22 03:39:14 2015SMCO started with pid=25, OS id=15654

0 0