Home | Previous Page | Next Page   Utility Reference > onstat: Monitor Database Server Operations > The onstat -g Monitoring Options >

onstat -g tmp

Prints usage statistics for spaces that may store temp files. The following options are available:

If no argument is supplied, the usage statistics are displayed for all dbspaces listed in the DBSPACETEMP environment variable. If DBSPACETEMP is not set, the DBSPACETEMP configuration parameter is used. For more information, see the Performance Guide.

Example Output

Figure 66. onstat -g tmp output
Based on the value of the DBSPACETEMP configuration parameter, this DBspace
can store temporary files:

num name            type     total pages          used         avail  %used  Max
  1 rootdbs.1          C           15000          9995          5005     66   70
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]