Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

---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