What is caching concept and how it is linked with Query Performance?

1.	What is caching concept and how it is linked with Query Performance?
Answer» To improve query performance, we disable BI server cache option. Open a browser and enter the below URL to open Fusion Middleware Control Enterprise Manager − http://<machine name>:7001/em Enter user name and password and click on login. In the left side, expand Business Intelligence → coreapplication → Capacity Management tab → Performance Enable BI Server Cache section is by default checked → Click on Lock and Edit Configuration → Close. Now deselect cache enabled option → It is used to improve query performance → Apply → Activate Changes → Completed Successfully.

Answer»

To improve query performance, we disable BI server cache option.

Open a browser and enter the below URL to open Fusion Middleware Control Enterprise Manager −

http://<machine name>:7001/em

Enter user name and password and click on login.

In the left side, expand Business Intelligence → coreapplication → Capacity Management tab → Performance

Enable BI Server Cache section is by default checked → Click on Lock and Edit Configuration → Close.

Now deselect cache enabled option → It is used to improve query performance → Apply → Activate Changes → Completed Successfully.

Discussion