December 2005

• December 29, 2005 29 Dec'05

  Tuning an expensive SQL statement

  I am using Oracle 9i Database on Windows 2000 Server. When I ran the query for expensive SQL statements in my production database I found the following statement. How do I tune this query?  Continue Reading

• December 29, 2005 29 Dec'05

  What criteria determines when code should be pinned?

  What criteria determines when code should be pinned? Using the following SQL do I pin those with the most loads? Runs? Or some other criteria?  Continue Reading

• December 29, 2005 29 Dec'05

  How to import Excel data into an Oracle DB?

  How to import Excel spreadsheet data into an Oracle database (10g)?  Continue Reading

• December 29, 2005 29 Dec'05

  PL/SQL program for auto-replying to users

  How can I write and install a program in PL/SQL for auto-replying to my users over the Internet by fetching their e-mail IDs from my online database?  Continue Reading

• December 29, 2005 29 Dec'05

  "Insufficient privileges" error

  I tried to log on as SYSDBA and received "ORA-01031: insufficient privileges." I am using Oracle 8.0 on Windows NT. How I can resolve the above issue?  Continue Reading

• 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

  Performance problems with Vignette on top of Oracle

  We are using Vignette IDM 19.2 on top of Oracle 9.2 i. Vignette creates a table to store references of documents. In our case we end up with a table containing several bilion rows, thus adding new documents to the IDM storage becomes slower and ...  Continue Reading

• December 29, 2005 29 Dec'05

  Questions about plan stability

  Plan stability is a major concern for me right now. Frequently when I update stats, a plan(s) changes and I get into hot water. I'm investigating stored outlines, but I have some concerns.  Continue Reading

• December 29, 2005 29 Dec'05

  Best organization of files on disks?

  I have a server with three disks (all in raid1). What is the best organization of the files (system, data, indexes, log, backup, etc.) on the disks to improve performance?  Continue Reading

• December 29, 2005 29 Dec'05

  Can we improve the performance of a tool by eliminating joins?

  We have an SQL statement that selects data from four tables by performing a join operation. The number of rows in each table is in the millions. The query is being fired from one tool written in C++ . Since the query is taking a lot of time to ...  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

  Error when executing procedures

  I have created a procedure and when I try to execute this, it's showing a common error for all the procedures I have created: "Procedure created with compilation errors."  Continue Reading

• December 29, 2005 29 Dec'05

  What files need to be backed up under 9i for a cold backup?

  What files need to be backed up under 9i for a cold backup?  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 29, 2005 29 Dec'05

  Problem with quick generation of archive log files

  I am using Oracle 9i release 2 with patch 5 as my production database in archive log mode. Yesterday users complained that performance are going down. I checked the database and found that archive log files are generating very quickly, nearly two ...  Continue Reading

• December 22, 2005 22 Dec'05

  Big moves for Oracle in 2005

  It was a year of mostly ups for Oracle, as the company blazed a trail of acquisitions throughout the IT industry. And experts predict more of the same for 2006.  Continue Reading

• December 20, 2005 20 Dec'05

  The open source year in review

  Following a year of both outright successes and discouraging setbacks, open source advocates are anticipating big gains in 2006.  Continue Reading

• December 16, 2005 16 Dec'05

  Hiding objects in a schema

  Is it possible that we can hide some objects in a particular schema, so that users can't see them or I have control in some way that if users can see they can't do anything to them?  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