Database Administration

Monitoring Temporary Tablespace Usage in Oracle Database
Jan 31, 2024 / Apr 24, 2026 · 3 min read · oracle sql-queries database-administration tablespace segments dba_segments dba_tablespaces v$session v$sort_usage ·
Share on:
Lists the Contents of the Temporary Tablespace(s), Including Details About Each Temporary Object and Its Associated Session Sample SQL Command 1set pages 999 lines 100 2col username format a15 3col mb format 999,999 4select su.username 5, ses.sid 6, ses.serial# 7, su.tablespace 8, ceil((su.blocks * dt.block_size) / …

Read More
- 3
- 4
- 5
- 6
- 7