RDBMS Server

Oracle RDBMS Server Articles

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.

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.

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.

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: DML Enhancements

articles: 

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

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.

Mark Rittman's picture

Building Oracle Applications that use Bind Variables

articles: 

If you've been developing applications on Oracle for a while, you've no doubt come across the concept of 'Bind Variables'. Bind variables are one of those Oracle concepts that experts frequently cite as being key to application performance, but it's often not all that easy to pin down exactly what they are and how you need to alter your programming style to use them. With this in mind, I've tried to pull together the key information about bind variables and why they are a 'good thing' when building Oracle applications.

Donald K. Burleson's picture

Unconventional Emergency Oracle Support

articles: 

Being an emergency support DBA is a job with huge stress-levels and it always provides a giant adrenaline rush for even the most experienced DBA. Senior management is in a panic, and high-level executives are continuously asking for a status update. Most of these databases are brand-new to me, and I have only a few minutes to access the situation and devise a plan to quickly relieve their bottleneck.

Oracle 10g New Features: Globalization Support

articles: 

Oracle Database 10g has expanded the ability to globalize Oracle databases dramatically. As you can see by looking over the following list of globalization improvements, Oracle has attempted to make Database 10g the database of choice for all globally supported and utilized databases.

Pages

Subscribe to RSS - RDBMS Server