• December 29, 2005 29 Dec'05

    Performance probem with INSERT statement

    I am facing a performance problem with an INSERT statement inserting records in one transaction table. The table has around 20 columns and all are NOT NULL columns. It has seven indexes and many constraints. There are many concurrent inserts ...  Continue Reading

  • December 29, 2005 29 Dec'05

    Keeping data recovery site active

    My current environment is 9i release 2 on AIX 5.3. I have an OLTP database with heavy trans rate, average 300 transactions per sec. The application type is online banking, responsible for buying and selling stocks online to thousands of users via ...  Continue Reading

  • December 29, 2005 29 Dec'05

    Developing a performance monitoring tool

    I want to develop a performance monitoring tool for Oracle. What are the important parameters I should consider? This tool must be independent of any platform. Which language would you suggest to use?  Continue Reading

  • December 29, 2005 29 Dec'05

    Scripts for backing up Oracle objects

    I want to write scripts which will give me backups of Oracle 9i objects, e.g., tables, etc. How can I write them? Or can I get such scripts free online?  Continue Reading

  • December 16, 2005 16 Dec'05

    COMMIT after deleting X records

    I would like to know if there is an automatic way or command to do a COMMIT after deleting X records. If I have 1 million records to delete, what is the best way to delete and keep good perfomance?  Continue Reading

  • December 16, 2005 16 Dec'05

    The three smallest numbers

    How do I find the three smallest numbers from a column of numbers?  Continue Reading

  • December 16, 2005 16 Dec'05

    Sequence of WHERE and ORDER BY clauses

    In this query, I can see that the WHERE clause takes place before the ORDER BY. Is there a way I can reverse this? My objective is to first sort the rows and then to pick the first one in the sorted rows.  Continue Reading