How to setting initialization Parameters for Trace File Management
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to setting initialization Parameters for Trace File Management

  1. #1
    Join Date
    Nov 2002
    Posts
    4

    How to setting initialization Parameters for Trace File Management

    How to setting initialization Parameters for Trace File Management?

    TIMED_STATISTICS

    MAX_DUMP_FILE_SIZE

    USER_DUMP_DEST

    THANK IN ADVANCE.
    eagle lin

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hi,
    The USER_DUMP_DEST should be set according to OFA:
    $ORACLE_HOME/admin//udump

    The MAX_DUMP_FILE_SIZE specifies the maximum size of trace files (excluding the alert file).
    MAX_DUMP_FILE_SIZE = {integer [K | M] | UNLIMITED}

    TIMED_STATISTICS should be set to TRUE if you want the statistics to be collected and stored in trace files or displayed in the V$SESSTATS and V$SYSSTATS dynamic performance views.

    init.ora example:

    user_dump_dest = /u01/oracle/admin/orcl/udump
    max_dump_file_size = 10240 # limit trace file size to 1 Meg each
    timed_statistics = true

    Cheers,
    rotem_fo.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width