Re: Batch performance

Posted by ErmanArslansOracleBlog on Jan 27, 2024; 6:16pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Batch-performance-tp12269p12271.html

I took a quick look, and I can say that you have lots of log file sync waits, and they take time..
You have also db link waits, and for that we can't do anything actually.
You have some heavy SQL workloads. These SQLs can not even complete their run in this AWR period. So you need to check them.. (check if they are necessary to be executed -- See AWR SQL Statistics section for this..)

Send me an AWR report while that problematic batch is running. (Note that; there should be a maximum of 1 hour between the AWR snapshots you use when creating the AWR report. Because, as you increase the time period for the AWR reports, it becomes harder to detect problems because the scale expands.)

Also send me a part of query (first part maybe) of the problematic batch.. (it should be there in AWR with all the wait metrics associated with it..)