• Oracle 10g expert SQL tuning techniques

    This book excerpt focuses on real-world techniques for improving the speed of SQL queries with a focus on new Oracle 10g features. The topics include the new Oracle parameters that affect SQL performance, the use of hints to change SQL execution ...  Continue Reading

  • Database down! Bring it back alive!

    This excerpt from "Everyday Oracle DBA" explains what to do in the event that your database goes down and you're under pressure from your managers to get it back up as soon as possible.  Continue Reading

  • A bit wiser with Oracle technology

    Learn how to use a metadata repository to identify a "source of truth" for each customer attribute in a data warehouse. This tip explains how to use the base-two numbering values of the primary key in the data source reference table and bitwise ...  Continue Reading

  • Recovering from user errors

    This book excerpt explains how to recover a dropped table using Flashback technology, manage the recycle bin, perform a Flashback Table operation, recover from user errors using Flashback Versions Query and perform transaction-level recovery using ...  Continue Reading

  • Recover Oracle databases

    This book excerpt explains how to recover from the loss of a controlfile, redo log file or system-critical or nonsystem-critical datafile.  Continue Reading

  • Predictive modeling in Oracle

    Oracle professionals are now applying the proven predictive modeling techniques from Oracle data mining (ODM) and we are seeing them use special techniques to analyze database signatures and predict upcoming database stress. This book excerpt has ...  Continue Reading

  • What is the DUAL table costing you?

    The DUAL table is one of the first things we learn as Oracle professionals. It is created by default as a single row table, understood by the optimizer and available to everyone for selection. This article will explore the cost of querying the ...  Continue Reading

  • Oracle RAC design: The effects of component failure

    This excerpt from the book "Oracle 10g Grid & Real Application Clusters" shows expert techniques used by real-world RAC professionals for designing a robust and scalable RAC system. This section provides a quick look at the effects of component ...  Continue Reading

  • Oracle vs. Sybase: 10 reasons to use Sybase on Linux

    Despite its fall from market leadership, Sybase is still a strong enterprise offering, says database consultant Dr. Mich Talebzadeh. In this tip, he gives 10 reasons why Sybase on Linux bests other databases, particularly Oracle.  Continue Reading