tag:blogger.com,1999:blog-5874979429188093780.post4066868087372843646..comments2024-03-18T06:46:54.352+01:00Comments on Andrej Baranovskij Blog: ADF BC Tuning with Do Connection Pooling and TXN Disconnect LevelAndrej Baranovskijhttp://www.blogger.com/profile/04468230464412457426noreply@blogger.comBlogger29125tag:blogger.com,1999:blog-5874979429188093780.post-28978337554065785122016-11-05T19:46:49.391+01:002016-11-05T19:46:49.391+01:00Hi,
Settings from root AM will be applied to all ...Hi,<br /><br />Settings from root AM will be applied to all child AMs.<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-75882204588486292192016-11-05T17:54:38.885+01:002016-11-05T17:54:38.885+01:00Hi Andrejus,
What happens when there are nested A...Hi Andrejus,<br /><br />What happens when there are nested AMs with different configuration sets as you described? Which AMs settings are honoured? Will the root AM override child AMs' settings?<br /><br />Thanks<br />Rahul Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-6516721392330032152015-08-01T09:51:15.801+02:002015-08-01T09:51:15.801+02:00Yes, but it doesn't have effect if you don'...Yes, but it doesn't have effect if you don't set jbo.doconnectionpooling = true<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-13215706693861114352015-08-01T09:47:01.291+02:002015-08-01T09:47:01.291+02:00Hi Andrejus,
I use jdev 11.1.1.7.
in this version...Hi Andrejus,<br />I use jdev 11.1.1.7. <br />in this version the default value of jbo.txn.disconnect_level is 1<br />Habibhttps://www.blogger.com/profile/15212731529698439555noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-16769343076305697012014-08-02T23:49:16.323+02:002014-08-02T23:49:16.323+02:00Hi Andrejus,
Thanks for confirming. I will let you...Hi Andrejus,<br />Thanks for confirming. I will let you know after testing tomorrow.<br /><br />thanks<br />animeshanimeshhttps://www.blogger.com/profile/09948823342242713278noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-71763690292321758362014-08-02T22:53:08.996+02:002014-08-02T22:53:08.996+02:00Yes, this should be sufficient - it still doesnt w...Yes, this should be sufficient - it still doesnt work?<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-5200064114678082032014-08-02T22:12:28.438+02:002014-08-02T22:12:28.438+02:00Hi Andrejus,
I have no done all the below changes...Hi Andrejus,<br /><br />I have no done all the below changes<br /><br />jbo.doconnectionpooling = true<br />jbo.txn.disconnect_level = 1<br />jbo.dofailover=true (enable cluster support).<br />So all the options under configurations under pooling and scalability are checked now.<br /><br />And regarding transient VO. I have checked the "include all transient attributes" under passivate state of VO.<br /><br />So, are these changes sufficient for the clustered environment testing.<br /><br />Note: All the transient attributes which only used for showing data in pivot table. So now on the VOs I have marked passivate state under VO tuning. Also checked include all transient attributes.<br /><br />Thanks,<br />Animeshanimeshhttps://www.blogger.com/profile/09948823342242713278noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-27018167940464117872014-08-02T10:29:22.354+02:002014-08-02T10:29:22.354+02:00Hi,
You should enable failover and implement pass...Hi,<br /><br />You should enable failover and implement passivation/activation support for transient VO's.<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-84952236715462095642014-08-01T12:04:31.994+02:002014-08-01T12:04:31.994+02:00Hi Andrejus,
We have a AppModule which consits of...Hi Andrejus,<br /><br />We have a AppModule which consits of 3 VOs. All VOs are static/rows populated programmatically.<br /><br />And tall the VO's consists of transient attributes.<br /><br />So everything works fine in Development environment. However it does not works properly in a clustured envirnment.<br /><br />Can you please point out what changes I need to do. <br /><br />Thanks in advance.<br /><br />Royanimeshhttps://www.blogger.com/profile/09948823342242713278noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-52126109722970274382014-04-07T13:19:07.715+02:002014-04-07T13:19:07.715+02:00You can simulate using JMeter.
AndrejusYou can simulate using JMeter.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-81386836572472139122014-04-07T13:10:48.077+02:002014-04-07T13:10:48.077+02:00Hi Andrejus,
Say if we have 600 concurrent users ...Hi Andrejus,<br /><br />Say if we have 600 concurrent users are accessing my application, how should we define the parameters for connection pooling ?<br /><br />Also, how to simulate this scenario to test, during the development time?<br /><br />Thanks in advance,<br />Regards,<br />SureshAnonymoushttps://www.blogger.com/profile/12148127906248478070noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-85736154460212245172014-03-31T08:58:58.430+02:002014-03-31T08:58:58.430+02:00Then you will start loosing data, when there are m...Then you will start loosing data, when there are more concurrent users. This is bad :)<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-80528077221883586792014-03-31T08:28:51.682+02:002014-03-31T08:28:51.682+02:00Hi Andrejus,
What if we set the issupportspassiva...Hi Andrejus,<br /><br />What if we set the issupportspassivayion=false?<br />Đặng Việt Hàhttps://www.blogger.com/profile/17479268997831855317noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-50116353900477397592012-10-15T12:57:00.425+02:002012-10-15T12:57:00.425+02:00Hi,
Probably this post will help you: http://andr...Hi,<br /><br />Probably this post will help you: http://andrejusb.blogspot.com/2012/08/sample-application-for-switching.html<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-70561548917829488972012-10-15T12:55:25.118+02:002012-10-15T12:55:25.118+02:00Hi Andrejus,
Can we connect to two connection in o...Hi Andrejus,<br />Can we connect to two connection in one application. For eg. I login to one application and then moving to one of the jsf page, can we have a button "Another Conn" which will connect to another db.<br /><br />Can this be achieved in ADF 11g.<br /><br />Waiting for your quick response.ADF New Learnerhttps://www.blogger.com/profile/04262122377419871678noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-80892258932256780712011-11-07T21:01:34.245+01:002011-11-07T21:01:34.245+01:00Hi,
You might be interested to tune Idle Instance...Hi,<br /><br />You might be interested to tune Idle Instance Timeout and Pool Pooling Interval instead - http://andrejusb.blogspot.com/2011/11/stress-testing-oracle-adf-bc.html<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-67241886011172829862011-11-07T20:04:18.276+01:002011-11-07T20:04:18.276+01:00Andrejus I have been testing these settings to fre...Andrejus I have been testing these settings to free up db connections. what i am seeing is with the ordDocDomain attribut for file uploads that the metadata seems to be persisted but the actual file is not uploaded.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-68432903870658888822011-11-03T07:49:27.805+01:002011-11-03T07:49:27.805+01:00It will take both DS1 and DS2. View Objects are no...It will take both DS1 and DS2. View Objects are not taking data source, but Application Module. If two Application Modules are defined with DS1 and DS2, those two data source will be used on runtime.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-21155805057463541832011-11-03T07:47:09.134+01:002011-11-03T07:47:09.134+01:00Hi Andrejus,
Thank you for your reply.
If we use...Hi Andrejus,<br /><br />Thank you for your reply.<br /><br />If we use model through ADF library, which DATASOURCE will it take.<br /><br />Say I have a application with DS1 and I import another application which has a model project of its own with DS2. Which datasource will the view objects form the library take in the runtime. <br /><br />Regards,<br />Oceanvijaioceanshttps://www.blogger.com/profile/16969450626268513871noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-8950672159851260112011-10-20T15:06:24.163+02:002011-10-20T15:06:24.163+02:00Use ADF Libraries and include Task Flows through A...Use ADF Libraries and include Task Flows through ADF Regions.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-19863769233550366872011-10-20T06:31:56.965+02:002011-10-20T06:31:56.965+02:00Hi Andrejus,
Thank you for your reply.
In our ap...Hi Andrejus,<br /><br />Thank you for your reply.<br /><br />In our application we use INLINE FRAME predominantly for calling the jspx from one viewController to another viewController. <br /><br />So could you suggest an alternative for the INLINE FRAME so many AM instances are not created for the single user session.<br /><br />Thanks,<br />Oceanvijaioceanshttps://www.blogger.com/profile/16969450626268513871noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-17204011123794037662011-10-19T21:43:39.528+02:002011-10-19T21:43:39.528+02:00Hi,
Yes, I reproduced your behavior. As I said ea...Hi,<br /><br />Yes, I reproduced your behavior. As I said earlier, this happens because of Inline Frame. Its very bad practice to use Inline Frames, when browser refresh happens it loads new session for Inline Frame. Its why new AM instance is created.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-29468478708144702382011-10-19T11:15:00.565+02:002011-10-19T11:15:00.565+02:00Hi Andrew,
I have mailed you the sample, It is ac...Hi Andrew,<br /><br />I have mailed you the sample, It is actually your sample with little bit modifications.<br /><br />Regards,<br />Oceanvijaioceanshttps://www.blogger.com/profile/16969450626268513871noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-57713785439884819922011-10-19T09:14:58.191+02:002011-10-19T09:14:58.191+02:00Hard to answer correctly, without seeing sample co...Hard to answer correctly, without seeing sample code. You can send it to my email, I will look.<br /><br />Generally using INLINE FRAME is bad practice.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-43908989557294033772011-10-19T07:07:44.362+02:002011-10-19T07:07:44.362+02:00Hi Andrejus,
Thanks for the great tip, up there. ...Hi Andrejus,<br /><br />Thanks for the great tip, up there. I noticed a rather strange behavior which I would like to share with you. <br /><br />Say we have a application with one AM and a single view object, connected to database through a datasource. I have two view controller projects say VC1 and VC2 sharing the same model. I created two pages in each of the viewController project as follows. <br /><br />1)In VC1,P1 Normal JSPX page with the view object used in it. <br /><br />2)In VC2,P1 Normal JSPX page with a inline frame calling the P1 in the VC1 through URL.<br /><br />It works fine no issues, But what I noticed is rather a something I couldn't understand,<br /><br />Every time I refresh the P1, only one connection is used every time. But when I refresh the P2, for every refresh one connection gets added up. <br /><br />The only difference in P2 is the using the INLINE FRAME calling the URL in other project. But y is that creating new connections instead of using the existing one like P1.<br /><br />Regards,<br />Oceanvijaioceanshttps://www.blogger.com/profile/16969450626268513871noreply@blogger.com