DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2001

    Working on Oracle v8i 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 -

    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 :

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

    Thanks & Regards,


  2. #2
    Join Date
    Jun 2001
    Helsinki. Finland
    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