How To Check Database Growth In Oracle?
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
1. Log in to your Oracle database server as the system administrator.
2. Open the SQL*Plus command prompt by typing “sqlplus“ at the command prompt.
3. Type the following command in the SQL*Plus prompt to connect to your Oracle database:
CONNECT username/password@database_name
4. Type the following command to display information about the current size of the database’s datafiles, including the amount of space used and available:
SELECT * FROM dba_data_files;
5. To display growth information for individual datafiles, use the following command:
SELECT file_name, bytes/1024/1024 as “Size (MB)”, maxbytes/1024/1024 as “Max Size (MB)”, round(((maxbytes – bytes)/maxbytes)*100, 2) as “Percent Used“ FROM dba_data_files;
6. To view the current size of the entire database, use the following command:
SELECT sum(bytes)/1024/1024 as “Total Database Size (MB)” FROM dba_data_files;