There is a major issue with flashback query, one of the key features of Oracle 10g. Although flashback is greatly improved in 10g (accurate within 3 seconds rather than 5 minutes in 9i), if the user actually tries to upgrade from 9i to 10g flashback query won’t work and gives wrong results. Additionally, the “transaction history” feature in 10g will be broken, giving wrong results without warning.
Oracle has adjusted its licensing terms for users of Sun Microsystems Solaris 10 operating system—a move that should help Sun better compete with rivals Hewlett Packard and IBM. Like users of rival software, Sun users will now be charged on a per processor basis. If a system has been partitioned so that it only runs Oracle on some of its CPUs, the user will be charged accordingly only for those CPUs used. At a licensing rate of $40,000 per CPU this change could represent substantial savings to some Sun customers.
According to Charles Phillips, president of Oracle, the next wave of PeopleSoft and JD Edwards releases will be certified on rival software stacks including Microsoft SQL and IBM’s DB2 database, in addition to Oracle’s Fusion middleware. In the future, however, Phillips has suggested that Oracle may simplify infrastructure management by optimizing applications on its own middleware rather than on oustide offerings.
In this edited transcript of her interview with IDG News Service, Oracle’s Chief Security Officer Mary Ann Davidson discusses issues surrounding maintaining the security of sensitive data. She covers the importance of auditing, difficulties with security researchers, and how her experience as a Naval Officer helps her fight the security war.
David Gornshtein and Boris Tamarkin of WisdomForce Technologies, Inc have written a very current technical white paper providing a comparison between MSSQL 2005 and Oracle 10g. It also discusses new features developed by Microsoft in order to compete with the Oracle database, and considers factors from the DBA’s perspective.
A new version of OPR (Oracle Password Repository) is out on beta. OPR is a Unix based secure tool for storage and retrieval of Oracle database passwords that replaces hardcoded passwords in scripts with a call to OPR. It is designed to keep your Oracle environment secure and easier to maintain.
Hot on the heels of Fyracle, Oracle-mode Firebird, there’s now a similar project for PostgreSQL. EnterpriseDB 2005 (EDB2005) is now available in beta. Compatible with many Oracle database applications, EDB2005 is an enterprise-class relational database management system that supports update-intensive high-volume applications.
According to Gartner, Inc., worldwide new license sales for relational database management systems (RDBMS) grew 10.3 percent in 2004 for a total of $7.8 billion. As far as new license revenue, Oracle and IBM landed in a virtual tie. IBM’s DB2 had nearly 9 percent growth in sales on the Z Series and Unix platforms, whereas Oracle saw nearly 15 percent growth, largely due to its performance on the Linux platform
Although database vendors have claimed for years that their relational offering supports unstructured XML data, IBM’s upcoming Viper release of DB2 may be the first to truly allow structured and unstructured data to maintain their respective native formats and be queried using SQL or XQuery statements.
According to analysts at Gartner Symposium ITxpo 2005, Oracle remains the dominant database vendor, but will face challenges as it tries to expand its middleware and applications sales. The slightest misstep when trying to merge its recent acquisitions will only serve to benefit its key competitor, SAP. Gartner analysts also predict that Oracle’s Fusion framework will be ready a year later than promised, which won’t help the company’s disjointed image.