trace file creation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: trace file creation

  1. #1
    Join Date
    Apr 2001
    Posts
    257
    Hi,

    How does Oracle determine it's time to create a new trace file rather than append the trace messages to the end of the current trace file?

    Thanks,

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Trace files are named based on the id of the process that needs to write to trace. But as process_id numbers are reusable oracle will append information to the existing trace file if one exists with the given process_id in its name. If such file does not exists Oracle will simply create a new one.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jun 2002
    Posts
    65
    Jurig do you mean that if Scott logged in once and then logout login again oracle will be appended the same trace file all the time till another user login to create another trace file...just a little confusion..Thanks

  4. #4
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Actually it isn't linked to the username, but to the server process ID.
    But yes, when another session appears with same shadow process id, it will append to existing trace file.

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