• June 14, 2006 14 Jun'06

    Oracle acquires hosted call center firm

    Oracle will complement its Siebel Contact On Demand application with the acquisition of Telephony@Work, a provider of IP-based software infrastructure.  Continue Reading

  • June 14, 2006 14 Jun'06

    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 error message. The alter system statement is an ...  Continue Reading

  • June 14, 2006 14 Jun'06

    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.  Continue Reading

  • June 13, 2006 13 Jun'06

    Real Application Cluster (RAC)

    Real Application Cluster (RAC) is a component of the Oracle 9i database product that allows a database to be installed across multiple servers... (Continued)  Continue Reading

  • June 13, 2006 13 Jun'06

    Five Oracle developer best practices

    A refresher on some best practices designed to make sure that apps developers don't go messing up production boxes.  Continue Reading

  • June 13, 2006 13 Jun'06

    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 the database.  Continue Reading

  • June 12, 2006 12 Jun'06

    Help with optimizing a query

    I have a query that takes 1.32 seconds to be executed and I want to optimize it. The sessions table contains 1,686,862 records. The history table contains 4,110,637 records. The Employee table contains 76,919 records. The Department table contains ...  Continue Reading