Storage

Oracle: List Datafiles, Tempfiles, and Logfiles with Sizes Purpose Capacity planning starts with one number: how much disk the database files use. Oracle spreads that answer over several dynamic performance views. V$DATAFILE lists the datafiles, V$TEMPFILE the tempfiles, V$LOGFILE the redo log members and V$CONTROLFILE …

Optimizing Your Oracle Database: A Guide to Identifying Large Indexes with SQL Keeping your Oracle Database running smoothly requires constant monitoring and optimization. Indexes, a crucial component for efficient data retrieval, can sometimes grow excessively, impacting performance. This blog post dives into a …

Uncovering Table Storage Usage in Oracle Database: A Guide with dba_segments For Oracle Database administrators (DBAs) and developers, managing storage efficiently is critical. Keeping track of table sizes helps identify potential space hogs and optimize resource allocation. This guide delves into a powerful SQL query …