stop redo generation for GTT
Hi
The application is using GTT with very heavy concurrent inserts . Since , GTT is in use , redo generation should be minimal , but here we have very heavy redo generation . Upon investigation , it is found that redo generation is because of lot of undo generation due to heavy inserts .
Is there any way we can avoid undo generation . I know all the reasons for undo generation (ACID , recovery n all) , but is there any way we can tell Oracle that we don't want transaction recovery (in case it fails) hence , pls do not generate undo . ?
Regards
Nakul
The application is using GTT with very heavy concurrent inserts . Since , GTT is in use , redo generation should be minimal , but here we have very heavy redo generation . Upon investigation , it is found that redo generation is because of lot of undo generation due to heavy inserts .
Is there any way we can avoid undo generation . I know all the reasons for undo generation (ACID , recovery n all) , but is there any way we can tell Oracle that we don't want transaction recovery (in case it fails) hence , pls do not generate undo . ?
Regards
Nakul
0