Re: Auditing SMON

Nuno Souto wrote:
>
> In article <3CE39D2C.D5B6D01_at_mytoys.de>, you said (and I quote):
> > I am just digging into Oracles internals and found SMON executing
> >
> > select f.file#, f.block#, f.ts#, f.length
> > from fet$ f, ts$ t
> > where t.ts#=f.ts# and t.dflextpct!=0 and t.bitmapped=0;
> >
> > Does anybody know ts$ and fet$ ?
> >
>
> Yes. Both are dictionary (SYS) tables. Exclusively look, but no touchy.

I'd never touch any $ tables! Although...some optimizing...

> TS$ contains the definitions of all tablespaces. FET$ contains the
> extents in all tablespaces that are free (not allocated to any object).
> From this, you should now be able to deduct what that SQL is looking at
> and why SMON was doing it?
>
> <hint: dictionary managed tablespaces have free space automatically
> defragmented when default percent increase of the tablespace is != 0>

Now I know...  

> Have fun.

I will ;-)

Thanks, Nuno (BTW, interesting name, where does it come from?)

Knut Received on Thu May 16 2002 - 07:17:32 CDT