Monitor simple large objects in a dbspace with oncheck -pT

Use oncheck -pT to monitor dbspaces to determine the number of dbspace pages that TEXT and BYTE data use.

This command takes a database name or a table name as a parameter. For each table in the database, or for the specified table, the database server displays a general tblspace report.

Following the general report is a detailed breakdown of page use in the extent, by page type. See the Type column for information about TEXT and BYTE data.

The database server can store more than one simple large object on the same blobpage. Therefore, you can count the number of pages that store TEXT or BYTE data in the tblspace, but you cannot estimate the number of simple large objects in the table.

The following example shows sample output.

TBLSpace Usage Report for mydemo:chrisw.catalog

    Type                  Pages      Empty  Semi-Full       Full  Very-Full
    ---------------- ---------- ---------- ---------- ---------- ----------
    Free                      7
    Bit-Map                   1
    Index                     2
    Data (Home)               9
    Data (Remainder)          0          0          0          0          0
    Tblspace BLOBs            5          0          0          1          4
                     ----------
    Total Pages              24

    Unused Space Summary

        Unused data bytes in Home pages                3564
        Unused data bytes in Remainder pages              0
        Unused bytes in Tblspace Blob pages            1430

Index Usage Report for index  111_16 on mydemo:chrisw.catalog

                    Average    Average
    Level    Total No. Keys Free Bytes
    ----- -------- -------- ----------
        1        1       74       1058
    ----- -------- -------- ----------
    Total        1       74       1058

Index Usage Report for index  111_18 on mydemo:chrisw.catalog

                    Average    Average
    Level    Total No. Keys Free Bytes
    ----- -------- -------- ----------
        1        1       74        984
    ----- -------- -------- ----------
    Total        1       74        984

Copyright© 2019 HCL Technologies Limited