Re: performance issues

Posted by raiq1 on Nov 01, 2023; 7:56am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/performance-issues-tp12142p12149.html

Dear Erman sir,

Thanks for your suggestion , few queries are running base on concurrent report are frequently basis since long time. I check with my developer as per your suggestion and recommendation , he said most of the concurrent program are running since years, he put all the things on my shoulder that you did database upgrade from 11g to 19c , you check your system not a coding issue.


I don't know how to fix it .

Morever if you see the awr report they is below .

Segments by Physical Reads

 MTL_MATERIAL_TRANSACTIONS are 64 gb SIZE, can we rebuild the index for this table. Most of the concurrent program are using this table.

Kindly advice.

Regards,
Raiq.