Re: IO function metric.

From: ddf <oratune_at_msn.com>
Date: Tue, 23 Dec 2008 07:55:05 -0800 (PST)
Message-ID: <903fb2ed-443d-4796-a193-7cb33f81ac5d@q36g2000vbn.googlegroups.com>


On Dec 23, 9:31 am, ddf <orat..._at_msn.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

Apparently 'smart scan' is tied to Exadata storage:

http://www.oracle.com/technology/products/bi/db/exadata/pdf/exadata-storage-technical-overview.pdf

David Fitzjarrell Received on Tue Dec 23 2008 - 09:55:05 CST

Original text of this message