Re: Informix versus oracle

Daniel Morgan <damorgan@exxesolutions.com> wrote in message news:<3ED56F59.E4AB489D@exxesolutions.com>... > "Milton J. Vidrine, Jr." wrote: > > > Here are a few of the differences (or similarities, depending on how you > > look at it): > > > > Informix Oracle > > Raw disk space File system > > Logical logs Redo logs > > Physical log Rollback segment > > dbspace,dbslice tablespace > > shared memory sga > > (no correlation, OS auth) password file > > > > From what I have seen in Oracle DBA class and Backup / Recovery class, there > > is about an 85% correlation between Informix and Oracle as far as basic > > operation is concerned, other than terminology. > > > > HTH > > Milton J. Vidrine, Jr. > > > > Your knowledge of Oracle was current with what version? ;-) > > Both can use raw disk space. > > Oracle 9i no longer uses rollback segments by default and Oracle has announced > their elimination in future versions, 10i being due out in a matter of months. > > But, while I'd never feel comfortable putting a percentage on it you are roughly > correct, > the products are similar but with different architectures. Informix was also working on eliminating the physical log (Oracle's rollback segment). It was one of the reasons they made fuzzy checkpoints in version 9.3. I don't know where this effort is now. Brice Avila Minneapolis, Minnesota