Tips

  • Regulatory compliance and the DBA

    At the top of business executives' minds today is how to meet regulatory compliance and corporate governance rules. New laws are changing the way companies collect, retain and manage information. D...

  • Building an Oracle team

    In today's e-business environment, maintaining high availability, optimizing performance and delivering consistent service are essential. Building and maintaining an effective Oracle team is now mo...

  • Accounts unused for X days

    Here's a script that shows accounts and number of days since last use. It assumes session auditing is enabled.

  • Send email from Oracle 10g Server

    In order to send email within Oracle 10g you must install and set up the UTL_MAIL package. UTL_MAIL isn't installed when the database is installed because the SMTP_OUT_SERVER parameter must be conf...

  • Fax documents from database

    This tip offers several options for sending a fax from an Oracle database.

  • Performance tuning a RAC implementation

    The performance tuning methodology for an Oracle Real Application Clusters (RAC) configuration can be broadly categorized into these seven steps.

  • Archive logs file system is exhausted

    This tip explains what to do if the disk file system fills up and the archiver is hung.

  • See who is logged into the database

    This script is used to see who is logged into the database.

  • Changing to a shared server

    To change your Oracle 9i release 2 database from a dedicated server to a shared server, you must change the number of dispatchers to at least one. But if you run this statement you will receive an ...

  • Control Oracle services on Windows

    A number of services are started by Oracle9i when it's installed on Windows. These services consume a lot of resources and should be shut down when they are not needed.

  • Numbers to words in any language

    This tip describes how to convert numbers to words while logged into Oracle Applications as an English user, using a custom view and function. This should work for any language that is installed on...

  • Which Oracle session is blocking on which row

    This script will help a DBA see which session is blocking another and on which row.

  • Lessons learned: Integrating Oracle and SQL Server

    Whether you're trying to execute an Oracle stored procedure on SQL Server or move data from one DBMS to another, you'll find troubleshooting advice in this collection of short lessons by Kevin Klin...

  • Recognizing classic SQL patterns

    In this chapter from his book "The Art of SQL," Stephane Faroult examines the nine most common situations encountered when accessing data in a properly normalized database.

  • Why PostgreSQL can best SQLServer, Oracle

    Authors Robert Treat and Jason Gilmore explain why the PostgreSQL open source database management system can take on heavy-duty enterprise jobs.

  • Core principles of data warehouse design

    This excerpt from "Database Modeling and Design: Logical Design, Fourth Edition" by Toby Teorey provides an overview of the fundamentals of data warehousing, one of the three core tools of business...

  • Learning Guide: Data warehousing and business intellige

    This learning guide compiles articles, analysis, tips and expert advice on basic and in-depth data warehousing and business intelligence topics.

  • Got CRM? 10 questions to ask before you buy

    CRM is a big investment. Consider these strategic and technical questions before you take the plunge.

  • Cryptography in the database

    This excerpt from the new book by Kevin Keenan introduces the three types of data cryptography.

  • Seven rules for well-behaved primary keys

    Seven quick rules for designing correct primary keys in Oracle databases.