When enable this functionality please be aware of the following information:

• SQL file for Oracle database only works fine with Oracle 9i, 10g, and 11g databases.
• If a database server has multiple users, executing the SQL file under the login of one user will be effective for that user only. To make sure all users can use the DataWindow data-caching feature, you should use different logins to execute the SQL file.
• When you execute the SQL for a database server, the current login user of the server must have the right to execute stored procedures and create functions. 

Furthermore, if you use a third-party Web server as the Web server, you need to configure Web server for the DataWindow data-caching feature. For detailed instructions, refer to the Web Server Configuration Guide in Appeon Help. 

All the information above you can find in the Appeon Help | Appeon Server Configuration Guide for J2EE | AEM User Guide | Application Properties | DataWindow Data Cache chapter.