Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Space Management w/ LMTs

Re: Space Management w/ LMTs

From: Joel Garry <joel-garry_at_home.com>
Date: 7 Apr 2005 15:35:50 -0700
Message-ID: <1112913350.674631.19860@z14g2000cwz.googlegroups.com>


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
Received on Thu Apr 07 2005 - 17:35:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US