(John Spirko) Uncover ways to properly tune your Oracle E-Business environment and learn how to detect, diagnose and resolve top areas of contention throughout the application. This Webcast delivers: • A primer on where Oracle E-Business transaction breakdowns are likely to occur (from the concur

(Arup Nanda) Lora, the DBA at Acme Bank, is at the center of attention in a high-profile meeting of the bank’s top management team. The objective is to identify ways of enabling end users to slice and dice the data in the company’s main data warehouse. At the meeting, one idea presented is to create

In Oracle, you can create an autonumber field by using sequences. A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key.

(C.J. Date) I wrote this short note in response to a paper titled Subquery Madness, in which the author, Jonathan Gennick, raises a question about subqueries in SQL and their implementation in Oracle. The following is an edited version of his question. We’re given a table called SUBTEST with t

The purpose of this document is to give an insight into how the Forms Listener Servlet can aid in the diagnosis and detection of various anomalies and errors commonly seen in a web deployed Oracle Application Server 10g Forms application. The paper discusses which files contain diagnostic informatio

(Steve Muench) As part of helping customers be successful with JDeveloper and ADF I’m often creating little example applications to illustrate a point. My goal is to document them and put them together with an OTN “HowTo” paper to accompany them, but I don’t always have the time to do the documentat

(John Paul Cook) In this article, I’ll explain the basic yet essential processes involved in building a .NET application that uses an Oracle database, including: –How to add project references to support Oracle class libraries in your .NET project –How to create Oracle Database connection

(Steven Feuerstein) Don’t use the XYZ feature; there was a problem back in version n.n.” “Always use explicit cursors; doing so is the most efficient way to fetch a single row of data.” “Avoid packages; they use too much memory.” I bet you’ve heard one variation or another of such statements

(Noel Davis) Welcome to Security Alerts, an overview of recent Unix and open source security advisories. In this column, we look at problems in the Linux kernel, Oracle Database Server, Oracle Application Server, DB2 Universal Database, vpopmail, MIT Kerberos 5, cfengine, CDE libDtHelp, Anonymous CV

(James Koopmann) I am often questioned about how I became a DBA and the road I traveled. This can be a very valid question because there are many DBA-want-to-bees that just do not know where to start. In the early years, many positions just fell into my lap, as there was a boom in the industry. This