V$controlfile
Build OS Delete Commands for Oracle Database Files
Apr 8, 2024 / · 3 min read · v$datafile v$tempfile v$logfile v$controlfile data-management oracle database dba administration management ·Building Remove(rm) or Delete OS Commands for Oracle Database Files (Caution: Destructive) Important Warning: Destructive Operation The provided code snippet demonstrates how to construct operating system (OS) commands for all datafiles, temporary files, log files, and control files within an Oracle Database. However, …
Read MoreViewing Control File Locations in Oracle Database This guide explores a simple method to identify the locations of control files in your Oracle Database. We'll delve into the provided SQL code, understand its purpose, and offer insights into control files. List controlfiles Sample SQL Command 1select name 2from …
Read MoreOracle: List Datafiles, Tempfiles, and Logfiles with Sizes
Mar 26, 2024 / · 8 min read · oracle storage v$datafile v$tempfile v$logfile v$log v$controlfile dba_free_space ·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 …
Read More