Rittman Mead - Delivered Intelligence

Eric Mortensen has started an Oracle Weblog that looks at issues around the Oracle RDBMS, SQL and PL/SQL. In the first few postings, Eric has looked at safe type conversion with PL/SQL, a full-table scan like search design pattern, and fast table refresh in high-availability environments. There’s also an RSS feed to use in your [...]

"Oracle recently announced on its Web site that it is launching a new Linux certification: Managing Oracle9i on Linux. Oracle describes the title as the "first" specialty for those holding its Oracle Certified Professional Database Administrators (OCP DBA) certification, hinting that more may be on the way."  writes Becky Nagel for Certcities.com.

"Oracle will finish switching its 9,000-person in-house programming staff to Linux by the end of 2004, the database powerhouse said Wednesday." writes Stephen Shankland for CNET News.com. "In October, the company finished the Linux transition for the 5,000 programmers of its Oracle Applications software. Now the transformation has begun for those who work on the [...]

The forthcoming ODTUG Conference 2004 has a number of presentations that’ll be of interest to Oracle BI&W developers. As it’s in Arizona I can’t quite see my resources stretching to attending but if you’re an ODTUG member, it’s sounds it’ll be worth going along. Getting from Zero to OLAP Quickly – Jean Pierre Dijcks, Principal [...]

"Tuning problematic SQL statements is neither rocket science nor magic. All relational databases generate an execution plan for the submitted SQL. This execution plan then tells Oracle how to retrieve the data, or, how to perform the data-related tasks. The better you understand how to interpret these explain plans, the better you can resolve possible [...]