OLTP table structure

Hi Tom, our customer has a biggest fact table about 30 Mio rows, 230 columns, 99 indexes and 68 foreign keys on it. Pure OLTP environment. DB performance is not very good. AWRRPT shows sometimes until 4 seconds per insert. Enqueue Type sectio...

Read More...

---