Re: get space used by tablespace?

you could try a tool called TOAD. its at www.toadsoft.com There is a View|tablespaces that can show you which tables, which users are taking up the space in the tablespace.

John

Mary Orcutt wrote:

> 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 - 18:33:27 CST