HomeSearchSite MapContact Us RemoteDBA Services for CODASYL DBMS and RdbPreserving Mission Critical IT Applications Through Virtualization

Remote Management of OpenVMS SystemsExtreme Performance Consulting


DBMS PERFORMANCE & TUNING
DATABASE
ADMINISTRATION

TRAINING -> DBMS COURSES -> DBMS PERFORMANCE & TUNING

Next Scheduled Class:                                                                Duration:  3 days 
Call for Scheduling                                                                     Cost: $3,000 US Dollars 

OVERVIEW
This course introduces participants to a series of tuning steps, which can be used to improve the performance of the Oracle CODASYL server. The focus is on database rather than specific operating system performance issues. Participants will gain practical hands-on experience tuning a production-scale Oracle CODASYL database. In the process, participants learn how to recognize, troubleshoot and resolve common performance related problems and improve performance and concurrency issues including problem diagnosis and performance enhancements. 

AT COURSE COMPLETION
Students will be able to:
  • Identify key parameters affecting database performance
  • Interpret DBO/ANALYZE output
  • Interpret DBO/DUMP output
  • Interpret DBO/SHOW STATISTICS output
  • Interpret VMS MONITOR output as relates to database performance
  • Monitor database for performance problems
  • Identify and resolve database performance bottlenecks
  • Recommend and implement changes to the schema/storage schema to optimize database performance
  • Recommend and implement changes to the database environment to optimize database performance
  • Use the online restructure utility to restructure database with minimal downtime
  • Use the DBO/UNLOAD and DBO/LOAD facility to reload portions of their database should it be necessary
  • Use the DBO/UNLOAD facility to extract data from the database

PREREQUISITES
Students attending this course should have completed the Oracle CODASYL DBMS database administration course prior to taking this course.

TARGET AUDIENCE
This course is intended for those individuals responsible for the administration of Oracle CODASYL DBMS databases including System Administrators, Network Administrators, Database Administrators and Technical Support Professionals. This topic area focuses on issues that affect database performance and what can be done to optimize the performance of Oracle CODASYL DBMS applications.

COURSE OUTLINE
  • Database Design, effects of schema, storage schema, and sub-schema designs on database performance
  • Database Implementation
  • Database Monitoring and Tuning
  • Unload and Load facility
  • Database file placement
  • Utilizing database buffering
  • Understanding DBO/CREATE parameters
  • Understanding DBO/MODIFY parameters
  • Understanding DBO/SHOW STATISTICS
  • Implementing user-written performance monitor utilities
  • SYSUAF parameters
  • Database lock contention and resolution
  • Currency Indicators
  • Online Restructure utility
  • Understanding DBO/ANALYZE reports
  • Understanding DBO/DUMP reports

Register Today!

REQUEST 

INFORMATION

 

Copyright 2016 Software Concepts International
All Rights Reserved