SHOW PROCESS /CONTINOUS /ID=x - over-flow limits for Direct I/O

COMPGROUPS.NET |

Search |

Post Question |

Groups |

Stream |

About | Register

SHOW PROCESS /CONTINOUS /ID=x - over-flow limits for Direct I/O

I was monitoring a database reorganization and noted that the at 13:19:18
(First SnapShot) the direct I/O was over 4 billion (4,237,942,590).

Then almost 30 minutes later at 13:48:29 (Second SnapShot) the Direct I/O was
less than 50 million (45,963,822).

Does anyone know at what point does the Direct I/O counter zeros out?


First SnapShot ---------------------------------------------------------------
                             Process BATCH_112                    13:19:18
    State               CUR                 Working set               1615
    Cur/base priority   6/5                 Virtual pages            12706
    Current PC          800F86E0            CPU time         0 20:03:35.08
    Current PSL         00000003            Direct I/O          4237942590 <--
    Current user SP     7ADE28E0            Buffered I/O              1926
    PID                 21604973            Page faults               1270
    UIC                 [ORACLE]            Event flags           C2000001
                                                                  80000000
Second SnapShot --------------------------------------------------------------
                             Process BATCH_112                    13:48:29
    State               CUR                 Working set               1615
    Cur/base priority   6/5                 Virtual pages            12706
    Current PC          00439BB0            CPU time         0 20:32:40.81
    Current PSL         0000001B            Direct I/O            45963822 <--
    Current user SP     7ADE28E0            Buffered I/O              1957
    PID                 21604973            Page faults               1270
    UIC                 [ORACLE]            Event flags           C2000001
                                                                  80000000
------------------------------------------------------------------------------


John "REBOOT" Brandon
VMS Systems Administrator
firstname.lastname.spam.me.not@dalsemi.com

brandon18 (250)

11/8/2006 8:02:22 PM

BRANDON, JOHN M wrote:
> I was monitoring a database reorganization and noted that the at 13:19:18
> (First SnapShot) the direct I/O was over 4 billion (4,237,942,590).
>
> Then almost 30 minutes later at 13:48:29 (Second SnapShot) the Direct I/O was
> less than 50 million (45,963,822).
>
> Does anyone know at what point does the Direct I/O counter zeros out?
>
>
> First SnapShot ---------------------------------------------------------------
>                              Process BATCH_112                    13:19:18
>     State               CUR                 Working set               1615
>     Cur/base priority   6/5                 Virtual pages            12706
>     Current PC          800F86E0            CPU time         0 20:03:35.08
>     Current PSL         00000003            Direct I/O          4237942590 <--
>     Current user SP     7ADE28E0            Buffered I/O              1926
>     PID                 21604973            Page faults               1270
>     UIC                 [ORACLE]            Event flags           C2000001
>                                                                   80000000
> Second SnapShot --------------------------------------------------------------
>                              Process BATCH_112                    13:48:29
>     State               CUR                 Working set               1615
>     Cur/base priority   6/5                 Virtual pages            12706
>     Current PC          00439BB0            CPU time         0 20:32:40.81
>     Current PSL         0000001B            Direct I/O            45963822 <--
>     Current user SP     7ADE28E0            Buffered I/O              1957
>     PID                 21604973            Page faults               1270
>     UIC                 [ORACLE]            Event flags           C2000001
>                                                                   80000000
> ------------------------------------------------------------------------------

I would guess at 4294967295 (unsigned long), or -1 (signed long)

davidc

11/8/2006 8:41:01 PM

BRANDON, JOHN M wrote:
> I was monitoring a database reorganization and noted that the at 13:19:18
> (First SnapShot) the direct I/O was over 4 billion (4,237,942,590).
>
> Then almost 30 minutes later at 13:48:29 (Second SnapShot) the Direct I/O was
> less than 50 million (45,963,822).
>
> Does anyone know at what point does the Direct I/O counter zeros out?
>
>
> First SnapShot ---------------------------------------------------------------
>                              Process BATCH_112                    13:19:18
>     State               CUR                 Working set               1615
>     Cur/base priority   6/5                 Virtual pages            12706
>     Current PC          800F86E0            CPU time         0 20:03:35.08
>     Current PSL         00000003            Direct I/O          4237942590 <--
>     Current user SP     7ADE28E0            Buffered I/O              1926
>     PID                 21604973            Page faults               1270
>     UIC                 [ORACLE]            Event flags           C2000001
>                                                                   80000000
> Second SnapShot --------------------------------------------------------------
>                              Process BATCH_112                    13:48:29
>     State               CUR                 Working set               1615
>     Cur/base priority   6/5                 Virtual pages            12706
>     Current PC          00439BB0            CPU time         0 20:32:40.81
>     Current PSL         0000001B            Direct I/O            45963822 <--
>     Current user SP     7ADE28E0            Buffered I/O              1957
>     PID                 21604973            Page faults               1270
>     UIC                 [ORACLE]            Event flags           C2000001
>                                                                   80000000
> ------------------------------------------------------------------------------
>
>
> John "REBOOT" Brandon
> VMS Systems Administrator
> firstname.lastname.spam.me.not@dalsemi.com

    2**32  = 4294967296

So it probably overflowed at this point.

AEF