Answer Detail: RE: Identify Database Size

GeekInterview.com > Interview Questions > Oracle > Concepts and Architecture

Print |

Question: Identify Database Size

Answer: How will you identify database size when you create a database first time?

October 10, 2008 17:26:20	#1
sumer77	Member Since: October 2008 Total Comments: 4
RE: Identify Database Size
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;