| mahesh sg |
Posted: Nov 21, 2007 12:45:20 AM |
Total Post: 2
Joined: Mar, 2006
|
hello everybody..,
I have a confusion in .. to in which query we can find the size of the databse..? it's dba_data_files,dba_extent?
size of the database means...
1. its total size of all datafiles,redologfiles,controlfiles..?
2. its total size of datafiles..?
plz give me solution ..?
With regards.,
S.G.M
|
|
|
 Murtuja |
| Posted: Nov 21, 2007 08:25:53 AM |  |
|
Total Post: 588
Joined: Jan, 2006
|
you have to qyery dba_data_files
1st answer is correct
|
|
|
|
|
| Mohammed Taj |
| Posted: Nov 21, 2007 09:02:47 AM | |
|
Total Post: 634
Joined: Jul, 2007
|
There are total six types of files.
1. datafiles
2. controlfiles
3. redologfiles
First three files is part of database ...so you must include in database size.
4. archivelogfiles
5. parameter files
6. passwordfile
Second three files is not part of database ...but it is also include in database size.
|
|
|
|
|
| Babu |
| Posted: Nov 22, 2007 04:22:13 AM | |
|
Total Post: 77
Joined: Oct, 2007
|
But oracle consider only datafile.
|
|
|
|
|
| shantanu |
| Posted: Feb 04, 2008 04:42:03 PM | |
|
Total Post: 37
Joined: May, 2007
|
more preferably datafiles, but all physical files and parameter files constitute size of database in ORACLE.
|
|
|
|
|
| GOPU |
| Posted: Apr 17, 2008 01:35:44 AM | |
|
Total Post: 149
Joined: Apr, 2008
|
total size of the database
select sum(bytes)/1024/1024/1024 from v$datafile or dba_data_files;
actual size of the database
select sum(bytes)/1024/1024/1024 from dba_segments;
U can get the free space like
select sum(bytes)/1024/1024/1024 from dba_free_space.
Gopu
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
