(Richard Stroupe) Oracle provides a utility, called RapidWiz, to automate the 11i Apps installation process. RapidWiz prompts the user for specific locations of prerequisite software, as well as the locations to install the underlying components used by the E-business suite. All three tiers are inst

(Ehanth Lingam) The following code will help you to create a table called “emp” in oracle database with three fields namely id, name, photo. The field photo is a blob field for which you are going to insert an image as the value using the code. The image size may be anything even in GB as the blob

(Steve Muench) A bind variable is a placeholder in a SQL command for a value that will be supplied at runtime by the application. Because you can change the value of the bind variable as many times as needed without changing the actual text of the SQL command, the database can reuse the same stateme

(James F. Koopmann) Performance in Oracle is directly related to the SQL workload that is submitted. Often it is not the change in the SQL that degrades performance but instead is the access path to that data. This article will help you understand when new access paths have been introduced in your e

(Tarry Singh) In the concluding part of this series, we will discuss the cluster latency and overhead alarms, the Global cache alarms and the ASM alarms.

(Martin LaMonica) Oracle has no plans for a whole-sale shift away from an upfront license model to subscription pricing as rumored, a company representative said.

(Vishwamithran S.) This script reports the session-wise open cursor count, which can be helpful information when tuning the open_cursor parameter (in environments where application changes are frequent).

(Frank Nimphius and Duncan Mills) In a very short time, J2EE Web technologies have evolved from a static content serving environment to a reliable platform for dynamic business applications that run on the intranet and the internet. The promise of the Web is that in the future the browser is the onl

(Tao Zheng) As production data warehouse extract, transform and load (ETL) can be a very time-consuming and resource-intensive task, plus the fact that the ETL window has become increasingly shortened while data size is exploding, there is always pressure on data warehouse developers and managers to

(Mark Rittman) When you need to load millions of rows of data into a table, the most efficient way is usually to use an INSERT, UPDATE, or MERGE statement to process your data in bulk. Similarly, if you want to delete thousands of rows, using a DELETE statement is usually faster than using procedura