⟩ How to identify database size when you create a database first time?
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;
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;
What Are the ANSI Data Types Supported in Oracle?
How To Write Date and Time Literals in Oracle?
How To Write Date and Time Interval Literals in Oracle?
What Are the Limitations Oracle Database 10g XE?
How To Convert Numbers to Characters in Oracle?
What Operating Systems Are Supported by Oracle Database 10g XE?
How To Download Oracle Database 10g XE?
How To Convert Characters to Numbers in Oracle?
How To Install Oracle Database 10g XE?
How To Check Your Oracle Database 10g XE Installation?