Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> long raw 28000 extents
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
Received on Wed Jul 24 2002 - 06:12:42 CDT