Re: Null extents in DBA_SEGMENTS

Chuck Hamilton wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Oracle 8.1.7.
>
> What would cause the EXTENTS column in DBA_SEGMENTS to be null? I
> thought this always had to contain a known value. I've tried
> analyzing the index in question but it still left EXTENTS null. This
> is causing an OEM maxextents event to falsely report a pending
> failure.
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
>
> iQA/AwUBO1hTVGm5A4kkb4ZsEQIndACeIeBUPjzKOBh4OtEKFNT/mFyIaB4AnAov
> HMG80CsSqLkkSFpoMsU7fitL
> =jILQ
> -----END PGP SIGNATURE-----
>
> --
> Chuck Hamilton
> chuck_hamilton_at_yahoo.com
>
> "Do not be deceived, God is not mocked;
> for whatever a man sows, this he will also
> reap." (Gal 6:7 NASB)

The definition for DBA_EXTENTS comes from SYS_DBA_EXTENTS plus a few internal bits and pieces, and SYS_DBA_SEGS (which in turn from bits and pieces) - you could drill down and find which portion is causing the problem

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."