Topic: Database Administration >> Database Size
|
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.
|
|
|
|
| Irfan |
Posted: Apr 11, 2008 06:00:37 AM |
Total Post: 24
Joined: Nov, 2005
|
Hi Everyone
How to determine the size of database(in GB) Db is 9i? |
|
|
 Murtuja |
| Posted: Apr 11, 2008 06:06:40 AM |  |
|
Total Post: 814
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.
|
|
|
|
|
| Irfan |
| Posted: Apr 11, 2008 06:12:08 AM | |
|
Total Post: 24
Joined: Nov, 2005
|
Would
select sum(bytes) from dba_extents;
do???
|
|
|
|
|
| Murtuja |
| Posted: Apr 11, 2008 06:57:20 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
You can check it from your database.
|
|
|
|
|
| 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 | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
