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

Home -> Community -> Usenet -> c.d.o.server -> Re: Trivia question - file date.

Re: Trivia question - file date.

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 26 Nov 2002 00:21:18 GMT
Message-ID: <3DE2BE75.194A9238@exesolutions.com>


Joel Garry wrote:

> Todays trivia question:
>
> If you don't use read-only tablespaces, and you bounce your database
> weekly, can you have a legitimate Oracle database file dated 6 months
> old?
>
> (assuming 8.1.7 on unix, normal operations with no backup/restore in
> progress, no funny business with "touch," Oracle handling the files,
> not including stuff like installed files and logs.)
>
> .
>
> .
>
> .
>
> .
>
> .
>
> .
>
> .
>
> .
>
> Nearly shot myself in the foot with this one. About six months ago,
> someone added a second temporary sort file. Every once in a while,
> especially on a system I haven't been on in a while, I "clean out the
> garage," including looking for unused large files with a command like
> (depending on your ls and your data file locations):
>
> ls -Rl /oracle |sort -nrk5|more
>
> which normally pops up the data files first, then forgotten exports
> and load files and undropped data files and such. Since Oracle often
> touches the data files (except read-only), thereby updating the file
> system date, old dates stand out like a sore thumb.
>
> So I see a file among the data files with a 6 month old date. select
> * from v$dbfile; not there. Oh wait, select tablespace_name,
> contents from dba_tablespaces; almost missed the locally managed temp
> file. Well, the temp file has a recent date, so the old one isn't
> used, right? Oh wait, select * from dba_temp_files;
>
> Yow! Almost missed that! Seems having _2_ 2G locally managed temp
> files has allowed the second one never to be used, Oracle never
> updating the date. But just waiting for someone to make
> assumptions...
>
> Other answers welcomed.
>
> jg
> --
> @home is bogus
> http://www.garry.to

If you are talking about the operating system date ... you can have one ten years old. The file's date-time is only touched once at the moment of its initial creation.

Daniel Morgan Received on Mon Nov 25 2002 - 18:21:18 CST

Original text of this message

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