Re: row cache lock

Posted by Roshan on Jan 04, 2022; 4:13am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/row-cache-lock-tp10531p10554.html

Hello Erman,

happy new year.

I generated the trace file again and saw 'direct path write temp' wait event. I generated AWR report (1576956.1) and saw I/O was not an issue. Maybe I need to increase PGA?

pga_aggregate_limit  big integer 9000M
pga_aggregate_target big integer 3726M

dware11_ora_10928_TICKETJAN2.prf
awrrpt_1_20263_20264.html

Thanks,

Roshan