4.8 Storage Manager
This tool provides an easy interface to administrate tablespaces and datafiles.
As you can see in the screenshot above the tool is a list of all the tablespaces available in the database. The tablespaces can be expanded to display the datafiles they consist of. There is also one option available to this tool, whether to collect information about how coalesced the tablespaces are, the coalesced fetching can be very slow on fragmented databases and if TOra seems to lock itself when you try to start this tool try resetting that option to not show coalesced info. Using the toolbar you can perform these commands.
- Refresh
- Update the view.
- Show extent view
- TODO.
- Show tablespaces or just datafiles
- TODO.
- Take tablespace online
- Take the selected tablespace online.
- Take tablespace offline
- Take the selected tablespace off-line.
- Set tablespace default to logging
- Enable logging for the selected tablespace.
- Set tablespace default to no logging
- Disable logging for the selected tablespace.
- Allow read write access to tablespace
- Enable read and write access to the selected tablespace.
- Set tablespace read only
- Only allow read only access to the selected tablespace.
- Modify tablespace
- Modify the selected tablespace settings. If you don't understand the settings in this dialog please refer to the Oracle Server Concepts manual.
- Drop tablespace
- TODO.
- Modify file
- Modify the current datafiles settings. If you don't understand the settings in this dialog please refer to the Oracle Server Concepts manual.
- Create new tablespace
- Create a new tablespace. If you don't understand the settings in this dialog please refer to the Oracle Server Concepts manual.
- Add datafile to tablespace
- Create a new datafile for the currently selected tablespace. If you don't understand the settings in this dialog please refer to the Oracle Server Concepts manual.
- Coalesce tablespace
- Coalesced free data in the current tablespace.
- Move datafile
- Move a datafile to another location.
- Change connection
- Change the connection to administrate storage for.
When you select a tablespace or datafile the lower part of this tool displays the objects (to the left) and extents (to the right) in that tablespace or file. A used extent is displayed as green in the extent view if the object it belongs to is not selected in the list to the right. Selecting an item in the list to the right will paint it's extents red in the right extent view. Unallocated space is colored whie. Some information about the number of files and extents are displayed at the top of the extents display. Several datafiles are separated by one line of black in the extent view if a tablespace containing several files are viewed.