Some policies are more aggressive than others.  Is there a way to approximate the amount of space that each policy takes up?

The following SQL script will only APPROXIMATE the amount of space that the policies occupy.

Treat this as the minimum amount of space occupied. This is due to the use of NLS_LENGTH_SEMANTICS parameter of 'CHAR'.  See "Database Reference (oracle.com)" for more details.

Using SQLPlus, logged in as the Symantec DLP schema owner (e.g., "protect"), run the following:

set pagesize 100
break on report
compute sum of ml_orig on report
compute sum of mcl_cracked on report
compute sum of mcl_uncracked on report
compute sum of cvl_markers on report
compute sum of sum_total on report
select policyid,
       sum(dbms_lob.getlength(ml.networkoriginalmessage)) ml_orig,
       SUM(dbms_lob.getlength(mcl.crackedcomponent)) mcl_cracked,
       SUM(dbms_lob.getlength(mcl.uncrackedcomponent)) mcl_uncracked,
       sum(dbms_lob.getlength(cvl.crackedcomponentmarkers)) cvl_markers,
       sum(dbms_lob.getlength(ml.networkoriginalmessage))
      + SUM(dbms_lob.getlength(mcl.crackedcomponent))
      + SUM(dbms_lob.getlength(mcl.uncrackedcomponent))
      + sum(dbms_lob.getlength(cvl.crackedcomponentmarkers)) sum_total
  from messagelob ml,
       messagecomponentlob mcl,
       messagecomponent mc,
       conditionviolation cv,
       conditionviolationlob cvl,
       incident i
where ml.messageid = i.messageid
and i.messageid = mc.messageid
and mc.messagecomponentid= mcl.messagecomponentid
and cv.conditionviolationid = cvl.conditionviolationid
and cv.messagecomponentid = mc.messagecomponentid (+)
group by policyid
order by 1
/

Sample output from lab with 16.0 MP2 installed:

  POLICYID    ML_ORIG MCL_CRACKED MCL_UNCRACKED CVL_MARKERS  SUM_TOTAL
---------- ---------- ----------- ------------- ----------- ----------
        16    1173728      540048          4480      108689    1826945
       141     303648      138928          2480       26374     471430
       161     866912      397008          2688       83030    1349638
           ---------- ----------- ------------- ----------- ----------
sum           2344288     1075984          9648      218093    3648013