RE: LMT ASSM & next extent

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Wed, 11 Feb 2004 14:41:50 -0500
Message-ID: <1357B9FD14F9D41187800008C7A47B350336A4D9@corpa1.polaroid.com>

Jack,
I use max(bytes) from dba_extents as a substitute for segments in non-uniform LMT's. It's not completely accurate, of course, because of the extent size transition points, but it's close enough for my purposes.

Mike Hand

-----Original Message-----

From: Jack van Zanen [mailto:JACK_at_QUANTSYSTEMS.NL] Sent: Wednesday, February 11, 2004 7:18 AM To: 'Oracle-L Freelists'
Subject: LMT ASSM & next extent

I have my script that will monitor for objects that can not allocate their next extent. However on databases using LMT with autoallocate I do not have a value for next extent. How can I get this figure anyway, or is their a view that will give me the space bound objects?

Tia

Jack

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

--

This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Wed Feb 11 2004 - 13:41:50 CST