nah there were enough English roses in display in Oz on Saturday.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1069636556.33627_at_yasure...
> Niall Litchfield wrote:
>
> > "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
> > news:3fc111ee$0$13984$afc38c87_at_news.optusnet.com.au...
> >
> >>>But isn't that also in the data dictionary tables?
> >>>
> >>>SELECT file_name, status
> >>>FROM dba_data_Files;
> >>
> >>This one I haven't checked, but dba_data_files is a view. Views are
built
> >
> > on
> >
> >>top of tables... or, as with the v$ views, pull their information direct
> >
> > out
> >
> >>of the control file. So I suspect that dba_data_files is just looking,
> >>ultimately, at the control file.
> >
> >
> > Interest piqued
> >
> > <caveat>
> > following investigation beer induced and so liable to even more
inaccuracy
> > than usual
> > </caveat>
> >
> > The relevant columns come from x$kccfn and x$ktfbhc
> >
> > Now the file name comes from x$kccfn which appears in bug 2710321 which
> > tells me that this table accesses the datafile headers - and don't have
many
> > small datafiles.
> > The status comes from x$ktfbhc which also appears to be a read of the
> > datafiles themselves.
> >
> > I think this suggests that
> >
> > 1. this information is dynamically derived from base files, but the
files
> > involved are the data files and not the control files.
> > 2. metalink has its uses
> > 3. isn't beer supposed to make me chase sex not v$ definitions, still my
> > wife is probably happy this way :(
> >
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> > ******************************************
>
> Sounds like time to buy a dozen roses. ;-)
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Mon Nov 24 2003 - 03:26:01 CST
