RE: Unexpected behavior with V$FILESTAT

>Is it possible that dbwriter hadn't yet written the blocks to disk when you
>performed your query?
>
>--Terry

Yep, that was the case - here is the off-list exchange I had with Mr. Kennedy:

-----Original Message-----
From: Kennedy, Jim [mailto:jim_kennedy_at_mentor.com] Sent: Friday, August 26, 2005 1:59 PM
To: Allen, Brandon
Subject: RE: Unexpected behavior with V$FILESTAT

Yup. That did it. Subtle but it makes sense. Thanks,
Jim

-----Original Message-----
From: Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com] Sent: Friday, August 26, 2005 1:58 PM
To: Kennedy, Jim
Subject: RE: Unexpected behavior with V$FILESTAT

If I understand correctly, a commit just ensures that it is written to the redo log. Datafile writes are done by DBWR on its own time during checkpoints. Try forcing a checkpoint and see if that forces the phywrts to go up.

-----Original Message-----
From: Kennedy, Jim [mailto:jim_kennedy_at_mentor.com] Sent: Friday, August 26, 2005 1:39 PM
To: Allen, Brandon
Subject: RE: Unexpected behavior with V$FILESTAT

Hmmm, could be.. But I would have expected the commit to make sure it was written to the datafile. I did several tests: Truncate table and reuse storage (so the high water mark isn't involved - reset it). Record the phywrites, insert data and commit. Keep querying the physical writes and not seeing the number go up. (times at least 30 seconds and not increase in physical write count.)

Odd, not what I expected the column to mean or behave. Jim

-----Original Message-----
From: Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com] Sent: Friday, August 26, 2005 1:26 PM
To: Kennedy, Jim
Subject: RE: Unexpected behavior with V$FILESTAT

Maybe all the writes were done in cache - not written to the file yet?

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l