How can we find the size of a database?

Answer Posted / ammar takieddin

select sum(bytes)/1024/1024 from dba_data_files;
+
select sum(bytes)/1024/1024 from v$log;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by database schema and what does it hold?

600


How to use group functions in the select clause using oracle?

599


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1476


What is literal?

591


How to recover a dropped table in oracle?

612






What is the implicit cursor in oracle?

573


What is max rowid in oracle?

561


How to call a stored function in oracle?

578


What is difference between sid and service name in oracle?

522


What happens if recursive calls get out of control?

554


what is normalisation?what are its uses?

1769


What are triggers in oracle?

567


What is a nvl function?

567


Explain oracle’s system global area (sga).

632


Can you assign multiple query result rows to a variable?

554