Oracle database - Explain how to find the overall database size posted by
Babu Kunwar
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.
More links
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?.............
|
