Re: informix vs oracle

"utkanbir" <hopehope_123@yahoo.com> wrote > 1. backup / restore > > informix : the backup set is a complete object . It does not depend > anything .It can be used as the only object in order to do restore. > If someone who only knows oracle ,doesnt know aynthing about the other > databases , this backup method can be the best one. But if you know > the other databases restore backup methods, oracle method is much more > difficult and complex. Only now I started working with Oracle, but mainly as a PL/SQL developer, besides being SQL Server DBA. Whomsoever I spoken to about Oracle backups seems to give a very complex picture. > 2. Parallel query > > oracle : parallel query bypasses the buffer cache. it directly reads > data from the disk into the user process's pga memory . It also does > not check whether a block is cached in memory or not , it reads the > disk every time. So same parallel query executed several times makes > the same amount of disk io . IS THIS REALLY TRUE? Sounds too outlandish to be true. When are our resident Oracle gurus MarkT and DMorgan when we need them most. well if despite all this Oracle is the leader in the RDBMS market, what does it tell about IT industry :-). I read some where that the same question was asked by some senior Microsoft employee "if MS is so bad, what does it tell about IT industry if it allowed MS to be the 800 pound guerrilla". I have used MS argument against Oracle folks who arrogantly assume their product to be the best purely on market share. My counter argument always been , "then we should also agree that MS products are best for the same market share reason". I don't have to tell how objective they are in their replies.