Re: IO function metric.

On Dec 23, 8:50 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Tue, 23 Dec 2008 06:20:56 -0800, ddf wrote:
> > I just ran a truss on the LGWR process for an acitve production database
> > and found this:
>
> > open("/proc/2129936/psinfo", O_RDONLY)          = 69 kread(69, "\0
> > \0010204\001\0\0\001".., 448)    = 448
>
> > On this system process id 2129936 is the PMON process for that same
> > database.  So it appears to be reading process info for PMON ( I suppose
> > to ensure it's still up and running, as HJR reported in your follow-up
> > post).
>
> Nice catch. Do you have any information about the "smart scan" reported
> in the table?
>
> --
> Mladen Gogalahttp://mgogala.freehostia.com

Unfortunately I'm running my 11.1.0.6 database on Windows; I don't find 'Smart Scan' in my copy of V$IOFUNCMETRIC. Additionally I do NOT have the following options installed

Real Application Clusters
Oracle Label Security
Oracle Database Vault

Any of those installed in your 11g database?

David Fitzjarrell Received on Tue Dec 23 2008 - 09:31:49 CST