basic compression
From: geos <geos_at_SPAMPRECZ.autograf.pl>
Date: Thu, 15 Jan 2015 21:58:33 +0100
Message-ID: <m999mc$coi$1_at_node2.news.atman.pl>
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.
Date: Thu, 15 Jan 2015 21:58:33 +0100
Message-ID: <m999mc$coi$1_at_node2.news.atman.pl>
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