Oracle Server Manager User's Guide

Contents Index Home Previous Next

The Tablespace Monitor

The Tablespace Monitor displays information about the tablespaces in the database.

The following figure illustrates the left-most columns of the Tablespace Monitor.

Figure 11 - 16. Tablespace Monitor

The Tablespace Monitor is described below:

Tablespace Name Name of the tablespace.
Status Status of the tablespace: ONLINE or OFFLINE.
Total File Blocks Size of the tablespace in database blocks.
Total Quota Blocks Number of database blocks currently allocated to users' objects in the tablespace.

Filters

The following filter is available in the Tablespace Monitor:

Tablespace Filter for the tablespace name. Monitor displays information for tablespaces whose names match the Tablespace filter.

SQL Worksheet Equivalent

To start the Tablespace Monitor from a SQL Worksheet, you can use the following Server Manager command:

	MONITOR TABLESPACE

Required Views

To use the Tablespace Monitor, you must have access to:


Contents Index Home Previous Next