Blogs

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.

Oracle 10g New Features: Changes to dbms_stats

articles: 

With Oracle Database 10g, there are some new arguments available for the dbms_stats package subprograms. Those parameters are as follows:

  • granularity
  • degree

Oracle 10g New Features: Advisory Framework - ADDM

Advisors are the server components that provide you with useful feedback about resource utilization and performance. The most important of all advisors is the Automatic Database Diagnostic Monitor (ADDM). ADDM does analysis of the system, identifies problems and their potential causes, and comes up with recommendations for fixing the problems. It can call all other advisors also.

Oracle 10g New Features: DML Enhancements

articles: 

In this article (chapter) we will look at new features surrounding the DML commands INSERT, UPDATE, and DELETE.

Donald K. Burleson's picture

Improved 10g management with EM

Just a few years ago, many senior Oracle DBAs detested Oracle Enterprise Manager (EM). Viewed as a crutch for beginners who could not memorize the command syntax, EM was largely ignored by the veteran DBA who preferred the ease and certainty of the SQL*Plus command-line interface. This is about to change.

Oracle 10g New Features: Flashback and RMAN

articles: 

Two improvements have been made in the backup and recovery areas in Oracle 10g. When user errors and logical corruptions occur in the database, flashback functionalities provide fast and flexible data recovery. When physical or media corruption occurs in the database, RMAN delivers an improved and simplified recovery method.

Pages

Subscribe to RSS - blogs