Re: db cache size in oracle 9ir2

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sun, 23 Nov 2003 16:13:16 +1100
Message-ID: <3fc041fa$0$20185$afc38c87@news.optusnet.com.au>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1069549594.549005_at_yasure...
> Howard J. Rogers wrote:
>
> > Because it doesn't store any real user data, and therefore has a
completely
> > different function from the data files and the redo logs?
> >
> > Regards
> > HJR
>
> Not a good enough reason ... or even, IMO, a valid reason. It stores
> only one bit of information not contained in the catalog tables: The SCN.

You need to go back and check some more, Daniel.

The control file stores the bit that tells us whether the database is in archivelog mode or not. It contains the bits that describe whether a data file is online, offline, read-only or read-write. It contains the flag which indicates which is the current redo log, because that's not in the data dictionary either. It contains the Database ID, which is unique to each dtaabase. It contains the creation date for the database. If you use RMAN, it stores the repository information for RMAN.

There's lots it stores which you won't find in the data dictionary.

Regards
HJR Received on Sat Nov 22 2003 - 23:13:16 CST