Database Health Check & Investigation includes:-
- Configuration of database initialisation parameters
- Configuration and location of database files and objects
- Memory utilisation (buffer cache, shared SQL pool, log buffer)
- User configuration
- Block size
- Backup and Recovery Policy
- Capacity Planning
- Oracle Parallel Query Management
- Advanced Replication
- Table Partitions
Performance Tuning:-
- Slow response / notable poor performance
- Standard/default installations
- Applications installed on standard Oracle configuration
- Oracle and Application not from same source
- I/O bottlenecks
- Object and free space fragmentation
- Investigate Inefficient SQL
- Identify tables without indexes or primary keys
- Rollback Segment Contention
Database Design including:-
- Highlight Oracle Architecture
- Skills transfer
- Highlight key features and drawbacks
- Cut down on initial tuning issues
- Where to locate files etc to avoid performance bottlenecks
- Highlight storage and file sizes to avoid performance issues
- Capacity Planning
High Availability & Resilience including:-
- Advanced Replication
- Standby Server - Standard and Enterprise Editions
- Highlight key features and drawbacks
Installation and Platform Migrations including:-
- Installations on all Standard & Enterprise Versions from 7.1x onwards
- Expert Installs – working hand in hand with your Solutions supplier
- Migrations Upgrades
|
Back Up and Recovery including:-
- Analyse Backup and Recovery Policy / Strategy
- Validate backups
- Highlight options available
- Import and Export – (why it is important to do this periodically)
- Disaster recovery
- RMAN – use of, highlighting teething troubles and some of the admin issues
- Hot backups – (Live backups or Archive log mode) strengths, weaknesses
- Disaster recovery
- Cold Backups – Key strengths, weaknesses, when to use and when not to
Senior DBA Services / Outsourced Managed Services including:-
- DB Assist Silver, Gold and Platinum DBA support packages
- Daily, Weekly and Monthly scheduled activities
- Verify all instances are running
- Check alert log file for errors
- Verify success of database backup
- Check for available resource for acceptable performance
- Check for objects that break rules / thresholds
- Check security policy violations
- Check alert log file for errors
- Check for excessive growth rates
- Review tuning opportunities
- Check for I/O contention
- Check for server performance issues
- Use our Senior DBA to ensure key monthly actions are covered
- Use our Senior DBA to handhold known or recurring problems
DBA Contracting / Outsourcing including:-
- Long Term cover
- Maternity cover
- Illness / unexpected leave of absence cover
- Migration
- Data conversions
- Testing
- Overcoming Recruitment issues
|
Telephone: 
