db cache size in oracle 9ir2

[Database Administrator]

"Niall Litchfield" wrote in message
news:3fc12f0a$0$28695$cc9e4d1f@news.dial.pipex.com ...
> "Howard J. Rogers" wrote in message
> news:3fc111ee$0$13984$afc38c87@news.optusnet.com.a u...
> > >
> > > 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
>
>
> following investigation beer induced and so liable to even more
inaccuracy
> than usual
>
>
> 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

Oh well, I did say I hadn't checked that one. It makes sense, though. I
stand by the comments on the V$'s though (unless someone knows better).

Thanks for the heads-up... always good to learn something new. Even if it is
that I'm supposed to be teaching RAC tomorrow, in New Zealand, with no
flights booked, no hotel booked, and no class setup preparation time!

Land of the long white rugby losers, I guess here I come, but it won't be
pretty.

Regards
HJR

[Database Administrator]

Niall Litchfield wrote:

> "Howard J. Rogers" wrote in message
> news:3fc111ee$0$13984$afc38c87@news.optusnet.com.a u...
>
>>>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
>
>
> following investigation beer induced and so liable to even more inaccuracy
> than usual
>
>
> 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/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Database Administrator]

Niall Litchfield wrote:

> "Howard J. Rogers" wrote in message
> news:3fc111ee$0$13984$afc38c87@news.optusnet.com.a u...
>
>>>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
>
>
> following investigation beer induced and so liable to even more inaccuracy
> than usual
>
>
> 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/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Database Administrator]

Niall Litchfield wrote:

> "Howard J. Rogers" wrote in message
> news:3fc111ee$0$13984$afc38c87@news.optusnet.com.a u...
>
>>>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
>
>
> following investigation beer induced and so liable to even more inaccuracy
> than usual
>
>
> 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/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Database Administrator]

nah there were enough English roses in display in Oz on Saturday.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Daniel Morgan" wrote in message
news:1069636556.33627@yasure...
> Niall Litchfield wrote:
>
> > "Howard J. Rogers" wrote in message
> > news:3fc111ee$0$13984$afc38c87@news.optusnet.com.a u...
> >
> >>>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
> >
> >
> > following investigation beer induced and so liable to even more
inaccuracy
> > than usual
> >
> >
> > 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/e...ad/oad_crs.asp
> http://www.outreach.washington.edu/e...oa/aoa_crs.asp
> damorgan@x.washington.edu
> (replace 'x' with a 'u' to reply)
>

[Database Administrator]

nah there were enough English roses in display in Oz on Saturday.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Daniel Morgan" wrote in message
news:1069636556.33627@yasure...
> Niall Litchfield wrote:
>
> > "Howard J. Rogers" wrote in message
> > news:3fc111ee$0$13984$afc38c87@news.optusnet.com.a u...
> >
> >>>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
> >
> >
> > following investigation beer induced and so liable to even more
inaccuracy
> > than usual
> >
> >
> > 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/e...ad/oad_crs.asp
> http://www.outreach.washington.edu/e...oa/aoa_crs.asp
> damorgan@x.washington.edu
> (replace 'x' with a 'u' to reply)
>

[Database Administrator]

nah there were enough English roses in display in Oz on Saturday.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Daniel Morgan" wrote in message
news:1069636556.33627@yasure...
> Niall Litchfield wrote:
>
> > "Howard J. Rogers" wrote in message
> > news:3fc111ee$0$13984$afc38c87@news.optusnet.com.a u...
> >
> >>>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
> >
> >
> > following investigation beer induced and so liable to even more
inaccuracy
> > than usual
> >
> >
> > 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/e...ad/oad_crs.asp
> http://www.outreach.washington.edu/e...oa/aoa_crs.asp
> damorgan@x.washington.edu
> (replace 'x' with a 'u' to reply)
>

[Database Administrator]

"Howard J. Rogers" wrote in message
news:3fc1337c$0$14031$afc38c87@news.optusnet.com.a u...
> Oh well, I did say I hadn't checked that one. It makes sense, though. I
> stand by the comments on the V$'s though (unless someone knows better).

well of course there is v$controlfile/x$kcccf which would appear to be the
obvious support for your original statement.

> Thanks for the heads-up... always good to learn something new. Even if it
is
> that I'm supposed to be teaching RAC tomorrow, in New Zealand, with no
> flights booked, no hotel booked, and no class setup preparation time!

Ouch.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

[Database Administrator]

"Howard J. Rogers" wrote in message
news:3fc1337c$0$14031$afc38c87@news.optusnet.com.a u...
> Oh well, I did say I hadn't checked that one. It makes sense, though. I
> stand by the comments on the V$'s though (unless someone knows better).

well of course there is v$controlfile/x$kcccf which would appear to be the
obvious support for your original statement.

> Thanks for the heads-up... always good to learn something new. Even if it
is
> that I'm supposed to be teaching RAC tomorrow, in New Zealand, with no
> flights booked, no hotel booked, and no class setup preparation time!

Ouch.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

[Database Administrator]

"Howard J. Rogers" wrote in message
news:3fc1337c$0$14031$afc38c87@news.optusnet.com.a u...
> Oh well, I did say I hadn't checked that one. It makes sense, though. I
> stand by the comments on the V$'s though (unless someone knows better).

well of course there is v$controlfile/x$kcccf which would appear to be the
obvious support for your original statement.

> Thanks for the heads-up... always good to learn something new. Even if it
is
> that I'm supposed to be teaching RAC tomorrow, in New Zealand, with no
> flights booked, no hotel booked, and no class setup preparation time!

Ouch.

--
Niall Litchfield
Oracle DBA
Audit Commission UK