Home >> Services >> Detailed Task List

Detailed Task List

Our services are divided up into three different categories breaking them into Database Monitoring, Administration and Support tasks. They are further sub-categorized into activities that apply to the Database verses E-Business suite. Please scroll down for detailed task list under each category.




Database Maintenance Tasks
Database Monitoring Oracle ERP Database
     Database Availability
     Database UP/Down
     Listener UP/Down
     
     DB Storage Management    
           Tablespace Free Space Management
           Extents Management
           Temp Tablespace Management
           UNDO Management
     
     File System Storage Management    
          Archive Log File Destination
          Flashback Recovery Area File Destination
          Other Data Mount Points
     
     DB Objects Management    
          Unused Indexes
          Objects Fragmentation
          Invalid Objects
     
     Database Backup Jobs Monitoring
     
     Proactive Database Monitoring    
          Alert Log Errors
          Blocking Session Locks
          Long Running Programs
          Scheduled Job Failure detection & repair
          Sessions Thresholds
          Processes Thresholds
          Open Cursors Thresholds
     
E-Business Monitoring Oracle ERP Database
     Applications Availability    
          Concurrent Managers  
          WF Mailer  
          Forms Server  
          Reports Server  
          APPS Listener  
     
     Proactive Applications Monitoring    
          Long Running Concurrent Programs  
          Concurrent Programs in pending status  
          Scheduled Concurrent Programs similar to  
          Workflow Background Process  
          Cost Manager  
          WIP Move Transaction Manager  
          Process transaction interface  
  back to top

Database Administration Tasks
Database Administration Oracle ERP Database
     Maintenance List    
     Re-Org Tables
     Rebuild Indexes
     Stats Collection
     Schema Objects
     
     Performance Management    
          Tuning Application Code
          SQL Tuning
     
     User Management    
          Schema Management
          User, Roles & Profiles Management
     
     Backup & Recovery    
     DB Recovery
     DB Object Recovery
     
     DB Issue Management    
          Patch Management
          SR’s/TAR Management
     
     DB/Apps Cloning & Refreshes
     
E-Business Administration Oracle ERP Database
     Application Issue Management    
          Patch Management  
          SR’s/TAR Management  
     
     Performance Management    
          Tuning Application Code  
          SQL Tuning  
     
     User Management    
          Create & Maintain Users & Responsibilities  
          Workflow Monitoring  
          Applying Critical Patch Updates
  back to top

Database Support Tasks

 Oracle ERP Database
     Database Upgrade
     Oracle ERP Applications Upgrade  
     Database/Application Cloning
     Code Migrations
     Deploy any Custom Applications
     Develop and Implement Database/Application      Backup Procedures
     Develop and Implement Custom code Development      Procedures and Standards
     Install and Maintain any 3rd Party Applications
     
     Support Projects involving DBA’s    
          OATM  
          DMZ Server Setup  
          SSO Implementation  
          SSL Implementation  
          Shared APPL_TOP  
          UTF-8 Conversion
 
  back to top
 


sitemap | contact us
DBAffinity LLC. 545 Metro Place South Suite 100, Dublin OH 43017