IM Oracle Database Tables
I am trying to find a method or formula to calculate the size of Oracle Database when Installing IM. Do you know how can I be sure that my table size will be big enough to assure the proper operation? Thank you very much in advance.
Voted best answer
The installation of an IM will take you through the database instance wizard!
Answer carefully and the wizard will correctly size your DB.
Its also possible to extend tablespaces after DB creation in case something got too small.
Regular trends are not stored in Oracle (only their config which should be so small that you don't need to size Oracle to fit the configuration).
OPC AE and PDL (Batch) message logs are usually what's consuming space in Oracle - be sure to answer those queries honestly when the wizard asks.
IM support problem #1, all categories is: OPC message or PDL log has depleted all available space and auto extend is OFF or not properly setup.