[Info-vax] Oracle Database vs Oracle/Rdb
IanD
iloveopenvms at gmail.com
Fri Jun 28 07:01:56 EDT 2019
RDB monitor is awesome, I believe it's better than Toad
Oracle supported on the fly index rebuilding without having to take the DB down, something that RDB never properly mastered
Snapshots were constantly a PITA with RDB. Snapshot truncation came very late in the piece and still caused issues because they only ever grow, they never shrink unless your force them
Index drops of mix page storage areas also was painful
I don't know why RDB could never get 100% guaranteed clean database backup starts happening. How many times over the years did RDB fail to acquire a quiet point
Having to do an export/import to change I think the database page size also was never modernised to be a dynamic operation. Our database was simply too large to do an export/import in a given database window
RDB's revolving aij's, emergency journals were ahead of their time
The RDB optimiser I believe was the first of it's type in the world? Being able to then force the DB to use a query outline versus internal strategies was also amazing
Most of the goodies around I/O performance through storage mapping and storage placement went away with faster disks, SAN etc but what impressed me was how much optimisation you could do within RDB and tricks it used, like spam pages, mixed pages etc, all seemingly born out of a need to overcome bottlenecks probably encountered over the years
Faster CPU speeds, huge memory servers, fast I/O seems to have removed the need to go down to such fine levels of performance tweaking now
Now Oracle say they have a total self maintaining database environment now, no need for a systems DBA anymore (of course you need to have everything in their DB environment and conforming to their standard) but on paper it looks good
RDB engineers were smart fellows, but Oracle loves Oracle and they originally believed the two databases would merge but quickly found out that dream was never going to happen, they are fundamentally too different in the engine room
RDB doesn't see much in the way of huge advancements anymore (I stopped looking at the release feature sets a few years back)
Maybe they might sell it to VSI but I suspect they would rather it just died and went to DB heaven and it's customers embraced it's first love, Oracle
Any word if Oracle is going to bother with a port of RDB to x86?
Wasn't RDB V8 running or partially running on Windows NT?
(Too long ago to remember)
More information about the Info-vax
mailing list