MAX_DUMP_FILE_SIZE

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.

Note:

1. The default unit is OS blocks, so for example, if your logical file system block size is 512 bytes and you do not want to exceed 5 Mg for the trace file size, you would set the MAX_DUMP_FILE_SIZE to 10,000.

As of Oracle 8, MAX_DUMP_FILE_SIZE can accept a numerical value or a number followed by the suffix "K", or "M".

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘MAX_DUMP_FILE_SIZE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
max_dump_file_size	UNLIMITED	TRUE	TRUE	IMMEDIATE	TRUE	FALSE	Maximum size (blocks) of dump file

Oracle initializatoin parameters