Re: long raw 28000 extents

On Wed, 24 Jul 2002 13:12:42 +0200, "Peter Laursen" <ptl_at_edbgruppen.dk> wrote:

>Hi,
>
>A table consists of: number(pk), varchar2(30), date, lang raw,
>varchar2(100), number.
>I cannot change programs accessing the table. The long raw is there for
>good. I cannot change db-version
>
>At one customer on a 8.0.5 standard edition it has 20000 rows in 28000
>extents. Initial extent is 64k and next is 64k. Pctfree is 10 and pctused is
>40. Blocksize is 4k. Avg row size is estimated to 80k, chain count 14k,
>total blocks 500k. Activity on the table is mainly insert and select. Update
>and delete is rare. Table is always accessed by primary key. 5 or fewer
>users access the table at the same time. Activity and number of rows will
>rise in future, number of users will not.
>
>When I run " analyze table tname compute statistics" as tableowner i get an
>ora-1410 invalid rowid, however estimate works fine. Validate structure
>cascade reports zero rows invalid. How come i get the ora-1410?
>
>How you would reorganize this table for better performence and
>maintainability?
>
>If you had 8.1.7 standard edition how would this table fit into an LMT?
>
>TIA
>Peter Laursen
>
>
>

For better performance and maintainability a row need to fit in one block. That about says all about your options. Decreasing the 28000 extents to 1 is not going to help a damn.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jul 24 2002 - 12:18:55 CDT