Skip to Main Content

Japanese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

oracle11g 11.2.0.3(64bit) +OracleClient 11.2.0.3(32bit)のDB接続が遅い

890990Mar 12 2012 — edited Mar 14 2012
以下の環境においてDB接続が遅い現象が出ております。

・環境
OS:Windows Server 2008 R2(64bit)
Oracle DB:Oracle11g(11.2.0.3 64bit)
OracleClient:Oracle Client11g(11.2.0.3 32bit)

・現象
ユーザアプリ(.NETで作成した32bitコンパイルアプリ)は起動後最初に Oracle11g(11.2.0.3)に接続をします。
この時、DB接続が一瞬で接続されたり、20秒ほどかかったりと早かったり遅かったりします。
しかもこの現象の発生頻度に規則性はありません。

接続文字列は「ホスト名/SID;User ID=ユーザ名;Password=パスワード;Pooling=False;Persist Security Info=True;」です。

また、上記の環境を以下の環境に変えると接続は安定して早いことが分かっています。

OS:Windows Server 2008 R2(64bit)
Oracle DB:Oracle11g(11.2.0.3 64bit)
OracleClient:Oracle Client10g(10.1.0.2.0 32bit)

DBは Oracle11g ですが、Oracle Client が 11g だと遅く 10g だと早いという現象です。


どなたか同じような現象を経験された方がいらっしゃいましたらご教示をお願い致します。

Comments

Arik
Lars,

First of all you can use a Throw activity and put the value "replay" in the local part and "http://schemas.oracle.com/bpel/extension" in the namespace.
This will automatically bring you back to the begining of the scope (you must put it inside a scope).
Beside, you can use a human task and build a form with the file's record. This will allow you to fix the data you want and return it back to your process.

Riko
346356
Hi

Thanks for the reply. I triied this, but then thie instance gets stuck in an infinite loop, replaying the scope over and over, until someone fixes the problem with the DVM/XREF or whatever the real problem was. Am I missing something? Is there a way to pause execution of the replay scope?

Regards

Lars
Arik
Maybe I didn't understand you or the opposite :)
I will describe the flow:

1. create a scope
2. put inside first your wishful transaction (invoke for example)
3. catch a logical or system fault
4. send the data into Human Task (after creating a form as well). That will allow the user to change the data or approve or what ever
The correct data will then get back to your flow. Assign it to your invoke.
5. Use the Throw activity with replay option
That will call the transaction, only this time with the correct data

This is what you are doing? If so please explain the problem because I might not understood it

Riko
346356
Hi Riko

Actually I was looking for a way to solve the problem without involving Workflow and Human Tasks. I thought maybe you were referring to some kind of undocumented feature when you suggested to throw a Fault with local name 'replay', so when I tried, I never had any Human Task.

Although your solution would surely work, unfortunately I can't introduce Workflow to the customer at this point. We have hundreds of composites being developed under a tight schedule and I'm looking for a cheap and quick generic solution for this type of problems.

Anyway, thanks for your input!

Regards

Lars
Arik
I developed an EDI system with the option of correcting data via Human Task. Nice solution

Another option you can try is sending mail with attachmnet (your file), wait for a reply back with the correct file.
But I guess you have no time for developing this.

If anything will raise in my mine I will get back to you
DavidGaskell
Hi,

I don't know of an expiclit way of achieving this directly from within a BPEL Fault handler (e.g. Java API Calls). However an approach i have used is to be a little creative with the use of additional components. You could either place the xForm in a spearate component. Thay way be invoking from the parent component the invoke will receive the fault. Hence your fault framework and fault policies can configure the appropraite actions beacuse the fault occurs on an invoke. Another approach is if you did not want to move the transform is to call a spearate component that just throws a fault. This would have a similar approach as the invoke would receive the fault.

Regards Dave
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 11 2012
Added on Mar 12 2012
12 comments
18,378 views