Oracle Editioning — Upgrading database applications while in use

Among the features introduced in Oracle 11g is Edition Based Redefinition. This feature enables us to have multiple active versions of database objects in order to facilitiate online application upgrades. Prior to this release, if an application used stored procedures or triggers, upgrades required database downtime in order to redefine database objects. This new feature […]

Critical Oracle Security and Stability Flaw Discovered

Infoworld today announced that they have been researching a flaw in oracle that can result in the inability to restore your database. Large oracle shops with interconnected databases are most at risk. The problem revolves around oracle’s SCN (system change number). The number has a limit that if exceeded, can render a database unusable, even […]