Re: db cache size in oracle 9ir2

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 23 Nov 2003 17:15:29 -0800
Message-ID: <1069636556.33627@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 Sun Nov 23 2003 - 19:15:29 CST