Re: get space used by tablespace?

That could be. We have an application that logs into the database with one acct and password, and another application that logs in as another acct and password. Both use the same tablespace but different tables, so we want to know what percentage of the storage used belongs to each acct. Does that make sense?

Mary

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
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Tue Mar 16 1999 - 08:40:35 CST