Re: Check for uncompressed rows in compressed table

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 10 Apr 2008 09:34:24 -0700 (PDT)
Message-ID: <711cdb63-c1e2-4edb-a498-8c0716fcff3c@k37g2000hsf.googlegroups.com>

On Apr 10, 11:45�am, gareth <gareth.e..._at_britannia.co.uk> wrote:
> Folks,
>
> Is it possible to check for uncompressed rows in a compressed table?
>
> I have looked everywhere and I cannot find an answer to this.
>
> Thanks in advance

I am unaware of any rdbms dictionary or v$ view that will provide this information.

The last I knew is that if a row in a compressed table was updated the updated row was stored uncompressed but this was on 9.2.

HTH -- Mark D Powell -- Received on Thu Apr 10 2008 - 11:34:24 CDT

This message: [ Message body ]
Next message: Mark D Powell: "Re: Are the number of posts to comp.databases.oracle.server dropping off ?"
Previous message: Barry Bulsara: "Re: pl/sql: display employees who hired in specific month"
In reply to: gareth: "Check for uncompressed rows in compressed table"
Next in thread: DA Morgan: "Re: Check for uncompressed rows in compressed table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message