Storage Manager -
Provides manageability of the Oracle tablespaces and datafiles. Allowing a user to visualize and maintained storage. Including object and file IO statistics.
|
Toolbar Operations -
Refresh : Will refresh all tabs in the storage manager from the database
Expand All: Expands all tree nodes in the tree tab
Collapse All: Collapses all tree nodes in the tree tab
Create Tablespace: Create a new tablespace
Edit Tablespace: Edit the selected tablespace
Drop Tablespace: Drop the selected tablespace
Tablespace Properties: View properties of selected tablespace
Coalesce Tablespace: Coalesce the selected tablespace
Create Datafile: Create new datafile in selected tablespace
Edit Datafile: Edit selected datafile
Datafile Properties: View properties of the selected datafile
Size: Determines the unit in which to show size columns in the tab results
|
Tree Tab -
Hierarchical display of the databases and datafiles.
Name: Name of the database or datafile
Type: Datafile type (Data or Log)
Path: Path of the datafile
Status: Database status {ONLINE, OFFLINE, READ ONLY, SINGLE USER}
Total Size: Total allocated space for the database/datafile
Unreserved: Unreserved space in the database/datafile
Total Reserved (Percent): Percentage of reserved space in the database
Data Reserved (Percent): Percentqage of space reserved in the database for data
Log Reserved (Percent): Percentage of space reserved in the database for logs
Space Available: Total available space in the database
|
 |
Databases Tab -
Provides a list of databases and detailed information on each database.
Name: Name of the database
Status: Database status {ONLINE, OFFLINE, READ ONLY, SINGLE USER}
Owner: Database owner
Date Created: Date when the database has been created
Total Size: Total allocated space for the database
Unreserved: Unreserved space in the database
Total Reserved (Percent): Percentage of reserved space in the database
Data Reserved (Percent): Percentqage of space reserved in the database for data
Log Reserved (Percent): Percentage of space reserved in the database for logs
Space Available: Total available space in the database
Data Size: Total size of space allocated for datafiles
Log Size: Total size of space allocated for logfiles
Data Used: Space used in the database by data
Index Used: Space used in the database by indexes
Unused: Total unused space in the database
Log Used: Space used in the database by logs
Data Used: Space used in the database by data
Index Used: Space used in the database by indexes
Unused: Total available (unused) space in the database
Log Used: Space used in the database by logs
|
 |
Datafiles Tab -
Provides a list of datafiles and detailed information on each datafile.
Name: Name of the database file
Database: Name of the database
Path: Filesystem path of the database file
Type: Datafile type (Data or Log)
Size: Total allocated space for the datafile
Unreserved: Unreserved space in the datafile
Reserved (Percent): Percentage of reserved space in the datafile
File Group: File group the datafile belongs to
|
 |
Backup Devices Tab -
Provides a list of backup devices and detailed information on each backup device.
Name: Name of the backup device
Type: Backup device type (disk or tape)
Physical Location : Physical location of the backup device
Clicking on a backup device provides information on backups stired on this device:
Name: Name of a backup
Server: Name of the server
Database: Name of the database
Type: Backup type (database, transaction log, file, differential database, differential file, partial, differential partial)
|
 |
