RelationalDBDesign 




Managing DB Objects   «Prev 

Extents in the data dictionary for Oracle Tablespace and Storage Manager

  1. 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.
  2. 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 Manager.
  3. 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.)
  4. 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 USER_DATA tablespace.
  5. Once you have selected a particular tablespace, you can click the Show Dependencies toolbar button at far left, the third button from the top.
  6. 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.
  7. You can get more information about the tablespace by clicking on the Dependents tab of the Dependencies window.
  8. 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 tree.
  9. 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.