A Critical Patch Update is a collection of patches for multiple security vulnerabilities. It also includes non-security fixes that are required (because of interdependencies) by those security patches. This Critical Patch Update contains 101 new security fixes across all products.

(Philip Greenspun) The relational database provides programmers with a high degree of abstraction from the physical world of the computer. You can’t tell where on the disk the RDBMS is putting each row of a table. For all you know, information in a single row might be split up and spread out across

(James F. Koopmann) Have you ever needed to generate a real database load on Oracle for testing purposes? Or maybe another good question is: Have you ever tested your database procedures with a real load on Oracle?

(Brian Peasland) What is an outer join? How is it advantageous over an inner join? (R)

(Christo Kutrovsky) Have you ever had a performance problem on your database server? Have you ever received a call to let you know that “the database is slow,” and when you login to the server via SSH it takes forever? (It’s funny that I even ask this, of course you have.) You run top (it also takes

(Mark Brunelli) With Oracle OpenWorld less than two weeks away and Oracle showing signs that it’s going to refrain — at least in the short term — from making any more major acquisitions, now is the time for the database and business applications powerhouse to retrench, digest its many purchases an

(Sreeram Surapaneni) Oracle 10g offers several new features, one of which is Data Pump technology for fast data movement between databases. Most Oracle shops still use their traditional export and import utility scripts rather this new technology. Data Pump technology is entirely different from the

Setting up and managing printers within the Oracle E-Business Suite is challenging. In this paper, we will discuss tips and tricks to reduce printer setup and management effort as well as how to enable users to print Oracle output to any local or network printer making Oracle Apps printing “plug & p

(Steve Callan) Do you know what your database is doing after dark and on the weekends? What happens between 10 P.M. and 6 A.M. on weekdays, and all weekend? Would you be surprised to know that Oracle, by default, schedules a job to gather optimizer statistics upon creation of a database?

(Michael Kleiser) Here’s a tiny function that may be useful for debugging, especially with multibyte charater sets.