We do the work.

Know where it hurts? We analyse the area, recommend changes or rewrite the code, and plan for growth.

Not sure what is wrong? We investigate:

1. AWR where your Diagnostics Pack entitlement permits it; otherwise STATSPACK.
2. Wait events and the underlying bottleneck.
3. Practical fixes and discussions with your application vendor.

• Interview administrators and application users.
• Analyse AWR or STATSPACK according to available licensing.
• Correlate reports with V$, X$ views and trace files.
• Review operating system configuration.
• Investigate a specific process or SQL statement, its execution plans, waits and database objects.
• Analyse traces, including 10046 and 10053.
• Deliver a report with recommendations or a revised SQL statement.

GETTING STARTED

Administration, infrastructure and database maintenance, analysis, configuration and system patching.

ADVANCED

Security assessment, performance optimisation, consolidation, migration and improved administrative procedures.

Outages are stressful. A tested recovery plan helps you sleep.

1. Design HA procedures.
2. Build backup and recovery scripts.
3. Agree the scope and terms of an SLA.

• Review Oracle installation and configuration.
• Review operating system configuration for database best practices.
• Analyse system and object privileges.
• Identify potential attack vectors and privilege escalation paths where excessive access is found.
• Review PL/SQL for SQL injection risks.
• Deliver findings and recommendations in a report.

1. Design the full migration path.
2. Advise on database versions and hardware.
3. Carry out the migration with the lowest practical downtime.
4. If you want to migrate to Windows, expect a lively discussion.
5. Help resolve issues that emerge after the version change.

1. Design the database, applying standards where they help and challenging them where they do not.
2. Build ETL processes.
3. Select tools and licences to fit your needs and budget.
4. Implementation using Business Intelligence and Oracle Data Integrator.

We build with APEX, PL/SQL, Forms, Reports and BI Publisher. For PHP, we know people who do it.

We bring DBA and development teams onto the same page. Practical expert workshops connect database mechanisms with the code and decisions that affect them.

We listen, challenge assumptions and work through the problem with your team. A technical brainstorming session, with someone who can help turn ideas into solutions.

• Review and optimise Oracle licensing.
• Analyse new licence purchases and current usage.
• Match licences and technical support to actual needs.
• Review licence holdings against purchase documentation.