Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: tracing oracle filesystem access

Re: tracing oracle filesystem access

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: 2006-01-12 11:52:37
Message-id: 20060112105237.15632.qmail@web33101.mail.mud.yahoo.com


Hi Max,

I agree with Niall, at least if it's possible to change the code.

One thing that you might also want to consider whilst checking dependencies is to cross-reference these with the timestamps of files changed on your server. Depending on the application and how much other activity is happening on your server, unix "find" may not produce too much noise to manually sift through. Otherwise you could consider using something like tripwire.

Charlotte

>What version are you on? If you can I'd strongly
suggest you move to using directory objects and then set utl_file_dir to null.
>
>As for auditing I like the dependency idea suggested
elsewhere. It might be a good time to ensure that each source code file gets a header detailing prupose, dependencies and so on...
>
>
>
>--
>Niall Litchfield
>Oracle DBA
>http://www.niall.litchfield.dial.pipex.com



Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 12 2006 - 11:52:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US