Monitor tblspaces to determine which tables are active.
Active tables are those that a thread has currently opened.
Output from the onstat -t option includes the
tblspace number and the following four fields.
Field
Description
npages
Pages allocated to the tblspace
nused
Pages used from this allocated pool
nextns
Number of extents used
npdata
Number of data pages used
If a specific operation needs more pages than are available
(npages minus nused), a new extent is required. If enough
space is available in this chunk, the database server allocates the
extent here; if not, the database server looks for space in other
available chunks. If none of the chunks contains adequate contiguous
space, the database server uses the largest block of contiguous space
that it can find in the dbspace. onstat -t output shows an example of
the output from this option. Figure 1: onstat -t output