Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MAX_DUMP_FILE_SIZE is not be used

538022Jun 12 2007 — edited Jul 12 2007
Hello guys,
a little question about the parameter MAX_DUMP_FILE_SIZE and its use.

At first my database is running with the following setting:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options

SQL> show parameter max_dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_dump_file_size string 20000

Parameter documentation of oracle:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams116.htm#sthref490

But yesterday a trace file was generated by oracle with round about 10 megabytes.
It was the trace of the mmnl process and in the end of the trace the following line was appended:
*** DUMP FILE SIZE IS LIMITED TO 10240000 BYTES ***

So what? I set max_dump_file_size not to 10 megabyte... how and when does oracle use this parameter and where is the limit size of 10 megabyte specified?

Thanks and Regards
Stefan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2007
Added on Jun 12 2007
6 comments
11,442 views