Re: v$ views and control files

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."

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