This discussion is archived
3 Replies Latest reply: Oct 12, 2012 11:23 AM by Jason_(A_Non) RSS

Calculate XMLTYPE storage

VladK Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points