Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
Property | Description |
---|---|
Parameter type | String |
Syntax | MAX_DUMP_FILE_SIZE = { integer [K | M | G] | UNLIMITED } |
Default value | UNLIMITED |
Modifiable | ALTER SESSION , ALTER SYSTEM |
Range of values | 0 to unlimited, or UNLIMITED |
Basic | No |
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.
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.
See Also:
Oracle Database Administrator's Guide and Oracle Database Performance Tuning Guide for more information on setting this parameter