You can use this procedure to analyze tablespaces.
Choose Tools →Administration →Computing Center →Management System →Control →Performance Menu →Database →Tables / Indexes.
Alternatively, use transaction code DB02.
In the Tablespaces section there are extensive options available for analyzing tablespaces. Some of these options are described below:
You get a complete list of tablespaces with details on:
You can Sort the tablespaces according to a particular feature. For example, you can quickly find out which tablespaces are almost full.
See also:Checking for Full Tablespaces (Oracle)
Choose Storage parameter to display the storage parameters of a selected tablespace.
Choose Analysis to examine the selected tablespace in more detail.
Displays a history of all tablespaces.
Choose Choose to display a detailed history of an individual tablespace.
You get a breakdown of the freespace situation for all tablespaces. Alongside the total freespace available, the largest freespace area (Freespace Maximum) and the number of fragments are also displayed. This provides you with a good overview of the fragmentation of tablespaces. The size of the largest extent is also displayed. The DBA can then assess whether the next extent (if required) can be inserted in the freespace of the tablespace.
Choose Critical tables/indexes to display the critical objects for the storage situation.
See also:
Storage Management Errors (Oracle)
Checking Storage Parameters (Oracle)
Monitoring Table and Index Fragmentation (Oracle)
Tables/Index Analysis (Oracle)