_TRACE_FILES_PUBLIC INIT.ORA PARAMETER!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: _TRACE_FILES_PUBLIC INIT.ORA PARAMETER!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi!

    Working on Oracle v8i 8.1.6.0.0 with OS as NT!

    I have this query:

    1.Say My Application developers would like to execute
    TKPROF utility to tune few sql queries!

    I tried to change the INIT.ORA parameter on the server -
    _TRACE_FILES_PUBLIC = TRUE.

    After this what other parameters should I enable/put in the INIT.ORA File so that the developers could execute
    TKPROF and see the output file generated!

    What is the significance and functionality of :
    _TRACE_FILES_PUBLIC = TRUE.

    2.Any idea about the new features and add ons on Oracle 9i.

    Thanks & Regards,

    Amit.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Trace files are created by users, but they are owned by the database. This is a security feature that can be bypassed by setting the hidden parameter "_trace_files_public = true" in the "init.ora" file. This is not a secure thing to do because many trace files include hex dumps of potentially sensitive data.


    2.Any idea about the new features and add ons on Oracle 9i.
    Oh boy :-) 2 books by Oracle, what to start with :-))


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