Concurrent requests hang

[Roshan]

Hello,

on our production environment, there are often 150-200 reports which run. Since yesterday the concurrent manager has hang completely and we have to restart the application and database.

The reports are standard reports



Thanks.
Roshan

reports.rar

[ErmanArslansOracleBlog]

Hi,

I see your screenshots.
The concurrent requests are running, so they are probably waiting in the database.
what are their session waits in the database?
Take one of them as a reference and check its current wait in the database?

[Roshan]

Hi,

thanks. There were some sessions blocking in the database when the concurrent manager hang. I killed the sessions still the requests are hanging.

Capture.PNG

Thanks,
Roshan

[ErmanArslansOracleBlog]

What are the db waits of the concurrents? The sessions of concurrents,  not the blocking sessions or other sessions

25 Nis 2016 08:44 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hi,

thanks. There were some sessions blocking in the database when the concurrent manager hang. I killed the sessions still the requests are hanging.

Capture.PNG

Thanks,
Roshan

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Concurrent-requests-hang-tp912p919.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Roshan]

How will I know the session of a specific concurrent request? I have queried the apps schema.
Capture.PNG
 

[ErmanArslansOracleBlog]

You can get the sid of a concurrent request using sql queries, such as ;

/*Finding SID of a Concurrent Request */

select b.sid, oracle_session_id, oracle_process_id, os_process_id
from fnd_concurrent_requests a ,
v$session b
 where a.request_id=&request_id and
        a.ORACLE_SESSION_ID = b.AUDSID
--------------------------------------------------------------------------

[Roshan]

For the request being run, I am getting no rows as output

[ErmanArslansOracleBlog]

Then they are running on applications server doing apps related stuff such as XML publisher or so. Check application server with ps command, they may be running/spinning on the CPU. Talk with functional Team and terminate them if applicable

25 Nis 2016 12:32 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

For the request being run, I am getting no rows as output

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Concurrent-requests-hang-tp912p923.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Roshan]

Hi,

I have increased the number of sessions and number of processes in pfile and restarted the database. I have also tuned OPP. The reports are not blocking now

[ErmanArslansOracleBlog]

Good news Roshan. So they dere actually waiting in the application tier , as i mentioned( as u said there are no dB sessions) .. See , they were waiting for OPP to process their outputs then ..

6 May 2016 19:52 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hi,

I have increased the number of sessions and number of processes in pfile and restarted the database. I have also tuned OPP. The reports are not blocking now

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Concurrent-requests-hang-tp912p962.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Roshan]

Hi,

what do you suggest me tune in the database apart from sessions, processes and transactions?(sessions:processes is currently 5000:10000, transactions:11000)
Do I need to increase it any further?

For the applications, do I need to tune OPP any further?

Thanks,
Roshan

[ErmanArslansOracleBlog]

you are asking a very general question. The answer is superlong.

For OPP I suggest you to read : http://ermanarslan.blogspot.com.tr/2014/12/ebs-output-post-processoropp.html

There is a 8 step action plan there.

Also this one: Tuning Output Post Processor (OPP) to Improve Performance (Doc ID 1399454.1)

As for general EBS 12.2 tuning, check this one:

EBS - Webcast Recording Best Practices E-Business Suite Performance Tuning [Audio] (Doc ID 1530509.1)

2016-05-23 19:28 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

Hi,

what do you suggest me tune in the database apart from sessions, processes and transactions?(sessions:processes is currently 5000:10000, transactions:11000)
Do I need to increase it any further?

For the applications, do I need to tune OPP any further?

Thanks,
Roshan

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Concurrent-requests-hang-tp912p1009.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

... [show rest of quote]

--

[Roshan]

Thanks :)