Why ADF application shows data without executing the VOs when page load

Problem

>>ADF application initial page loading in development enviornment not show any query results and this is the expected behaviour.

ADF version : 11.1.2.4.0

>>However in production enviornment with the load it shows unwated data results in the initial page load.

Solution
In the tuning section of the VO set no rows check box.

Note: This should be enable according to your requirment and only to required VOs. Check any source codes that reseting VOs wthis now rows option.

Additional info:

https://blogs.oracle.com/shay/entry/preventing_queries_when_page_f

https://blogs.oracle.com/shay/entry/delay_method_execution_when_us

Find User count and Session Count of the DB

SELECT se.machine, count(1)
FROM v$open_cursor oc, v$session se
WHERE oc.sid = se.sid
GROUP BY se.machine
HAVING COUNT(1) > 2
Order By Count(1) Desc

ADF Performance Tuning

Very usefull web resources for ADF Application /Weblogic Server and datasource tuning

Oracl General 
http://www.oracle.com/technetwork/developer-tools/jdev/index-097578.html

Oracle Fusion Middleware Performance and Tuning Guide
https://docs.oracle.com/cd/E25178_01/core.1111/e10108.pdf

ADF Performance Tuning
https://blogs.oracle.com/groundside/resource/presentations/Mills_ADFPerformance.pdf

http://andrejus2.rssing.com/chan-6059235/all_p7.html

1.  Enable DB pooling
2. Increase AM instance Idle Instance Timeout
3. Increase or set to -1, AM instance Time to Live

http://andrejusb.blogspot.com/2011/11/stress-testing-oracle-adf-bc_16.html

Leak connection and Reduce Time to Live

http://andrejusb.blogspot.com/2010/02/optimizing-oracle-adf-application-pool.html

Passivation and Activation

http://xmlandmore.blogspot.com/2012/10/passivation-and-activation-in-oracle.html

ADF Stress Testing
http://www.oracle.com/technetwork/developer-tools/adf/learnmore/adfloadstresstesting-354067.pdf

ADF Logging
https://blogs.oracle.com/groundside/entry/adventures_in_logging_index


Weblogic Database connection configurations
http://xmlandmore.blogspot.com/2012/10/dynamically-sizing-jdbc-connection-pool.html

ADF Out put text value new line seperation

Use  <br /> tag and escape="false"

Refer below link for more information:
http://blog.michaelscepaniak.com/jsf-render-line-breaks-in-the-outputtext-tag