Re: IO function metric.
Date: Tue, 23 Dec 2008 07:31:49 -0800 (PST)
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 126.96.36.199 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