3 Replies Latest reply: Oct 12, 2012 1:23 PM by Jason_(A_Non) RSS

    Calculate XMLTYPE storage

    VladK
      Hello,

      We have a table with a XMLTYPE column.
      I want to find how much space this is taking up.

      When I execute this query on the table name, I don't believe I'm picking up the XMLTYPE column.

      select segment_name table_name,
      sum(bytes)/(1024*1024) table_size_mb
      from
      user_extents
      where segment_type='TABLE'
      and lower(segment_name) in ( 'table_name')
      group by segment_name


      We are using 11G R2 Oracle database.


      Thanks.