search cancel

Oracle Database Requirements

book

Article ID: 89514

calendar_today

Updated On:

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)