Concepts and Architecture Interview Question:

How to identify database size when you create a database first time?

Submitted by: Administrator

1. Sum of the data files select sum(bytes/1024/1024/1024) 'Size in GB' from dba_data_files;

2. Actual data size:select sum(bytes/1024/1024/1024) 'Size in GB' from DBA_segments;
Submitted by: Administrator