| free space [message #63865] |
Wed, 17 November 2004 23:17  |
lakshmi narasimman
Messages: 1
Registered: November 2004
|
Junior Member |
|
|
hi..
i need to find howmany space occupied by each database user
Say for Example
User Tablespace Space
----------------------------------------------
Ram TB 50M
Raja Sample 30M
John GRD 75M
|
|
|
|
| Re: free space [message #63867 is a reply to message #63865] |
Thu, 18 November 2004 00:14  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Try this :
select owner,tablespace_name,sum(bytes)/1024/1024 "Space MB" from dba_Segments group by owner,tablespace_name;
Daljit Singh.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
