Skip to content

Root Fan

Linux & Oracle DBA Blog

  • Home
  • Contact
  • About
  • Index

Tag: size

Posted on June 24, 2023September 17, 2023

How to Check Database Size in Oracle 19c

forest covered in white fog

You often need to know the size of an Oracle database to move it from one server to another. Or just to know if your export or whatever is going to take a lot of space and time.

In this article I show you a simple way to calculate the size of your Oracle database.

Size of Oracle datafiles in GB

select sum(bytes)/(1024*1024*1024) G 
from dba_data_files;
Continue reading “How to Check Database Size in Oracle 19c”

Unmissable Posts

  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • How to Change AWR Retention Period in Oracle Database
  • Oracle 19c Data Guard Configuration Step by Step
  • Step by Step Data Guard Broker Configuration in Oracle 19c
  • How to Check PDB Status in Oracle

Recent Posts

  • PhysicalDisk → CellDisk → GridDisk on Exadata
  • Oracle Exadata CellCLI Commands
  • Oracle Exadata Health Checks
  • Exadata Storage Index
  • Top 7 Oracle Wait Events Explained

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • Security
  • Ubuntu

Unmissable posts

  • How to Change AWR Retention Period in Oracle Database
  • How to Change Processes Parameter in Oracle 19c RAC
  • How to Run an Oracle SQL Script Using nohup on Linux
  • Oracle 19c RMAN Duplicate Database From Backup
  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • PhysicalDisk → CellDisk → GridDisk on Exadata
  • Oracle Exadata CellCLI Commands
  • Oracle Exadata Health Checks
  • Exadata Storage Index
  • Top 7 Oracle Wait Events Explained

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • Security
  • Ubuntu

en_US EN
en_US EN

  • Facebook
  • Twitter
  • Email
Privacy Policy Proudly powered by WordPress