Oracle Database Migration

Although we do not specialise in DBA activities, we do have quite a large amount of experience in migration databases between different versions.

Moving from Oracle 7 or 8i up to 10g is a current requirement, and a task that we have performed for a number of different clients.

If you have a database migration project that is either part of a Forms and Reports migration or completely separate, we would be happy to have a look at your requirements and provide a quotation for the work completely free of charge.

SQL Tuning

All database access is via SQL statements. The pieces of SQL need to be working optimally to provide your application with its best performance. If you change versions of the database, you might be moving to a different optimiser goal, this might mean that some of your SQL statements run in a much longer timeframe that before.

Alternatively you might have a slow performing application, where that slowness is due to the application SQL and not the database or the hardware. In this case, tuning the SQL may give you significant improvement sin performance of the application. Methodsoft can help with the SQL tuning, we have skilled consultants who can work wonders on tuning your SQL in a very short space of time.