Last updated: 2026-03-15
Tablespace Manager
Oracle tablespace management with usage visualization, datafile details, and I/O monitoring. Quickly assess storage health, drill into datafile layouts, and monitor undo activity from a single workspace.
Getting Started
Tablespace Manager gives Oracle DBAs a consolidated view of every tablespace in the database. It is available for Oracle connections only.
How to Open the Tablespace Manager
- Connect to an Oracle database in Jam SQL Studio
- Click Tools > Tablespace Manager from the main menu
- The workspace loads all tablespaces with live usage data
Tablespace Grid
The main grid lists every tablespace in the Oracle instance. Each row shows:
- Name - The tablespace name (e.g., USERS, SYSTEM, UNDOTBS1)
- Status - Online, offline, or read-only
- Type - Permanent, temporary, or undo
- Size - Total allocated size across all datafiles
- Used - Space currently consumed by data
- Free - Remaining available space
- % Used - A visual bar indicating how full the tablespace is
Datafile Details
Expand any tablespace row to see the individual datafiles that make up that tablespace. For each datafile you can view:
- File path - The full OS path of the datafile
- Size - Current size of the datafile on disk
- Autoextend - Whether the file grows automatically, and its maximum size and increment settings
I/O Statistics
The I/O Statistics section surfaces per-datafile read and write metrics so you can pinpoint hot files or I/O bottlenecks:
- Physical reads - Total read operations against the datafile
- Physical writes - Total write operations against the datafile
- Read time - Cumulative time spent on reads
- Write time - Cumulative time spent on writes
Undo Monitoring
For undo tablespaces, an additional monitoring panel shows undo-specific metrics:
- Active transactions - Number of transactions currently using undo space
- Undo usage - Current undo consumption relative to tablespace size
- Unexpired extents - Undo data retained for consistent reads (within undo_retention)
- Expired extents - Undo data eligible for reuse
DBA Privilege Fallback
Tablespace Manager queries DBA_TABLESPACES, DBA_DATA_FILES, and related DBA views when the connected user has DBA privileges. If those views are inaccessible, it automatically falls back to the corresponding USER_ views so non-DBA users can still inspect their own tablespace allocations.
Key Capabilities
- Visual usage bars - Instantly identify tablespaces nearing capacity
- Datafile drill-down - Inspect individual files with path, size, and autoextend settings
- I/O statistics - Track reads, writes, and timing per datafile to find hot spots
- Undo monitoring - View active transactions, undo consumption, and expired/unexpired extents
- DBA/USER fallback - Works with full DBA privileges or gracefully degrades for non-DBA users
Ready to Manage Oracle Storage?
Download Jam SQL Studio and monitor your tablespaces today.
Frequently asked questions
How do I view tablespace usage in Jam SQL Studio?
Open Tools > Tablespace Manager from an Oracle connection. The grid displays all tablespaces with their name, status, type, total size, used space, free space, and a visual percentage-used bar so you can instantly spot storage pressure.
Can I see datafile I/O statistics?
Yes. Expand any tablespace row to reveal its datafiles. The I/O Statistics section shows physical reads, physical writes, read time, and write time per datafile, helping you identify hot files and I/O bottlenecks.
Does the Tablespace Manager show undo statistics?
Yes. The Undo Monitoring section displays active transactions, current undo usage, and a breakdown of unexpired versus expired undo extents so you can tune undo retention and tablespace sizing.
Which Oracle versions are supported?
Tablespace Manager works with Oracle 11g and later. It queries DBA_ views when the connected user has DBA privileges and automatically falls back to USER_ views for non-DBA users.