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.