Oracle Database Requirements

Document ID : KB000089514
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Oracle Database Requirements
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)