Explain how to find the overall database size

          

Explain how to find the overall database size


Oracle database - Explain how to find the overall database size posted by Babu Kunwar
<<Previous   Next>>

Explain how to find the overall database size

An oracle database consists of data files; redo log files, control files, temporary files. And in order to find out the size of the entire database we need to sum up size of all these files.

The biggest portion of a database's size comes from the data files. To find out how many megabytes are allocated to ALL data files: select sum (bytes)/1024/1024 "Meg" from dba_data_files;

To get the size of all TEMP files: select nvl (sum (bytes), 0)/1024/1024 "Meg" from dba_temp_files;

To get the size of the on-line redo-logs: select sum (bytes)/1024/1024 "Meg" from sys.v_$log; Hence to find the full size of database sum up all these files size.



Write your comment - Share Knowledge and Experience


<<Previous   Next >> 
More links
SQL*Plus

What is SQL*Plus? Explain its features
Explain how to use the SQL*Plus utility.
What are the basic SQL*Plus commands?
What is AFIEDT.BUF?
Difference between ? and HELP.
Explain how to enable the SQL*Plus HELP facility.
Difference between @ and @@.
Difference between & and &&.
Difference between ! and HOST
How can one prevent SQL*Plus connection warning messages?.............

Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring