Extents in the data dictionary for Oracle Tablespace and Storage Manager
You have already selected the Storage Manager menu choice from the DBA Management Pack group of the Oracle Enterprise
Manager program group. Click Storage Manager.
You should log in as an existing user--in this case, use the user name of sys and a password of sys
to see a variety of tablespaces. Once you have entered the username and password, click OK to bring up Storage
When Oracle Storage Manager comes up, click Tablespaces in the list box at left. (Note: The display has been resized
from the default display for better understanding in this simulation.)
The size of each tablespace is displayed in the right hand frame, along with the amount of space it used. If you want
to explore the tablespaces further, you can select a particular tablespace. In this case, click the
Once you have selected a particular tablespace, you can click the Show Dependencies toolbar button at far left, the
third button from the top.
The Dependencies dialog comes up, by default, with the Dependencies tab showing. You can click the plus sign to the
left of the Datafile folder to display the datafiles associated with the tablespace.
You can get more information about the tablespace by clicking on the Dependents tab of the Dependencies window.
This tab of the Dependencies window shows the logical entities that reside in the USER_DATA tablespace. You
can show the tables that reside in this tablespace by expanding the Tables portion of the USER_DATA
From here, you can drill down into further dependencies by expanding a particular table, which shows you the
dependencies of other database objects on the table. This is the end of the simulation.