🧩 How to Check Database Size in Oracle

 🧩 Intro: Sometimes DBAs need to know how large the database is.

SQL Examples:

SELECT SUM(bytes)/1024/1024/1024 FROM dba_data_files; (data size in GB)

SELECT SUM(bytes)/1024/1024/1024 FROM dba_temp_files; (temp size)

SELECT SUM(bytes)/1024/1024/1024 FROM v$log; (redo size)

Conclusion: Combine these to know the real database footprint.

---