Home | Previous Page | Next Page   Disk, Memory, and Process Management > Managing Disk Space > Monitoring Disk Usage >

Monitoring Simple Large Objects in a Dbspace

You can 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 on TEXT and BYTE data.

The database server can store more than one simple large object on the same dbspace. 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.

To view statistics for simple large objects, execute onutil CHECK TABLE ALLOCATION INFO. Figure 71 shows sample output.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]