-
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.
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|