Never say "never". The output from "truss" shows all "system calls"; which includes file opens.
Here is an interesting exercise for those on *nix boxes. >From one window/session do the following ... $ sqlplus >From a different window where you are logged onto the system as root find the pid (process ID) of the SQLPLUS process from 1st window. $ truss -p pid | tee /tmp/capture After the truss command has been initiated go back to the 1st window and enter a valid Oracle username/password to connect to the DB. In the window running the truss you'll see all the various "login" files which SQL*Plus attempts to open before returning control to the user & presenting the SQL> prompt. HTH & YMMV HAND! "Seefelt, Beth" wrote: > > I think that will give you files that it successfully accessed, but not > the ones that were referenced but not found. > > You can do what you're asking on VMS and NT, so it seems like there > should be a way in Unix, although I asked my Unix SA's that same > question a few years back and they said that there isn't. They were > pretty sharp guys so I tend to believe them. > > -----Original Message----- > Sent: Friday, August 09, 2002 11:33 AM > To: Multiple recipients of list ORACLE-L > > > Is there a way to capture all files hit by a process/user in unix (Sun > > Solaris 9, ksh)? I am seeing an OCI file not found on my production > box. > > I can't resovle it. > > So, I want to run the same process on my development box (where it > works) > > and get a list of files that it is hitting (I can grep by username) > for > > comparison in production. Only I am definitely NOT the Unix guru and > as > > this is for a prod issue, so my time is very limited. > > Thanks in advance, > > touch BEFORE; > ... > find $wherever -newer ./BEFORE; > > will give you a list of files that have changed since the > BEFORE file. If you are sure that the files are being > created (vs. modified or accessed) by one specific userid > then: > > find / -newer BEFORE -user <id> > > will work also. > > If you are going to run the thing regularly then take a > look at "find2p", which will spit out a perl script to > match your find command. The perly code will give you > finer control and better sanity checks (e.g., comparing > to a list in memory of what has already been found to > avoid dup's) than find can. > > enjoi. > > -- > Steven Lembark 2930 W. Palmer > Workhorse Computing Chicago, IL 60647 > +1 800 762 1582 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Steven Lembark > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seefelt, Beth > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lack of planning on your part doesn't constitute an emergency on my part! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
