Topic: SQL*Plus and PL/SQL >> Size of database!!!!!!!!!!!!
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Size of database!!!!!!!!!!!! |
| Rush |
Posted: Apr 07, 2008 03:18:16 AM |
Total Post: 127
Joined: Jan, 2007
|
Hi all,
Is there any command to find actual size of database? and this size comes in Byte of KB or MB?
Thanks
Rupesh. |
|
|
 Murtuja |
| Posted: Apr 07, 2008 04:28:38 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
Database is made up of Datafiles,Tempfiles,Redo log files,Control files,Password file,Parameter files and Other database related files i.e
Archive logs
Oracle Trace Files
Alert log
Oracle Database Software Binaries
So when you are calculating Database size ,You have to consider all the above files.
Calculate the size of Datafiles
select name,sum(bytes)/1024/1024 "Size in MB" from dba_data_files;
Calculate the size of Tempfiles
select name,sum(bytes)/1024/1024 "Size in MB" from dba_temp_files;
Calculate the size of Redo log files
select sum(bytes)/1024/1024 "Size in MB" from v$log;
Calculate the size of Control files
select name from v$controlfile;
.../control01.ctl
.../control02.ctl
.../control03.ctl
From OS;
Go to that location
du -ah
Calculate the size of Archive logs
From sql*plus
SQL> archive log list
Go to destination
du -ah will give you total file size in human readable format.
|
|
|
|
|
| Murtuja |
| Posted: Apr 10, 2008 06:52:42 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
any updates ? Please let us know that solution worked for you or not .
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
