Re: Space Management w/ LMTs

I don't think I displayed confusion over fragmentation, but thanks..

But as you pointed out, as tablespaces grow, you still need to know how much space you have left in them, and with uniform extents you might want X extents to be available, with dictionary tablespaces your criteria must be different.. hece the query i posted earlier.

-a

On 7 Apr 2005 15:35:50 -0700, "Joel Garry" <joel-garry_at_home.com> wrote:

>There's always "tablespace map" in OEM (coming back in 10gR2, or so I
>understand).
>
>You might review hjr's explanation of frag:
>http://www.dizwell.com/html/fragmentation.html as well as tkytes:
>http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:733126913855
>
>So what you are really wanting to know is how much and how many chunks
>of contiguous free space you have... right?
>
>jg
>--
>@home.com is bogus.
>"Me, i use autoextend datafiles most of the time -- i have no "warning"
>scripts
>like this (keep a nice pad in the OS)
>" - Tom Kyte
>

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Apr 08 2005 - 16:15:27 CDT