This content has been marked as final. Show 5 replies
I would be really helpful to see what you have been doing but you have not posted your DML.
You can determine compression with DBMS_LOB.GETLENGTH.
If you are not seeing compression then it is likely Oracle has determined that it can not get past the 20% threshhold
under which it will not compress because it believes the overhead is greater than the benefit.
I've used the getlength method but that only tells me the uncompressed size of a record. I don't really need that since I have the original, uncompressed, file to compare things with.
The compression threshold thing is a nice thought but I know for a fact it is doing SOME compression because I can check in a huge file and the size difference of the total LOB will be only marginal.
Thanks for the help, but I ran out of time to determine an answer on this issue.