Re: Space usage from dba_segments

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

> 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