Re: Performance Issues with SQL Queries

Posted by ErmanArslansOracleBlog on Oct 30, 2023; 8:08am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Performance-Issues-with-SQL-Queries-tp12136p12137.html

Those may not be the cause of your performance degradation.. Seeing them in ACTIVE state is normal.

Please see -> What Causes The Following Messages: Begin Fnd_cp_gsm_ipc.Get_message(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); End; (Note:868935.1)

Please do a performance analysis on your system and ensure the cause of the decrease in performance.. If that fnd_cp_gsm calls are the real causes, only then we should investigate this further.