OraFAQ Forum: Server Administration » Senior DBA pls help to

Home » RDBMS Server » Server Administration » Senior DBA pls help to

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Senior DBA pls help to [message #228505]

Tue, 03 April 2007 04:30

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

Report message to a moderator

Re: Senior DBA pls help to [message #228508 is a reply to message #228505]

Tue, 03 April 2007 04:32

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Senior DBA pls help to [message #228515 is a reply to message #228505]

Tue, 03 April 2007 04:44

ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka

Member

THanks so much for the quick reply Razz

Report message to a moderator

Previous Topic:	view table change date
Next Topic:	Is it Possible

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:56:52 CDT 2024