To see the total allocated size of the physical database, run the following query:
SELECT SUM(bytes) AS bytes FROM dba_data_files;While not all allocated space will be used, you can see the space used by your tables and indexes with the following query:
SELECT SUM(bytes) AS bytes FROM dba_segments;
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.