Evaluate

Evaluate

Weigh the pros and cons of technologies, products and projects you are considering.

• Creating two databases on same system

  How to create two databases on the same system? I am using a Sun Solaris 9 system and Oracle 9.2.0.1.0. I already have a database and I want to create another database on the same PC. Continue Reading

• Third-party tools for RMAN backups

  I have seen many companies use third-party tools for RMAN backups, mostly Veritas Netbackup for Oracle on Solaris. Could you please tell me the difference between RMAN use through that tool and RMAN use by itself with the Unix prompt? Continue Reading

• How to configure a new Oracle 9i system with fewer CPUs

  We are in the process of migrating our 9i databases off an HP V 2500 box (16 CPUs, 64-bit) to an HP RP 8420 (6 CPUs, 64-bit). Other than upping the "parallel threads per CPU" parameter to compensate for the lesser amount of CPUs in the new box, what... Continue Reading

• Error connecting to 10g on dual OS system

  I have installed Red Hat Linux on a Windows 98 system. When I connect to SQL*Plus it is giving an error: "Net Service Name is incorrectly specified." Continue Reading

• 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

• 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

• Updating changes to DB objects with new releases

  We are developing a large application base on PL/SQL. We often have to change DB objects. The biggest trouble comes with every new release. To enhance our application we have to know about the latest state of all DB objects. To find this out, we ...Continue Reading

• Steps for importing an 8i database to a 9i/Linux system

  I have a full export dump from an Oracle database (version 8i) from a VAX/Alpha machine. I want to import to a Linux system which has Oracle 9i installed. What steps should I follow?Continue Reading

• Best tool for migrating SQL Server database to Oracle

  What is the best tool to migrate a SQL Server database to Oracle (10g)?Continue Reading

• Help with export/import feature

  Could you help me out with the export/import feature in Oracle9i? Could you give me an example that I could follow while exporting my database?Continue Reading

• Is the migration from 10g release 1 to release 2 simple?

  Is the migration from Oracle 10g release 1 to release 2 simple? How about migrating any applications developed in release 1 to release 2?Continue Reading

• Using a union in the query rewrite feature

  I have a question regarding query performace and the query rewrite feature. I have three tables and one dummy table. Is it possible to have a union used in query rewrite? If so, how, and if not, can you offer a different solution?Continue Reading

• Problems with runInstaller on Mandrax Linux system

  I was trying to install Oracle 9.2.0.1 in a Mandrax Linux system, but when I run runInstaller, after getting the first page, it's not taking me to the next screen. It doesn't even give me an error. What to do?Continue Reading

• DBAs look (far) ahead to Database 10g Release 2 upgrades

  Database administrators at Oracle's OpenWorld conference said they're looking forward to the new features of Database 10g Release 2, but for most those upgrade plans are still a long way off.Continue Reading

• Setting up OS authentication for different servers and operating systems

  Is it possible to set up OS authentication when OS and Oracle DB are in different servers and different operating systems?Continue Reading