Re: IO function metric.
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 23 Dec 2008 14:50:14 +0000 (UTC)
Message-ID: <giqtr6$j22$1@solani.org>
Date: Tue, 23 Dec 2008 14:50:14 +0000 (UTC)
Message-ID: <giqtr6$j22$1@solani.org>
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 Gogala http://mgogala.freehostia.comReceived on Tue Dec 23 2008 - 08:50:14 CST