chetan

• Jun 30th, 2006

 

Using Dump we can find size of columns

DeepaRaja

 Profile Answers by DeepaRaja 

• May 22nd, 2008

 

Firstly we have list all the segments associated with the table with lob columns. We could do this using the following query.

For example let us assume that we have table with called media with a lob column. The following query would list all segments for the media table. There would be one lobsegment and a lob index for each lob column in the table.

SELECT segment_name, segment_type, bytes/1024/1024 size_in_MB

FROM user_segments

WHERE (segment_name = 'MEDIA'

OR segment_name in (

SELECT segment_name

FROM user_lobs

WHERE table_name = 'MEDIA'

UNION

SELECT index_name

FROM user_lobs

WHERE table_name = 'MEDIA'

) )


In order to find the total size of the table the following would do the job

SELECT sum( bytes)/1024/1024 size_in_MB

FROM user_segments

WHERE (segment_name = 'MEDIA'

OR segment_name in (

SELECT segment_name

FROM user_lobs

WHERE table_name = 'MEDIA'

UNION

SELECT index_name

FROM user_lobs

WHERE table_name = 'MEDIA'

) )


Hope this helps