MAX_DUMP_FILE_SIZE is not be used
538022Jun 12 2007 — edited Jul 12 2007Hello 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