# Historian trends with oracle

**URL:** <https://forum.inductiveautomation.com/t/historian-trends-with-oracle/15897>\
**Category:** Ignition\
**Created:** [November 6, 2017, 5:23pm UTC](https://forum.inductiveautomation.com/t/historian-trends-with-oracle/15897 "2017-11-06T17:23:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![apimente](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/apimente/32/4030_2.png) [@apimente](https://forum.inductiveautomation.com/u/apimente)\
**Post date:** [November 6, 2017, 5:23pm UTC](https://forum.inductiveautomation.com/t/historian-trends-with-oracle/15897/1 "2017-11-06T17:23:22Z")

</div>

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,

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [November 6, 2017, 7:54pm UTC](https://forum.inductiveautomation.com/t/historian-trends-with-oracle/15897/2 "2017-11-06T19:54:03Z")

</div>

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