(Dratz) So far we have discussed Oracle storage at different logical and physical layers and the basic memory structures. The last basic piece we need to in order to complete our “instance” is some code to actually do things.

(Tug Grall) If you are not familiar with Ruby on Rails, it is important to note that it has nothing to do with Java; it is a Ruby-based framework. Ruby on Rails is really interesting, powerful, and so on… but as a Java developer, I would like to do the same using Java (or equivalent) leveraging th

(James F. Koopmann) This article is the third and last in the three part series that has explored the use of VARRAYs in Oracle. This part will take a look at the performance implications if you should choose to use VARRAYS.

(Steve Muench) A view object is the Oracle Application Developer Framework (ADF) component that lets you work easily with SQL query results. View objects can be used to read rows of data; to create and hold rows of transient data; and to automatically insert, update, and delete changes made in your

(Terry Sutton) For years Oracle has been telling us to use the DBMS_STATS package instead of the ANALYZE command to gather statistics to be used by the Oracle optimizer. Many of us have heeded this advice and switched from using ANALYZE for scheduled statistics-gathering jobs to using DBMS_STATS. St

(Bob Watkins) When you need to troubleshoot inefficient SQL, one of the most important diagnostics tools at your disposal is the output of the EXPLAIN PLAN command. Find out how Oracle’s DBMS_XPLAN functions can help you tune your SQL statements.

(Dratz) Last time, we discussed some of the shared memory components in Oracle. This time we’ll talk about Oracle’s private parts (hey! get your mind out of the gutter). Specifically, let’s talk about the Program Global Area (PGA).

This white paper by Oracle discusses the Oracle Database 10g, Oracle’s largest, most innovative release ever. Product features and capabilities are discussed in detail. (R)

(David Sims) Algorithmic Research, a vendor of electronic signatures and data security products, has announced that it has become a member of the Oracle PartnerNetwork.

(John Fontana) Oracle has set in motion the second phase of its multiyear, three-prong plan to develop an integrated suite of identity management software using the piece parts it acquired over the last two years. The suite’s goal is to offer corporations everything from fine-tuned access control to