Home » RDBMS Server » Server Administration » Senior DBA pls help to
Senior DBA pls help to [message #228505] Tue, 03 April 2007 04:30 Go to next message
ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka
Member
Hi,

PLs help me in a query to check tablespace usage by individual users in the database.
I am able to get the size of tablespace,free space and used space of a tablespace.BUt what my manager wants is how much MB of tablespace has been utilized by individual users
Users have been given unlimited quota on their default tablespaces.

Clould some senior DBA through some lighr on it

Thanks
Ram
Re: Senior DBA pls help to [message #228508 is a reply to message #228505] Tue, 03 April 2007 04:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select owner, tablespace_name, sum(bytes)
from dba_segments
group by owner, tablespace_name
order by owner, tablespace_name
/

Regards
Michel
Re: Senior DBA pls help to [message #228515 is a reply to message #228505] Tue, 03 April 2007 04:44 Go to previous message
ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka
Member
THanks so much for the quick reply Razz !!
Previous Topic: view table change date
Next Topic: Is it Possible
Goto Forum:
  


Current Time: Fri Dec 09 03:56:04 CST 2016

Total time taken to generate the page: 0.06986 seconds