Concepts and Architecture Question:
Download Job Interview Questions and Answers PDF
How to identify database size when you create a database first time?
Answer:
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;
2. Actual data size:select sum(bytes/1024/1024/1024) 'Size in GB' from DBA_segments;
Download Oracle Architecture and Concepts Interview Questions And Answers
PDF