Re: basic compression

From: joel garry <>
Date: Thu, 15 Jan 2015 15:23:26 -0800 (PST)
Message-ID: <>

On Thursday, January 15, 2015 at 12:58:56 PM UTC-8, 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 wouldn't know, but there might be some clues in Jonathan's series:


-- is bogus.
Brian Williams and Dick Pope.
Received on Fri Jan 16 2015 - 00:23:26 CET

Original text of this message