You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future?()
- Aguarantee undo retention
- Badd one more redo log group
- Csize the redo log files appropriately
- Dsize the UNDO tablespace appropriately
- Esize the SYSTEM tablespace appropriately
- Fconfigure an appropriate undo retention interval
- Gchange automatic undo management to manual