Re: Space usage from dba_segments

Okay, that was embarrassing, but thanks for the help everyone

On Wed, Dec 8, 2021 at 12:00 PM Rich J <rich242j_at_gmail.com> wrote:

> Hey CP,
>
> I think you have one too many "/1024" in your calculation. Looks like
> that should be 3.3*T*B.
>
> /1024 = KB
> /1024/1024 = MB
> /1024/1024/1024 = GB
> /1024/1024/1024/1024 = TB
>
> Rich
>
> On Wed, Dec 8, 2021 at 11:31 AM Cee Pee <carlospena999_at_gmail.com> wrote:
>
>> Hi,
>>
>> We have a 19c database. We are trying to export a user's objects using
>> datapump. When we checked the space usage by the user from dba_segments we
>> got space used by the user as 3.3Gb:
>>
>> 1 select owner, TABLESPACE_NAME, sum(bytes)/1024/1024/1024/1024 Gb
>> from dba_segments
>> 2* where owner IN ('&owner') group by owner, TABLESPACE_NAME
>> SQL> /
>> Enter value for owner: DW_USER
>> old 2: where owner IN ('&owner') group by owner, TABLESPACE_NAME
>> new 2: where owner IN ('DW_USER') group by owner, TABLESPACE_NAME
>>
>> OWNER TABLESPACE_NAME GB
>> -------------- -------------------- ----------
>> DW_USER DW_TEAM 3.3
>>
>> 1 row selected.
>> ###################################################
>>
>> We are currently running the data pump for the user and the dump file is
>> about 600Gb already and the job is still running. Does dba_segments not
>> show all space used by a user ? Is there another view where I can see all
>> the space used by a certain user.
>>
>> Thanks,
>> CP.
>>
>>

--
http://www.freelists.org/webpage/oracle-l