Re: basic compression

On Thursday, January 15, 2015 at 3:58:56 PM UTC-5, geos wrote:
> initally a table was created with basic compression and loaded using
> direct load insert. during table usage time there were performed some
> updates, some non-direct load inserts, deletions etc. so after a while a
> table is composed of compressed and uncompressed blocks living altogether.
>
> do you know if is it possible to tell whether a particular block is
> stored in compressed or uncompressed form when using basic compression
> for a table? is this information available at the block level with the
> help of some oracle system functions that operate on blocks?
>
> thank you
> geos

I do not have time to read Joel's reference at the moment so my apologies if this is in the material but I suspect you can see this in the block dump of the table/index. That is I expect there is flag set that will show in the dump but I do not have time to test this either but it should only take you a few moments to find out.

HTH -- Mark D Powell -- Received on Fri Jan 16 2015 - 20:01:00 CET