Tips

  • Oracle and SQL Server: BFF?

    An overview of some of the new and old ways to successfully exchange data between Oracle and SQL Server 2005 instances.

  • Hierarchical storage management for database growth, pa

    Hierarchical storage management is one of several possible solutions to uncontrolled database growth. Part one of this tip outlines some other options, such as data deletion and hardware upgrades, ...

  • Five ways to prepare for a SOX audit

    DBAs, prepare for the inevitable Sarbanes-Oxley (SOX) audit with these five best practices for compliancy.

  • Inside the Oracle 11g SQL Performance Advisor, part 1

    This preview from the forthcoming book "Oracle 11g New Features" describes the goals of holistic SQL tuning and the steps to perform automated SQL tuning with Oracle 11g's new SQL Performance Advis...

  • Inside the Oracle 11g SQL Performance Advisor, part 2

    Part 2 of this excerpt from "Oracle 11g New Features" explains how to create a SQL Tuning Set (STS) to be used as input for the SQL Performance Advisor, Oracle 11g's new automatic SQL tuning feature.

  • Using the cost-based optimizer to improve Database 10g

    An advantage of upgrading to Oracle 10g is that the cost-based optimizer (CBO) has been improved to choose the best execution plans based on statistics of the data. But one of the most common cause...

  • How to read a STATSPACK report

    Part of our "How do I do that in Oracle?" series, this tip explains in detail how to read and understand a STATSPACK report.

  • How to uninstall Oracle

    Part of our "How do I do that in Oracle?" series, this tip, compiled largely of advice from our expert Oracle DBAs, explains in detail how to uninstall Oracle software from your system.

  • Complete guide to becoming an Oracle DBA

    This three-part tip series is your complete guide to becoming an Oracle database administrator (DBA), from building your resume, acing the job interview and getting certifications to climbing the r...

  • The power of Oracle certification

    Wondering whether or not to get certified? This tip discusses the costs and benefits of getting Oracle certification and how certification factors into your Oracle DBA career.

  • How to apply an Oracle patch

    Part of our "How do I do that in Oracle?" series, this tip explains in detail how to apply a patch or patchset to your Oracle system, with advice compiled largely from installation and upgrades exp...

  • Becoming an Oracle database administrator

    This excerpt from the forthcoming "Oracle Job Interview Handbook" by Donald Burleson answers some common questions asked by aspiring Oracle database administrators (DBAs), such as what to study in ...

  • DBA 102: Beyond the basics

    Learn how to go beyond the basic roles of a DBA -- these hard and soft skills will help you prove your value to management and ensure your job security.

  • Tuning the Oracle database with initialization paramete

    This chapter excerpt contains tips designed to achieve the greatest performance gain in your Oracle database with the least effort by focusing on the initialization parameters that yield the bigges...

  • Hierarchical storage management for database growth, pa

    Hierarchical storage management is one of several possible solutions to uncontrolled database growth. Part two of this tip outlines some other options, such as database partitioning and archiving, ...

  • Protecting your online Oracle data

    The instant access and zero cost of the Internet create a significant threat to any Oracle database deployed on the Web. Find out how to protect your online Oracle data from security threats with t...

  • The DBA job interview: Getting back to basics

    DBAs are again in high demand, but this should not be viewed as a free ticket to a new, higher-paying job. Having superior credentials does not mean that all you have to do is submit your resume a...

  • Rapid application development of Oracle Web systems

    You can implement a Web-enabled Oracle database using complex tools such as XML and PHP. However, these are not easy tools for deploying complex Oracle Web systems. Oracle Application Express (HTML...

  • PL/SQL do's and don't's from Steven Feuerstein

    Oracle PL/SQL expert Steven Feuerstein advises on what you should never do in PL/SQL -- and what you should always do.

  • Five DBA best practices

    Former DBA of the Year Arup Nanda provides five best practices for the Oracle DBA.