Re: LOCALLY MANAGED EXTENT PERFORMANCE
- From: rjamya <rjamya@xxxxxxxxx>
- To: Ibrahim.Dogan@xxxxxxxxx
- Date: Mon, 25 Apr 2005 17:47:15 -0400
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@xxxxxxxxx> 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>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
