Database Administration (MOSC)

MOSC Banner

Identifying free space after deleting LOBS

Hello

Ours is a 19c database

One of the tables in our database has LOB data in it and the size of one of the tables is huge because of that. The LOB SIZE is appx 17 TB

We NULLED a bunch of LOBS based on the dates to reduce the size of the table

Before we nulled lobs

select tablespace_name,sum(bytes)/1024/1024/1024 GB from dba_segments where segment_name='SYS_LOB0013425998C00026$$' group by tablespace_name;

TABLESPACE_NAME            GB

LOB_DATA             10160.9287

select sum(dbms_lob.getlength (image_rec))/1024/1024/1024 from APP_OWNER.IMAGE_REC_TAB;

SUM(DBMS_LOB.GETLENGTH(IMAGE_REC))/1024/1024/1024

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center