Oracle Database Requirements

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Oracle Database Requirements

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

This article summarizes the database requirements for Automic Predictive Analytics and an Oracle Installation.

Admin DB

• CPU and Memory: adequate, component is not runtime critical
• Expected disk usage: < 1 GB
• Transaction volume: Only during changes of an EventBase model
• Encoding: refer to the Oracle DB Guide
• Oracle Options: none
  

EventBase DB

• CPU and Memory: adequate, depends on the expected volume (event count). Recommended: > 16 GB and Quad-Core
• Expected disk usage: 800 MB for 100000 jobs and 100000 Automic messages, i.e. around 4 KB per event
• Transaction volume: around 6-8 transactions per event for the default OM Event Base
  
• Encoding: refer to the Oracle DB Guide
• Oracle Options: Oracle Text if fulltext indexing should be enabled for Predictive Analytics (optional)