Dba_tablespaces
Oracle Tablespaces Needing More Space: SQL Script
Feb 6, 2024 / · 3 min read · database administration resource optimization performance monitoring data management tablespace datafiles dba_data_files dba_tablespaces dba_free_space ·Description of Oracle Database SQL code for Identifying Tablespaces Needing Space This code helps identify tablespaces requiring additional space to maintain an 80% utilization threshold in your Oracle database. Below is a breakdown of its purpose, components, and key points: Sample SQL Command 1set pages 999 lines 100 …
Read MoreSetting a Default Temporary Tablespace in Oracle Database
Alters The Default Temporary Tablespace for the Entire Database to "temp" Sample SQL Command 1alter database default temporary tablespace temp 2/ Purpose: To specify the preferred location where temporary data should be stored for all user sessions within the database. This provides centralized management and …
Read MoreMonitoring Temporary Tablespace Usage in Oracle Database
Jan 31, 2024 / · 3 min read · oracle sql-queries database-administration tablespace segments dba_segments dba_tablespaces v$session v$sort_usage ·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