Oracle DBA Tools - 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 tablespaces and datafiles.
Name: Name of the tablespace or datafile
Path: Path of the datafile
Status:Tablespace status {ONLINE, OFFLINE, READ ONLY}
Contents: Tablespace contents {UNDO, PERMANENT, TEMPORARY}
Logging: Default logging status {LOGGING, NOLOGGING}
Size: Total allocated space for the tablespace or datafile
User Size: Total space available for data in the tablespace or datafile
Free space: Total space available in tablespace or datafile
Space Used (Percent): Percentage of space used in tablespace or datafile
Coalesced: Percentage of space coalesced in tablespace
|
 Oracle DBA Tools - Storage Manager - Tree |
Tablespaces Tab -
Provides a list tablespaces and detailed information on each tablespace.
Name: Name of the tablespace
Status: Tablespace status {ONLINE, OFFLINE, READ ONLY}
Extent Management: Indicates whether the extents in the tablespace are dictionary managed (DICTIONARY) or locally managred(LOCAL)
Contents: Tablespace contents {UNDO, PERMANENT, TEMPORARY}
Logging: Default logging status {LOGGING, NOLOGGING}
Size: Total allocated space for the tablespace
Free space: Total space available in tablespace
Used space (percent): Percentage of space used in tablespace
Coalesced: Percentage of space coalesced in tablespace
Initial Ext: Initial extent size
Next Ext: Incremental extent size
Min Ext: Minimum number of extents
Max Ext: Maximum number of extents
PCT Increase: Percent increase for extent size
|
 Oracle DBA Tools - Storage Manager - Tablespace Tab |
Datafiles Tab -
Provides a list datafiles and detailed information on each datafile.
Name: Name of the database file
Path: Filesystem path of the database file
Tablespace: Name of the tablespace
Status: Database file status {AVAILABLE or INVALID}
Contents: Datafile contents {UNDO, PERMANENT, TEMPORARY}
Logging: Default logging status {LOGGING, NOLOGGING}
Size: Total allocated space for the datafile
Free space: Total space available in datafile
Used space (percent): Percentage of space used in datafile
Auto extent: Whether the datafile auto extends file size
Increment by: Increment size for auto extent
Max Size: Maximum extendable size
|
 Oracle DBA Tools - Storage Manager - Datafiles Tab |
Objects Tab -
Provides a complete list of objects stored in a specified tablespace.
Owner: Username of the object owner
Object Name: Name of the object
Object Type: Object type {INDEX PARTITION, TABLE PARTITION, TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, CACHE, LOBSEGMENT, LOBINDEX}
Size: Object size
Initial Ext: Size requested for initial extent size
Next Ext: Size of next extents
Num Ext: Number of extents allocated to object
Max Ext: Maximum number of extents for object
|
 Oracle DBA Tools - Storage Manager - Objects Tab |
Fragmentation Tab -
Displays fragmentation information on tablespaces in the database.
Tablespace: Name of the tablespace
Total blocks: Total available blocks
Empty blocks: Empty blocks
Total # Extents: Total number of extents
Largest: Largest available block size
Smallest: Smallest available block size
Average: Average size of available blocks
|
 Oracle DBA Tools - Storage Manager - Fragmentation Tab |
File IO Stats Tab -
Read and write performance statistics on the datafiles for the database tablespaces.
Tablespace: Name of the tablespace
Filename: Name of the datafile
Path: Name of the datafile path
Phy Reads: Number of physical reads done
Phy Blk Reads: Number of physical blocks read
Read Pct: Percent of reads of all reads on all tablespaces
Phy Writes: Number of times DBWR is requried to write
Phy Blk Writes: Number of blocks written to disk
Write Pct: Percent of writes of all writes on all tablespaces
Avg IO Time: Average time spent on I/O, if TIMED_STATISTICS parameter is true
|
 Oracle DBA Tools - Storage Manager - File IO Statistics Tab |
Object IO Stats Tab -
IO statistics for objects in the database.
Owner: Name of object owner
Object Name: Name of object
Object Type: Objec type
IO Cost: Sum of the I/O costs of operations as estimated by the optimizer's cost-based approach.
Total Size: Sum of the number of bytes produced by operations estimated by the cost-based optimizer.
|
 Oracle DBA Tools - Storage Manager - Object IO Statistics Tab |
