Re: Size of object in tablespace

"Mark Bole" <makbo_at_pacbell.net> wrote in message news:V6cMe.1824$hF1.1366_at_newssvr30.news.prodigy.com...
> Andreas Sheriff wrote:
>
> > <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;
> >
> > ?
> >
>
>
> That gets the total size of all segments owned by the owner in a given
> tablespace, the "for example" part of the OP. The first part, "how do
> you define...", follows.
>
> For an object, you have to decide which segments you are interested in
> .. index, LOB, partition, etc. -- all of which can be spread across
> multiple tablespaces, of course.
>
> Or, for a table or index, you could just use the number of rows as a
> "logical" measure of size...
>
> -Mark Bole
>
>
>

I'm a DBA/Programmer, damn it, not a pseudo-English de-cypher.

-- 

Andreas Sheriff
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?"

DO NOT REPLY TO THIS EMAIL
Reply only to the group.