| seema |
Posted: Jun 26, 2008 02:18:28 AM |
Total Post: 66
Joined: Jan, 2008
|
| How can i get the size of the tablespace ! |
|
|
 Azaz |
| Posted: Jun 26, 2008 02:26:52 AM |  |
|
Total Post: 84
Joined: Mar, 2008
|
|
|
|
|
| Gitesh |
| Posted: Jun 26, 2008 04:42:50 AM | |
|
Total Post: 322
Joined: May, 2005
|
select tablespace_name,sum(bytes)/1024/1024 size_in_mb from dba_data_files
group by tablespace_name;
|
|
|
|
|
| seema |
| Posted: Jun 26, 2008 07:46:44 AM | |
|
Total Post: 66
Joined: Jan, 2008
|
that is not resolve my issue.
|
|
|
|
|
| Babu |
| Posted: Jun 27, 2008 12:16:07 AM | |
|
Total Post: 94
Joined: Oct, 2007
|
So; what's your problem? what's your exact requirement?
Babu
|
|
|
|
|
| balaji |
| Posted: Jun 27, 2008 03:41:32 PM | |
|
Total Post: 150
Joined: May, 2008
|
try this
select tablespace_name,round(sum(bytes)/(1024*1024)) mb from sm$ts_avail group by tablespace_name.
Regards,
Balaji
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
