search cancel

How BIG is the database?

book

Article ID: 162446

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

We often see cases where the customer is concerned about the size of their database, the amount of physical disk it is actually occupying.  Most available solutions show data file or tablespace sizes, leaving the user with a math problem to solve.
 

-

Cause

-

Resolution

Run the following script from SQLPlus as SYS as SYSDBA (not as protect or the DLP schema owner):

select
(select sum(bytes) from dba_data_files)/1024/1024/1024 db_size
from
dual
/