暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

MAX_DUMP_FILE_SIZE(Database Reference)

原创 Jeff 2022-12-01
685

MAX_DUMP_FILE_SIZE

MAX_DUMP_FILE_SIZE specifies the maximum size of trace files (excluding the alert log).

PropertyDescription

Parameter type

String

Syntax

MAX_DUMP_FILE_SIZE = { integer [K | M | G] | UNLIMITED }

Default value

UNLIMITED

Modifiable

ALTER SESSIONALTER SYSTEM

Modifiable in a PDB

Yes

Range of values

0 to unlimited, or UNLIMITED

Basic

No

You can change this limit if you are concerned that trace files may use too much space.

  • A numeric value for MAX_DUMP_FILE_SIZE specifies the maximum size in operating system blocks.

  • A numeric value followed by a K or M or G suffix specifies the file size in kilobytes, megabytes, or gigabytes.

  • 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.

When the trace file is limited in size, it may be automatically split into multiple files, called segments, if needed. This process is call trace file segmentation. The segments will have the same file name as the active trace file, but with an extra segment number appended.

The trace file can be split into a maximum of 5 segments, and the size of each segment will typically be 1/5th of the trace file limit.

When the combined size of all the trace file segments exceeds the specified limit, the oldest segment is deleted, and a new, empty segment is created. Thus, the trace file always contains the most recent trace information. The first segment is never deleted, because it may contain relevant information about the initial state of the process.

Note that trace file segmentation will not occur when this parameter is set to a value less than 25 MB.

See Also:

Oracle Database Administrator’s Guide and Oracle Database SQL Tuning Guide for more information on setting this parameter

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论