December 2005

• 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 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

  "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

  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

• December 15, 2005 15 Dec'05

  Wily bridges gap between apps managers and DBAs

  A new tool from Wily Technology Inc. aims to bridge the technological divide between applications managers and DBAs.  Continue Reading

• December 14, 2005 14 Dec'05

  List of Oracle apps APIs?

  I need the whole list of Oracle apps APIs that are used for inventory and purchasing order modules.  Continue Reading

• December 14, 2005 14 Dec'05

  Barcode printing in Oracle

  Is their a simpler way to perform barcode printing in Oracle other than developing a print routine?  Continue Reading

• December 09, 2005 09 Dec'05

  Difference between cluster and grid

  What is the difference between a cluster and a grid? Is it a conceptual difference or a technical difference?  Continue Reading

• December 09, 2005 09 Dec'05

  What is the max number of sessions that Oracle 8i supports?

  I want to know the maximum number of concurrent Oracle sessions that Oracle 8i could support. I know that it depends upon the parameters, e.g., LICENSE_MAX_USERS, defined in the initSID.ora file. But what is the maximum sessions that I could get a ...  Continue Reading

• December 08, 2005 08 Dec'05

  Query for five most recent dates

  I have a table that I want to query by a char date field. I want to get the five most recent dates. So far using MAX in a subquery I can get one row. How do I get the rest?  Continue Reading

• December 07, 2005 07 Dec'05

  Cryptography in the database: The last line of defense

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

• December 06, 2005 06 Dec'05

  How does Oracle 8i differ from Oracle 8?

  What does the "i" stand for in Oracle8i? I know it is an advanced version of Oracle 8 for Internet-based applications. But I don't know how it actually differs in applications. I know even with Oracle 8 we can connect through the Internet to the ...  Continue Reading

• December 02, 2005 02 Dec'05

  What does the dump file consist of?

  When I export a dump from a database, what does the dump file consist of? Are all the views, triggers, procedures and packages in the dump file?  Continue Reading

• December 02, 2005 02 Dec'05

  Difference between RBO and CBO

  I do not have a clear idea about SQL tuning (Rule Based vs. Cost Based Optimizer). Could you explain the difference between RBO and CBO?  Continue Reading