Ibarhim,
No your query will not work. Extents sizes in autoallocate are based on an
algorithm, search the archive of oracle-l (at fatcity.com<http://fatcity.com>or
orafaq.net <http://orafaq.net>) if you prefer. AFAIK the algorithm changes
if you use non-standard initial extent as well. Since it is already in
archives I'll not search my emails to paste it here.
Raj
On 4/25/05, Dogan, Ibrahim - Ibrahim <Ibrahim.Dogan_at_lowes.com> wrote:
>
> No, it tells you the last extent size. That's pretty much your next
> extent in aoutoalloc LMT unless it is switching to next gear which will
> be just couple of times during the lifetime of a table..
>
> I'm still waiting your "alert" code...
>
> Thanks,
> =20
> Ibrahim DOGAN
> Sr. Sybase/Oracle DBA
> www.lowes.com <http://www.lowes.com>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 25 2005 - 17:51:33 CDT
