_TRACE_FILES_PUBLIC INIT.ORA PARAMETER!

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.

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.

Quote:

---

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

---

Oh boy :-) 2 books by Oracle, what to start with :-))