Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Space Management w/ LMTs
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 KyteReceived on Thu Apr 07 2005 - 17:35:50 CDT