Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Size of object in tablespace

Re: Size of object in tablespace

From: Andreas Sheriff <spamcontrol_at_iion.com>
Date: Mon, 15 Aug 2005 16:38:18 -0700
Message-ID: <KH9Me.19012$Ji4.17843@fed1read03>


<leo_at_tech-trans.com> wrote in message
news:1124148678.940359.141070_at_z14g2000cwz.googlegroups.com...
> Hi!
>
> How to define the size of object in tablespaces? For example, the
> size of user occupies in tablespace.
>
> Kai Ming
>

You mean something like:

break on owner
select owner, tablespace_name, sum(bytes) as bytes from dba_segments
group by owner, tablespace_name;

?

-- 
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer


"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---

WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup 
Received on Mon Aug 15 2005 - 18:38:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US