---Marc Fournier <marc.fournier@acadiau.ca> wrote:
>
> On Thu, 23 Jul 1998, The Web Administrator wrote:
>
> > Nope.. Oracle has a background process which re-allocates free
space..It does get
> > fragmented, and the only real way to unfrag is to export (dump)
and import.No Vacuum,
> > at least on 7.3.2
>
> So, essentially, our VACUUM command provides functionality that
> Oracle *doesn't* have, right?
I don't think any fragmentation occurs under Oracle, if dataspaces are
allocated on raw-devices (wich is a functionnality PG doesn't have).
When you allocate dataspaces on raw devices, Oracle manage it's own
"file system", it's own cache-memory for this device, wich allows
a different cahce-strategy than the OS have.
--
H.Lefebvre
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com