Re: get space used by tablespace?

Right - you can't have two tablespaces sharing a datafile. What I'll do is usually take a look at sum(bytes) from dba_segments where tablespace_name = Whatever,
Also, dba_Free_space where tablespace_name = Whatever will help you figure out how full it is.

• Dc.

Peter Sharman wrote:

> Mary
>
> I think you have some terminology confused here. A datafile belongs to a
> single tablespace. Do you mean you have two datafiles making up a single
> tablespace?
>
> HTH.
>
> Pete
>
> Mary Orcutt wrote:
>
> > I have two tablespaces sharing a single large datafile. Is there any way
> >
> > to determine how much space each of these are using at a given time?
> >
> > Thanks,
> > Mary
>
> --
>
> Regards
>
> Pete
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Peter Sharman Email: psharman_at_us.oracle.com
> WISE Course Development Manager Phone: +1.650.607.0109 (int'l)
> Worldwide Internal Services Education (650)607 0109 (local)
> San Francisco
>
> SQL> select standard_disclaimer, witty_remark
> 2 from company_requirements;
>
> Opinions are mine and do not necessarily reflect those of Oracle
> Corporation
>
> "Controlling application developers is like herding cats."
> Kevin Loney, ORACLE DBA Handbook
> "Oh no it's not! It's much harder than that!"
> Bruce Pihlamae, long term ORACLE DBA
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> ------------------------------------------------------------------------
>
> Peter Sharman <psharman_at_us.oracle.com>
> Courseware Development Manager
> Oracle Corporation
> Worldwide Internal Services Education
>
> Peter Sharman
> Courseware Development Manager <psharman_at_us.oracle.com>
> Oracle Corporation
> Worldwide Internal Services Education
> 500 Oracle Parkway M/S OPL-B1024 Fax: +1.650.633.1669
> Redwood Shores Work: +1.650.607.0109
> California
> 94065
> USA
> Opinions are mine and do not necessarily reflect those of Oracle Corporation "Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook "Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA
> Additional Information:
> Last Name Sharman
> First Name Peter
> Version 2.1
Received on Tue Mar 16 1999 - 14:07:13 CST