Home Consulting Publications MERITS
                          Profiler RmanJ

Consulting Services

ORADBPRO Consulting Services is focused on ORACLE DBMS performance, high availability, database security, backup/recovery and training. Assignments are accepted worldwide. The skill set aquired over the course of thirteen years of working with the ORACLE DBMS includes the following products, features and options:

  • Performance engineering, diagnosis and tuning using extended SQL trace, wait event tuning methodology, Statspack, Active Workload Repository, TKPROF, TRCSESS, instrumentation, DBMS_MONITOR, DBMS_XPLAN, ORADEBUG and the extended SQL trace profiler esqltrcprof
  • Partitioning option
  • Parallel execution
  • ORACLE DBMS in storage area network (SAN) and network attached storage (NAS) environments
  • Real Application Clusters & Oracle Clusterware
  • Automatic Storage Management, Linux ASMLib
  • Physical & logical standby databases, Data Guard and Data Guard Broker
  • Oracle Failsafe on Microsoft Cluster Server
  • Recovery Manager (integration with: TIvoli Data Protection and Tivoli Storage Manager; NetBackup; OmniBack), block change tracking
  • Conventional & Data Pump Export/Import
  • Advanced PL/SQL programming
  • Advanced Queuing
  • National Language Support (Unicode)
  • Transportable tablespaces and databases (including cross-platform)
  • Transparent Data Encryption
  • Database Vault
  • Online reorganization
  • Oracle Text full text search
  • Database Scheduler
  • Resource Manager
  • SQL*Loader
  • External tables
  • Streams
  • Auditing
  • Perl DBI and DBD::Oracle
  • Oracle Universal Installer silent install
  • Upgrade, downgrade, migration
  • Enterprise Manager Grid Control & Database Control
  • Oracle Net, Transparent Application Failover (TAF), cluster database services, server-side TAF, connection load balancing
  • UNIX variants Solaris, AIX, HP-UX, Tru64 UNIX & Linux
  • UNIX shell scripting
  • UNIX utilities awk, sed, cut, bc, dc, (e)grep, find, pmap, truss, tusc, strace, nmon, top, prstat, vmstat, iostat, xargs, etc.
  • TOAD, SQL Navigator, SQL Developer
  • Trainings on performance tuning, Advanced Queuing, Streams, Perl DBI and DBD::Oracle
  • Technical writing & desktop publishing (Microsoft Office, OpenOffice, Adobe FrameMaker, Adobe Acrobat Distiller, Visio, Photoshop)