Re: v$ views and control files

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."
>
> ------------------------------------------------------------
Received on Tue May 10 2005 - 10:36:52 CDT