| Deepak |
Posted: Jul 08, 2005 12:54:41 AM |
Total Post: 10
Joined: Mar, 2005
|
Hi all
can any one tell me how to know the size of a DataBase.
Hi Vigyan, u can help me. so kindly do my favr.
Thankx |
|
|
 nirav |
| Posted: Jul 08, 2005 07:03:57 AM |  |
|
Total Post: 20
Joined: Jun, 2005
|
Hi,
If you mean what is the 'total' size (used and unused space) you can use:
select sum(bytes from dba_data_files;
Note that it includes free space too..
Shreyaas
|
|
|
|
|
| nirav |
| Posted: Jul 08, 2005 07:04:13 AM | |
|
Total Post: 20
Joined: Jun, 2005
|
Hi,
If you mean what is the 'total' size (used and unused space) you can use:
select sum(bytes) from dba_data_files;
Note that it includes free space too..
Shreyaas
|
|
|
|
|
| sasi |
| Posted: Dec 28, 2005 10:14:03 AM | |
|
Total Post: 59
Joined: Nov, 2005
|
you have check in GB means
select sum(bytes)/1024/1024/1024 from dba_data_files;
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
