9 Replies Latest reply: Sep 25, 2013 6:20 AM by odie_63 RSS

    [11g] most efficient way to calculate size of xmltype type column

    user8704911

      I need to check the current size of some xmltype column in a BIU trigger.

      I don't think it's good to use

       

        length(:new.xml_data.GetStringVal());

       

      or

       

        dbms_lob.GetLength(:new.xml_data.GetClobVal());

       

      What's the most efficient way to get the storage size?

      I don't need the string serialized size.

      It could also be the internal storage size (incl. administration data overhead).

      - thanks!

      regards,
      Frank