Checking Pages with the -pl and -pL Options

The -pl and -pL options display similar information about the root and branch pages as the -pk and -pK options. In addition, the -pl and -pL options also display detailed information about the leaf pages in an R-tree index followed by information about the data objects on the leaf page.

The -pl and -pL options of the oncheck utility display the same information listed in Checking Pages with the -pk and -pK Options about the root, branch, and leaf pages. In addition, for each data object on a leaf page, the following information is displayed:

• size. The size of the data object in bytes
• rowid. The row ID of the data object in the indexed table
• The bounding box of the data object

The following example shows how to use the -pL option:

oncheck -pL rtree_db:polygons

The following example shows the type of output about leaf pages that oncheck -pL displays:

Node: Level 2, Pagenum 143, Usage  44.3%, No. of Children 5, right -1
Data record on page 143: size 136, rowid 1048992/30467
X(0.893479,1) Y(-0.176591,0.267366) Z(-0.0306181,0.388314) A(any) T(any)
Data record on page 143: size 136, rowid 1048992/16386
X(0.916716,1) Y(-0.399292,0.126833) Z(0.00581815,0.025057) A(any) T(any)

The example displays only two of the five children of the leaf page; the output for the remaining children is similar.