Skip to Content
Former Member
Jan 27, 2009 at 02:32 PM

Any experiences with the table compression feature under ORACLE 10g


Hi database admin gurus,

we plan to use the feature according to SAPs approval in the notes 105047 and 701235.

what did you like regarding the feature, what not?

(i.e. benefits with space management, day-to-day adminstration of compressed tables/partitions).

what problems did arise using the feature?

How do you manage the identification of db tables that are candidates for compression and

how you come around the problem that a reorganization or new creation of the object condemn the compressed data?

some inputs would be helpfull...

we're using Oracle on AIX with BI 7...