Home » RDBMS Server » Server Administration » free space
free space [message #63865] Wed, 17 November 2004 23:17 Go to next message
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

 

 

Report message to a moderator

Re: free space [message #63867 is a reply to message #63865] Thu, 18 November 2004 00:14 Go to previous message
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.

Report message to a moderator

Previous Topic: Upgrade 7.3.4 to 9i using DBUA
Next Topic: Oracle 8i compatibility with Windows 2003 server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 06:23:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.