tag:blogger.com,1999:blog-5874979429188093780.post7755042073005694219..comments2024-03-18T06:46:54.352+01:00Comments on Andrej Baranovskij Blog: Experimenting with ADF BC Application Module Pool TuningAndrej Baranovskijhttp://www.blogger.com/profile/04468230464412457426noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5874979429188093780.post-56735164261006382422011-12-06T08:35:29.768+01:002011-12-06T08:35:29.768+01:00Hellow Andrejus,
I want to know the best practice ...Hellow Andrejus,<br />I want to know the best practice for Application module <br />Is it better to use one application module for my application or multiple application modules and if I will use more than one AM <br />what is the better to use nested app module or separated app module. <br />and what is the optimal number of views that I put in the app module <br /><br />as I have a large application that serves about 350 user and this application consist of one application module and the passivation problem happens a lot.<br /><br />I know this is a lot of question but I really need help in this.M.Ahmedhttps://www.blogger.com/profile/15043782899500902863noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-39935979102176290372011-10-31T10:44:41.696+01:002011-10-31T10:44:41.696+01:00Hi Chris,
Is hard to say, if this explains why Or...Hi Chris,<br /><br />Is hard to say, if this explains why Oracle recommends to use optimistic locking. I guess - no. Most probably, this is just some issue related to AM pools.<br /><br />I have checked how many AM pools are created in 11g R1. There are 3 AM's in the system, so it created 3 AM pools (I uploaded screenshots as well, end of post). Each AM pool contains active AM instances. All TF's are accessed directly, there is no nested TF call for sample app.<br /><br />I can't test right now for 11g R2, how many AM pools are created - I will need to install FMW control on standalone WLS server for 11g R2. But I will keep you posted.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-48721992983153984242011-10-31T01:42:23.297+01:002011-10-31T01:42:23.297+01:00Hi Andrejus
Certainly I understand the technical...Hi Andrejus<br /><br />Certainly I understand the technical need for "better-than" optimistic locking, was just wondering if what you posted provides the key why Oracle recommend us to use optimistic locking.<br /><br />As for AM pools, how many are there? From my understanding 11.1.2.X should create 3, but I wonder if you're seeing less?<br /><br />Regards,<br /><br />CM.Chris Muirhttps://www.blogger.com/profile/06566648350240654621noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-38067230063641765752011-10-30T23:23:23.087+01:002011-10-30T23:23:23.087+01:00Hi Chris,
- Optimistic lock is not suitable in su...Hi Chris,<br /><br />- Optimistic lock is not suitable in such case, when we need to run long running transactions (lets say keep lock for specific user for 0.5 hour). Often even pessimistic locking is not enough, we need to set lock programmatically when user is accessing record (for example banking application, when records should be locked and no change allowed until transaction not completed)<br /><br />- Generally, yes - correct, its why Oracle recommends Optimistic. We did several tests, with Pessimistic locking, in stress test environment - lock sometimes can be lost during a bit longer wait time.<br /><br />- I have tested with both 11g R1 and 11g R2, same results. Regarding number of AM pools I will double check and will post my findings here.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-89110044885145096992011-10-30T22:35:36.723+01:002011-10-30T22:35:36.723+01:00Hi Andrejus
Sorry for the double post, pecking on...Hi Andrejus<br /><br />Sorry for the double post, pecking on my iPad.<br /><br />However in considering the post, can you elaborate the number of AM pools via DMS Spy or FMW Control please? Why I ask is I think you're seeing a 11.1.1.X.0 behavior for AMs not a 11.1.2.X.0 behavior which is curious. But the number of AM pools will indicate what's going on. You'll need to check the number of AM pools in both scenarios.<br /><br />Regards,<br /><br />CM.Chris Muirhttps://www.blogger.com/profile/06566648350240654621noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-75777867650049205042011-10-30T22:15:46.828+01:002011-10-30T22:15:46.828+01:00Hi Andrejus
Regards the database lock being lost,...Hi Andrejus<br /><br />Regards the database lock being lost, do you think this is why Oracle recommends we use optimistic locking? Obviously with optimistic locking the lock is delayed till commit time & processed within 1 request, such that passivation isn't an issue.<br /><br />CM.Chris Muirhttps://www.blogger.com/profile/06566648350240654621noreply@blogger.com