| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: get space used by tablespace?
A copy of this was sent to Mary Orcutt <mary_at_globeset.com>
(if that email address didn't require changing)
On Tue, 16 Mar 1999 08:40:35 -0600, you 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
then something like:
SQL> select owner, tablespace_name, sum(bytes)
2 from dba_segments
3 where owner in ( 'SCOTT', 'SYS' )
4 group by owner, tablespace_name
5 /
OWNER TABLESPACE_NAME SUM(BYTES) ------------------------------ ------------------------------ ---------- SCOTT TOOLS 2613248 SYS RBS_TS_01 26238976 SYS RBS_TS_02 74473472 SYS RBS_TS_03 26238976 ... SYS TEMPORARY 22609920 SYS USERS 14917632
will show by bytes, space allocated to users in tablespaces.
>
>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
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |