RE: SQLTrace

From: Morrow, Steve <SMorrow_at_admin.usf.edu>
Date: Fri, 20 Apr 2001 12:56:33 -0700
Message-ID: <F001.002EE404.20010420130125@fatcity.com>

Hi,

Unless something has changed in 8.x, in your parameter file:

Set _trace_files_public = true AND
Set user_dump_dest to a public directory. Make sure oracle has write access to it.

We do this for our developers in our development and preproduction databases.

HTH,
Steve

Steve Morrow
IT/Tech Support
University of South Florida
phone: 813-974-5519
smorrow_at_admin.usf.edu

-----Original Message-----
Sent: Friday, April 20, 2001 3:54 PM
To: Multiple recipients of list ORACLE-L

I've got a developer that says they need the unix password for oracle so they can do a trace and run tkprof without having to jump through a bunch of hoops. Anyone set up trace so someone other than oracle can do this?

The permissions on the trace files only allow reading by the file owner, so setting the user into the dba group won't help.

Thanks, Dave Turner

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Morrow, Steve
INET: SMorrow_at_admin.usf.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Apr 20 2001 - 14:56:33 CDT