Re: v$ views and control files

John wrote:
>
> Thanks, all.
> Here is the thing though...
> When the database is mounted but not yet open, the v$ views can be
> accessed. The control files are being acessed by ORACLE at this point,
> but not the data files. There are indeed some data populated in the
> some of the v$ views - v$sqlarea for example, at this point. I wonder
> how the data in the base x$ tables get populated before the database is
> open. I don't think they come from the control files. But where and how
> then?
>
> John
>
> Connor McDonald wrote:
> > John wrote:
> > >
> > > Hi all,
> > >
> > > A statement in an ORACLE book really baffles me.
> > >
> > > "The information for a dynamic performance view is gathered from
> the
> > > control file"
> > >
> > > Can anybody tell me how the stuff in, say, v$sqlarea can be
> gathered
> > > from(and thereby, of course, stored in) the control file?
> > >
> > > John
> >
> > A lot of v$ stuff comes from all sorts of places - memory, control
> > files, standard database tables etc
> >
> > hth
> > connor
> > --
> > Connor McDonald
> > Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
> > Co-author: "Oracle Insight - Tales of the OakTable"
> >
> > web: http://www.oracledba.co.uk
> > web: http://www.oaktable.net
> > email: connor_mcdonald_at_yahoo.com
> >
> >
> > "Semper in excremento, sole profundum qui variat."
> >
> > ------------------------------------------------------------

not ALL v$ views can be accessed,

those that are based on memory structures can be seen at nomount time,,

those that are based on the control file can be seen at mount time

etc

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------