(Richard Phillips) There are four SQL*Loader direct path load parameters that directly affect the elapsed time of direct path load operations: –READSIZE is the size of the buffer used to read data from input data files. –COLUMNARRAYSIZE is the number of rows in a two-dimensional array used

(Steve Callan) In a previous article, I discussed a deployment framework for getting Forms on the Web. This article discusses the steps to get your Reports on the Web. I’ll cover the steps to use Reports-related built-in’s in your forms, how to “tell” your forms the name of your report server, h

(Robert Westervelt) Oracle Corp. president Charles E. Phillips Jr. addressed publicly for the first time the company’s souring public image amid his company’s 15-month battle to acquire application software vendor PeopleSoft Inc. In an interview with SearchOracle.com, Phillips acknowledged that t

(Duncan Mills) A confused ADF user has a problem with the commit button in a ADF BC bound JSP Page. Dragging the Commit operation from the Data Control Palette onto the page creates the button to trigger the event OK but when you run the page the button is disabled… Why? and how can you make the c

(Galina Petrenko) The following technique shows how to find the last record ( last entry ) from the history table. When the history table has a timestamp column, you can use an N-Row query with a descending sort on that column and get just one row. Use similar techniques when the timestamp column is

(Brad Cowdrey) This is a series of articles on the SQL analytic features of Oracle9i. At first glance, they seem foreign and overly complex; however, once the features are demystified, they become very powerful tools in the business intelligence and reporting environments. Part 2 explores aggregatio

(Casimir Saternos) As PL/SQL a code base for an application grows over time, the number of dependencies that exist can grow and become difficult to manage. This can be especially difficult for the DBA being called upon to support a legacy system that has had numerous independent developers contr

(Magnús Kristjánsson) As a software development shop involved with XML technologies for several years, Theriak Software (formerly eMR) has witnessed firsthand the many recent improvements Oracle has made in these technologies. This article explores some of the techniques we used to successfully buil

(John Smiley) This is the first in a series of guides that provide all the steps for installing the major components of Oracle 10g software on Linux. All three of the certified English-language distributions of Linux are covered in detail (Asianux is not covered), and the articles assume that inexpe

(Robert Westervelt) Oracle security expert Arup Nanda said Oracle’s latest alert is frustrating to DBAs since very little information was released with each patch. With little information to go on, many enterprises are being forced to take entire systems out of production, Nanda said. (R)