Database Tuning (MOSC)

MOSC Banner

Lob data type and chained rows detected and SYS table migrated rows removing method

edited Jan 28, 2014 5:52AM in Database Tuning (MOSC) 5 commentsAnswered
Hello,

I have two questions:

1. I have a big user table with a BLOB column.This table is 17G but when I use analyze table compute statistics and query DBA_TABLES ,it only show the average row length is only 321 bytes. why no chained rows detected in this table?

2. I have some migrated rows in SYS table,can I use regular "alter table move "  to reorgnize those SYS table? Can I also change PCTFREE parameter for those SYS table?

My Oracle is 10.2.0.4 EE and OS is Windows Server 2008.

OWNER                     TABLE_NAME                     PCT_CHAINED  CHAIN_CNT AVG_ROW_LEN   NUM_ROWS   PCT_FREE   PCT_USED

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center