You could use the following query:
SELECT owner,segment_type, COUNT(*) No_of_Obj,SUM(bytes)/1048576 size_Mb
FROM dba_segments
WHERE owner=UPPER('&owner')
GROUP BY owner, segment_type;
-----Original Message-----
From: j [mailto:oracledba-ezmlmshield-x6152234.[Email address protected]
Sent: Tuesday, September 14, 2004 5:32 PM
To: LazyDBA Discussion
Subject: space occupied by a schema.
Dear All,
How can one find the total space occupied by a particular schema? (say a
user "ABC")
Jay
DISCLAIMER: The information contained in this message is intended only
and solely for the addressed individual or entity indicated in this
message and for the exclusive use of the said addressed individual or
entity indicated in this message (or responsible for delivery
of the message to such person) and may contain legally privileged and
confidential information belonging to Tata Consultancy Services Limited.
It must not be printed, read, copied, disclosed, forwarded, distributed
or used (in whatsoever manner) by any person other than the
addressee. Unauthorized use, disclosure or copying is strictly
prohibited and may constitute unlawful act and can possibly attract
legal action, civil and/or criminal.
The contents of this message need not necessarily reflect or endorse the
views of Tata Consultancy Services Limited
on any subject matter. Any action taken or omitted to be taken based on
this message is entirely at your risk and neither the originator of this
message nor Tata Consultancy Services Limited takes any responsibility
or liability towards the same. Opinions, conclusions and any other
information contained in this message that do not relate to the official
business of Tata Consultancy Services Limited shall be understood as
neither given nor endorsed by Tata Consultancy Services Limited or any
affiliate of Tata Consultancy Services Limited. If you have received
this message in error,
you should destroy this message and may please notify the sender by
e-mail. Thank you.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.
Oracle LazyDBA home page