Usage
Understanding Tablespace Usage in Oracle Database
Feb 13, 2024 / · 4 min read · database administration monitoring optimization tablespace usage oracle dba_data_files dba_temp_files dba_free_space ·Description of Oracle Database SQL code for Tablespace Usage This code provides a comprehensive overview of tablespace usage in your Oracle database. Here's a breakdown of its purpose, components, and key points: Sample SQL Command 1set pages 999 2col tablespace_name format a40 3col "size MB" format 999,999,999 4col …
Read MoreExploring Datafiles within Oracle Tablespaces
Feb 12, 2024 / · 8 min read · database-administration performance-monitoring data-management tablespace datafiles dba_data_files optimization usage oracle dba_temp_files dba_tablespaces ·Show the Datafiles That Make Up an Oracle Tablespace Capacity planning for an Oracle database starts with knowing which files hold each tablespace and how large they are. A tablespace is a logical container. Its data lives in one or more datafiles on disk, and dba_data_files lists them. The query below takes a …
Read More