Alert Handler and _add_value (sizes)

[NikolayLevchenko]

Hi,

I would like to use _add_value_x configs in my alerts handlers to store some values with alarm instances. We use Oracle as our archiving engine and it is my understanding that these _add_value_x will be stored together with the alert instances in Oracle, right?

If so, then my question is, how many bits/bytes each one will use? Help shows them as "anytype". What does this mean in this particular case?

If I store TRUE/FALSE in _add_value_1, will this add 1 bit to my alert record in Oracle?
What if I store 0/1/2/3? One byte? Or one word?
What if I store text like "Comment 1"? Some preset size? Or characters multiplied by 1 byte?

Basically, I want to store some values with every alert record but I want to avoid overloading the database.

[Gertjan van Schijndel]

The RDB manager stores the values of dyn-variables in another table, where each value is a separate record.
Since '_add_values' is a dyn_anytype I assume this also applies in this case, so each add value will be an extra record.

[NikolayLevchenko]

Ok, I understand. Any idea what is the size in bytes of this record? And does it depend on the type of data I place in _add_value (BOOL, INT, string)?

[leoknipp]

If you want to get the size of records in the Oracle database you can write them and check afterwards with Oracle commands how much space is needed.
The result will be more accurate if more records are written.

Please get in contact with your Oracle consultant to get more detailed information for the Oracle commands.

Best Regards
Leopold Knipp
Senior Support Specialist