The Application DBA System Management


System management is a disciplined approach to managing Oracle systems. System management addresses the following key areas:

  1. Technical Architecture
  2. Configuration Management
  3. Operational Management
  4. Workload Management
  5. Performance Management

Technical Architecture

Technical architecture includes items such as platform choices, deployment tiers, and I/O subsystem design, but it really involves more than just hardware. A key input to creating a workable technical architecture is understanding the business needs and fitting the architecture to the business, not the other way around. The following is a list of some of the key issues to consider when designing a technical architecture:

bullet Define scope and objectives
bullet Prepare an architecture strategy
bullet Establish requirements
bullet Develop a conceptual model
bullet Conduct an architectural baseline
bullet Define system availability requirements
bullet Define any future application requirements
bullet Develop a reporting strategy
bullet Refine the conceptual architecture
bullet Define architecture subsystems
bullet Propose architecture subprojects
bullet Design application security architecture
bullet Design application functional architecture
bullet Design logical application and database architecture
bullet Design physical database architecture
bullet Design hardware and network architecture
bullet Develop system capacity plan
bullet Assess performance risks
bullet Design system management procedures

For more information on this topic see the AppsDBA paper "Sizing Oracle Applications Projects, A Technical Perspective".

Configuration Management

Configuration management encompasses the following topics:

bullet Installation
bullet Patching
bullet Environment layout and accessibility
bullet Physical database configuration
bullet Application schema design and configuration

Operational Management

Operational management includes:

bullet Environment setup
bullet Process startup and shutdown including the database, listener, OEM, and any other required processes.
bullet Error and informational log file scanning and management
bullet Database patching, and upgrade methodologies
bullet Security patching and assessments
bullet Backup and recovery
bullet Database space management

Workload Management

Workload management addresses the following areas:

bullet Workload measurement
bullet Workload characterization
bullet Capacity planning
bullet Workload reduction

Performance Management

Performance management includes the following areas:

bullet Response time optimization
bullet Resource allocations
bullet Resource access

AppsDBA Consulting offers the tools and expertise to help you in all of these key areas of system management. If you have any questions or need help, please contact us.

Copyright 1998-2013 AppsDBA Consulting. All Rights Reserved.