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.

Last updated: 2026-03-15

Tablespace Manager

Q: 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.

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 Manager grid showing all tablespaces with name, status, type, size, used, free, and visual percentage-used bar — The Tablespace Manager grid with usage bars for every tablespace.

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.

Expanded tablespace row showing datafile paths, sizes, autoextend settings, and I/O statistics — Datafile details and I/O statistics for an expanded tablespace.

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.

Download Now Compare with ADS