This content has been marked as final. Show 5 replies
not sure what you mean with txn records (sometimes abbreviations make a question loosing its context). To tune your ADF application
1) upgrade to a more recent version of JDeveloper (126.96.36.199 in your case) to benefit from bug fixes and enhancements
2) Read chapter 7 of http://docs.oracle.com/cd/E14571_01/core.1111/e10108.pdf
I have follow the below link but there is no performance effect of my application.
On VO level ,In Tuning
I have modified In batch Of 26 ,As needed ,and Query Optimizer hints FIRST_ROWS_26
AND ON the page level ,Table Column Property,Fetch size i have modified 26 and page definition level ExchangeTradedPlacementHeadVOIterator default range size is 25.
So i have above change but there is no effect on the performance of my application.
Please give me the Solution what will i do to increase the performance of an application.
first things you need to change to increase performance of your application :
you have to change the RowCountThreshold to -1 to all your ViewObjectIterator in the binding area of your pages.
According to ur opinion i have applied On page level , viewIterator RowCountThreshold is Default is 0 and i have modified RowCountThreshold is -1.
But There is no effect on the performance of an my application.
This is like catching a bear in the bush dear.
You can open the diagnostic logging and see the what is happening behind the scenes may be queries like select * from table is getting fired up or something or a lot of AM Pooling is happening or something else.