We face following timesten issues in our production env
1)Three Insert Transactions did not get committed since ORACLE CODE = -2356 - ORA-02356: TT0802: Database temporary space exhausted was faced.
2)Timesten server cores were also generated around this time.
Present TempSize = 250 MB.
Please advise, what can be set at TT/DB level to avoid committed transactions from getting dropped.
Diagnosing and making recommendations regarding production systems and outages is really not what this forum is for. These issues need detailed technical diagnosis and then recommendations can be made accordingly. Please log an SR with Oracle Support so that we can assist you.
Superficially it looks like you ran out of space in 'Temp' so increasing TempSize value (requires database to be unloaded from memory and re-loaded to take effect) *might* solve the problem. But ideally proper diagnosis via an SR is the best plan here.