How to limit the trace files and alert file size of Oracle

Each server and background process writes to a trace file. When a-process detects an internal error, it writes information about the error to its trace file. The file name format of a trace file is Sid_processname_unixpid.trc, where:

SID is the instance system identifier

ProcessName is a three or four-character abbreviated process name identifying the Oracle Database process that generated The file (for example, Pmon, DBWR, Ora, or reco)

Unixpid is the operating system process ID number

The following is a sample trace file name:

$ORACLE _BASE/DIAG/RDBMS/MYDB/MYDB/TRACE/TEST_LGWR_1237.TRC

Set the Max_dump_file initialization parameter to at least-ensure that the trace FILE was large enough to store err or information.

Alert Files

The Alert_sid.log file stores information about significant database events and messages. Events that affect the database instance or database is recorded in this file.

The max_dump_file_size parameter defaults to unlimited, and if a large file is generated, it is filled with the file system. A reasonable number should be set to avoid this kind of thing happening.

The max_dump_file_size parameter limits the trace files and the alert FILE size, whose value

1. When given a specific number, it is the number of data blocks of the operating system.
2, when using M or K as the suffix, expressed in M or K units.
3. Unlimited means no limit, as long as OS is allowed. Default

sql> col name format A50;

sql> col type format A10;

sql> col value format A30;

Sql> Show parameter max_dump_file_size;

NAME TYPEVALUE

------------------------------------ ---------- ------------------------------

Max_dump_file_size stringUNLIMITED

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6D/DE/wKioL1VuaC_hyU63AAC-ofdAq6c882.jpg "title=" Qq20150603103054.png "alt=" Wkiol1vuac_hyu63aac-ofdaq6c882.jpg "/>

To modify the Max_dump_file_size parameter:

Sql> alter system set max_dump_file_size= ' 1024m ';

System altered.

Sql> Show parameter max_dump_file_size;

NAME TYPEVALUE

------------------------------------ ---------- ------------------------------

Max_dump_file_size string1024M

Sql>

Modification Done!

This article is from "one van" blog, please be sure to keep this source http://1336014.blog.51cto.com/1326014/1657766

How to limit the trace files and alert file size of Oracle