Login  Register

Requests

classic Classic list List threaded Threaded
4 messages Options Options
Embed post
Permalink
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Requests

Latifa
21 posts

Hi Erman,

Problems don't finish ...

How can we analyse what's happening for running requests running taking long time creating locks and still running from friday (end of the month for the customer --> closure) ? How can we stop them in order to analyse them or the locks created ?

During those batch requests I was also doing installations which took very long time (which take 5, 10 and 15 min).

Regards,

Latifa
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: Requests

ErmanArslansOracleBlog
Administrator
5738 posts
Hi,

You can enable trace for the concurrent program.
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: Requests

Latifa
21 posts
Hi Erman,

thank you for your reply.
We suppressed all locks in the DB . cmclean for GTS and restart all (DBTier and AppsTiers).

Regards,
Latifa
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: Requests

ErmanArslansOracleBlog
Administrator
5738 posts
Good.