Re: index fragmentation

> But surely the only time you access the uet$ is
> when you run queries against dba_extents and
> dba_segments ?

In a sense, true. But what about the recursive SQL when you are loading data into the table? If the table needs a new extent, then both uet$ and fet$ need to be updated. And this happens when no one has queried dba_extents or dba_segments.

HTH,
Brian  

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================