Historian trends with oracle

Ignition
1

Hi friends,

With ignition 7.2.11 we’re having some problems with trends. The realtime works fine but the history with more than 3 days collapse and goes red. Maybe we can tune up the database but We’d like to know if someone have experience with this and maybe have tips to handle it.

Trends are stored in Oracle 10g.

Thanks in advance. Greetings,

2

That kind of behavior almost always means you are missing indices. On the t_stamp column, at least.