Database Administration (MOSC)

MOSC Banner

LOB Size & actual size

edited Feb 13, 2011 3:18PM in Database Administration (MOSC) 4 commentsAnswered
Hi All,
I can get the actual size of the lob from the following command

select sum(dbms_lob.getlength (<lob column name>)) from <table_name>;

& the size of the lob segment from dba_segments

select bytes from dba_segments where segment_name ='<lob segment name>' and owner ='<table owner>';

How can I combine both in the same query? That s actual size of the lob & the segment_size for the lob. I have tried to capture both in single query but in vain.

can someone help?

thanks

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