Hi,
We are doing performance test on our new schema and during the test we see that this LGWR database process is always the highest resource taking process during the test.
I see that the Commit activity appears continiously on Grid Controller toghegher with System I/O.
I checked the Redo Logs and we have them in 5 groups each 200MB.
Any idea about what causes this? I guess the application is doing one commit after each statement, or?
Any comment about how can we improve this?
I wanted to attach the screenshot from the Grid Controller but it seems we can't do that on this Forum!
Thanks in advance for the help!
/ Hes