Blogs

Irfan Haq's picture

PL/SQL Best Practices

articles: 

As the discipline of software development evolves, software products grow in size and the code grows in complexity, the need for a set of guidelines and standards becomes increasingly evident. In this article I will enumerate some of the industry best practices that the experts have proposed and emphasized, in the context of PL/SQL programming.

Andrew Simkovsky's picture

Improve Performance and Data Consistency with Oracle Workspaces

articles: 

Managing large DML operations against a live database is one of the most common challenges Oracle professionals face on a regular basis. Such operations often cause serious performance problems and can cause inconsistencies in the data, especially when many referential integrity constraints exist among the tables. This article will explore how Workspaces can be used to solve these problems.

Donald K. Burleson's picture

Tuning Oracle Full-table Scans

articles: 

Oracle SQL tuning is one of the most important areas of Oracle optimization. This article explains how one can tune Oracle Full-table Scans.

Saikat Goswami's picture

Introduction to Tomcat 5.0 --- the Open-Source servlet container of choice

articles: 

Tomcat is the de-facto web server of choice. Written entirely in Java, you have access to the entire code (if you want to make changes). Read to get an introduction to Tomcat, where to download, how to install it on your machine and know about the xml files of importance.

Herve Deschamps's picture

Using Oracle Applications Flexfields in your custom forms: step-by-step

articles: 

There are several complicated things you may need to do with flexfields in your forms but one of them is simple and very common: create a foreign key on the accounting flexfield. It is easy to get lost in the Oracle Application Developer's Guide because it tries to cover comprehensively what can be done with flexfields. But there is nothing to show you the basics step-by-step, which is what we will attempt in this article.

Donald K. Burleson's picture

Avoid common Oracle Recovery mistakes

articles: 

Even Oracle Certified DBAs cringe at the thought of performing a real-world database recovery. As disk and hardware has become super-stable, many Oracle DBAs have never experienced the adrenaline rush of a full-blown Oracle recovery.

Saikat Goswami's picture

JDBC 3.0 Part III - Connection Pooling

articles: 

Making database connections are expensive in terms of machine resources. In this article, we will examine how a number of connections can be cached in a pool, and then used for accessing the database.

Donald K. Burleson's picture

Always use direct I/O with Oracle

articles: 

Many Oracle shops are plagued with slow I/O intensive databases, and this tip is for anyone whose STATSPACK top-5 timed events shows disk I/O as a major event.

Mark Rittman's picture

Streamlining Oracle 9i ETL With Pipelined Table Functions

articles: 

I've recently been reading Bert Scalzo's "Oracle DBAs Guide To Data Warehousing And Star Schemas", and he's got an interesting take on the ETL process that I thought it worth looking at in more detail.

Saikat Goswami's picture

JDBC 3.0 - Part II: : Transaction Fundamentals

articles: 

This article explores the fundamentals of a transaction, in the context of JDBC, Enterprise Java Beans and a database.

Pages

Subscribe to RSS - blogs