Index: Date Index | Thread Index

[Date Prev] | [Date Next] | [Thread Prev] | [Thread Next]

[OAUGNet]-Re: URGENT! - Issue with Workflow Background process

Here is the cursor from my lock monitoring job
CURSOR get_locks
      IS
         SELECT    'Process  '
                || s1.action
                || '  running  '
                || s1.module
                || '  with SID  '
                || holding_session
                || '  is blocking Process  '
                || s2.action
                || '  running  '
                || s2.module
                || '  with SID  '
                || waiting_session
                || '.'
                || CHR (13)
                || CHR (10)
                || CHR (13)
                || CHR (10) mesg_line
           FROM v$session s1, dba_waiters w, v$session s2
WHERE s1.SID = w.holding_session AND s2.SID = w.waiting_session; 

Mike Charchuk
mailto:Mike.Charchuk@telus.net



On 28-Aug-08, at 5:43 AM, Benhur, Daniel wrote:



Mike,
We don't know what is happening during that time, that is what we are trying to find out and with a Sev1 P1 SR with On Demand for almost a month and doing everything what they are asking, still don't have a clue about the cause. The problem is, this is happening mostly during the last week of the month when our production is busy and lot of OM Transactions occur during this time.
Being an On Demand customer we are very limited to what we can do, when it started happening, we used to terminate the long running WBP request and call On Demand and have them kill the Session. But this is very time consuming, by the time we can get hold of someone to kill the session it may be too late and delay our invoicing.
Thanks for your suggestion regarding finding the blocking locks, do you have a script which we can use to get the blocking locks. I tried with some 
scripts from metalink, but didn't find anything to resolve our issue.

Any suggestions is greatly appreciated.

Benhur.

-----Original Message-----
From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of Mike Charchuk 
Sent: Wednesday, August 27, 2008 4:32 PM
To: OAUG Net listserver
Subject: [OAUGNet]-Re: URGENT! - Issue with Workflow Background process 

Is your workflow actually processing during the long runs or is it
waiting for a lock to be cleared.  We have had some OE forms users
blocking our OEOH and OEOL workflows on a regular basis.  I have a
blocking locks job that runs every 10 minutes or so to check for
blocking locks.  If an OE form is blocking the workflow we attempt to
contact the user to get out of the form and if we can't contact them we 
typically kill their forms session.  I also have a jobs that checks to
see if a workflow has been running for more than 5 minutes, which has
proven to be usefull.

Benhur, Daniel wrote:

Based on the completion of the prior run.

-----Original Message-----
From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of Burriack, Gillian 
Sent: Wednesday, August 27, 2008 3:59 PM
To: OAUG Net listserver
Subject: [OAUGNet]-Re: URGENT! - Issue with Workflow Background process
Did you schedule it to run based on the completion of the prior run or 
based on the start of the prior run?

-----Original Message-----
From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of
McRaney, Ronald
Sent: Wednesday, August 27, 2008 4:53 PM
To: OAUG Net listserver
Subject: [OAUGNet]-Re: URGENT! - Issue with Workflow Background process 

Daniel,
You might take a look at the http://blogs.oracle.com for some ideas. I 
found this article from Gaurav Verma interesting enough dealing with
some ONT customizations.  Look through it and might help,
http://blogs.oracle.com/gverma/2008/03/when_conventional_thinking_fai_1 . 
html

Good Luck,
Ron

-----Original Message-----
From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of Benhur, 
Daniel
Sent: Wednesday, August 27, 2008 1:28 PM
To: OAUG Net listserver
Subject: [OAUGNet]-URGENT! - Issue with Workflow Background process

Hello,

We are recently experiencing performance problem with Workflow
background process and its taking anywhere between 5 mins to more than 
an hour to complete. During this time the Auto invoice program is
getting stuck and delaying our Invoicing process. We have been going
back and forth with Oracle support on this and so far no solution to
this even with a Sev1 P1 SR.
This is specific to Order management and the workflow we are concerned 
is the OEOL(Order lines) and the parameters are deferred 'Yes', Time
out' No and Stuck "No'. We scheduled it to run every 2 mins(we scheduled 
it for every 5 mins as per development recommendation but no
difference).

Any suggestions or ideas regarding where to look and what might be
causing this. We haven't customized the standard OEOL workflow at all. 

Thanks,
Daniel Benhur
PAS Technologies
1234 North Kansas City, MO 64116
P: 816 556 5122
C: 816 804 2876
www.pas-technologies.com

#############################################################
This message is sent to you because you are subscribed to the mailing
list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com> To switch to the FEED 
mode, send any message to <OAUGNet-feed@oaug.com> To switch to the
DIGEST mode, E-mail to <OAUGNet-digest@oaug.com> To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com> Send administrative queries to 
<OAUGNet-request@oaug.com>


#############################################################
This message is sent to you because you are subscribed to the mailing
list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com> To switch to the FEED 
mode, send any message to <OAUGNet-feed@oaug.com> To switch to the
DIGEST mode, E-mail to <OAUGNet-digest@oaug.com> To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com> Send administrative queries to 
<OAUGNet-request@oaug.com>


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>. 
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com > 
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>. 
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com > 
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>






#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>. 
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet- feed@oaug.com> 
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>. 
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet- feed@oaug.com> 
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>




#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>
  • Prev by Date: [OAUGNet]-Re: URGENT! - Issue with Workflow Background process
  • Next by Date: [OAUGNet]-Re: AIA/SOA architecture while upgrading
  • Previous by thread: [OAUGNet]-Re: URGENT! - Issue with Workflow Background process
  • Next by thread: [OAUGNet]-AIA/SOA architecture while upgrading

    • Index: Date Index | Thread Index

    Thank you for using the OAUG Listserver Archive.