How to identify database size when you create a database first time?
Submitted by: Administrator1. 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
2. Actual data size:select sum(bytes/1024/1024/1024) 'Size in GB' from DBA_segments;
Submitted by: Administrator
Read Online Concepts and Architecture Job Interview Questions And Answers
Top Concepts and Architecture Questions
☺ | What is a Segment in Oracle? |
☺ | Explain can a Tablespace hold objects from different Schemes? |
☺ | Explain what is the function of Redo Log? |
☺ | What is Oracle Identity Analytics? |
☺ | Explain what is Public Database Link? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |