System management for Oracle DBAs  

home
about AppsDBA
consulting
system management
workload
db admin
publications
tech info
scripts
opensource
utilities
other links
 

AppsDBA.com System Management

Introduction

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

Technical Architecture

Configuration Management

Operational Management

Workload Management

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:

bulletDefine scope and objectives
bulletPrepare an architecture strategy
bulletEstablish requirements
bulletDevelop a conceptual model
bulletConduct an architectural baseline
bulletDefine system availability requirements
bulletDefine any future application requirements
bulletDevelop a reporting strategy
bulletRefine the conceptual architecture
bulletDefine architecture subsystems
bulletPropose architecture subprojects
bulletDesign application security architecture
bulletDesign application functional architecture
bulletDesign logical application and database architecture
bulletDesign physical database architecture
bulletDesign hardware and network architecture
bulletDevelop system capacity plan
bulletAssess performance risks
bulletDesign 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:

bulletInstallation
bulletPatching
bulletEnvironment layout and accessibility
bulletPhysical database configuration
bulletApplication schema design and configuration

Operational Management

Operational management includes:

bulletEnvironment setup
bulletProcess startup and shutdown including the database, listener, OEM, and any other required processes.
bulletError and informational log file scanning and management
bulletDatabase patching, and upgrade methodologies
bulletSecurity patching and assessments
bulletBackup and recovery
bulletDatabase space management

Workload Management

Workload management addresses the following areas:

bullet Workload measurement
bullet Workload characterization
bulletCapacity planning
bulletWorkload reduction

Performance Management

Performance management includes the following areas:

bulletResponse time optimization
bulletResource allocations
bulletResource 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-2008 AppsDBA Consulting. All Rights Reserved.