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 ·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 …
Read MoreExploring Datafiles within Oracle Tablespaces
Feb 12, 2024 · 2 min read · database-administration performance-monitoring data-management tablespace datafiles dba_data_files optimization usage oracle dba_temp_files ·Description of Oracle Database SQL code for Showing Tablespace Files
This code displays information about the datafiles composing a specific tablespace in your Oracle database. Here's a breakdown of its purpose, components, and key points:
Show thea data files that comprise a tablespace
Sample SQL Command
1col …
Read More