In multi-user systems, many users may update the same information at the same time. Locking allows only one user to update a particular data block; another person cannot modify the same data. The basic idea of locking is that when a user modifies data through a transaction, that data is locked by

Get an exclusive overview of Quest Software’s APM Suite for the Oracle J2EE platform at one of our free Webcasts. This live Webcast will demostrate how the APM Suite works with the Oracle AS 10g J2EE based platform – using Quest Foglight for monitoring the OC4J instances and diagnosing a J2EE ba

(Jayan Nair) There are numerous articles on .NET and ASP.NET. However, recently I had to develop an ASP.NET application connecting to an Oracle database and, to make everything work together, I had to solve several problems. This article will show you the step-by-step process to develop an ASP.NET c

(Sheryl Calish) Although the kernel is the heart of Linux, files are the main vehicles through which users interact with the operating system. This is especially true of Linux, because in the UNIX tradition, it uses the file I/O mechanism to manage hardware devices as well as with data files. Un

(Sanjay Mishra) One of the challenges of today’s distributed business environments is the sharing of information among a multitude of applications and databases. As the number of applications grows, you end up with several databases, which may even be from different vendors. Sharing information in s

(Scott Spendolini, Sergio Leunissen and David Knox) Securing an application begins with applying proper access control rules at the database level. One of the ways the Oracle Database helps you implement access control rules is through Fine Grained Access (FGA) control or Virtual Private Database (V

(David Welch) We’ve been exposed to a good number of Oracle Applications / E-Business Suite installations with significant performance challenges. We have come to the conclusion that a significant improvement in performance improvements can indeed be expected from such installations. To state it dif

(James Koopmann) There is nothing spectacular about using indexes per say. However, on many occasions I have come across a variety of SQL coders that never consider validating that the index they think they are using is efficient or even being used at all. We can all put indexes on the columns that

(Vladimir Przyjalkowski) Statistics held in V$tables help to reveal the load of certain SQL statements on the DBMS. However, the statistical values given are absolute, so a comparison is needed to know the load of your portion of SQL code. Here you’ll find SQL*Plus code to facilitate such a meas

(Roger Eisentrager) This script will both alert and capture relavent data on Oracle SQL blocking locks events. The following script creates 2 procedures, and 1 new table (in place of TBS_AAAAA put in the tablespace you want in this table) and submits the proc to DBMS_JOB, running it at 10 minute