Saturday, April 16, 2016

How To Enlarge The Size Of Trace Files

How To Enlarge The Size Of Trace Files

Trace files are limited in size by the MAX_DUMP_FILE_SIZE parameter in the instance parameter file (INIT.ORA). This parameter indicates the maximum size in operating system blocks (usually 512 bytes) the trace file is allowed to grow, Change the value of MAX_DUMP_FILE_SIZE to a larger value to allow for creation of larger trace files.


No comments:

Post a Comment