Dba_temp_files
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 999,999,999 4col …
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