Performance Issues with SQL Queries

Posted by prabhunoule on Oct 30, 2023; 7:33am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Performance-Issues-with-SQL-Queries-tp12136.html

Dear Erman,

Whenever below SQL queries run, we observe performance issues. Any suggestions?

We are  on R12.2.5 and on 19c database.


[12:58 PM] SATISH GUDDHATI
SQL> select sql_text from gv$sqltext where sql_id='7b5w34atn8q1h' order by piece;
 
SQL_TEXT

----------------------------------------------------------------

BEGIN FND_CP_OPP_IPC.Get_Message(:1,:2,:3,:4,:5,:6,:7,:8); END;

BEGIN FND_CP_OPP_IPC.Get_Message(:1,:2,:3,:4,:5,:6,:7,:8); END;
 
SQL> select sql_text from gv$sqltext where sql_id='497wh6n7hu14f' order by piece;
 
SQL_TEXT

----------------------------------------------------------------

BEGIN FND_CP_GSM_IPC.Get_Message(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10)

BEGIN FND_CP_GSM_IPC.Get_Message(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10)

; END;

; END;

SQL> select distinct sql_id,count(*) from gv$session where status='ACTIVE' group by sql_id order by 2 desc;
 
SQL_ID          COUNT(*)

------------- ----------

497wh6n7hu14f          9

7b5w34atn8q1h          6





Thanks & Regards,
Prabhu