Apex listener file caching

I don't like to say this is more efficient than that, I think it depends your use case, application, load etc. So I always recommend to do test cases and some load testing with JMeter for ex. Most efficiency in APEX applications is not on the webserver, but in the database though.

Any advice on this? Thanks in advance, Luis. Use this class in a filter and add it to the apex. Hope it helps, Luis. Post a Comment. Performance wise I show in my presentation and whitepaper how you can test your own configuration with JMeter, so you have real metrics. Newer Post Older Post Home. Subscribe to: Post Comments Atom. My next public appearances: Currently none scheduled. About Me Dimitri Gielis Passionate about bringing ideas to life with code.

View my complete profile. Twitter Follow dgielis. The answer My e-book Click on the book, leave your email and be the first one to know when it's published! If the cache type is expire, Oracle Application Express Listener will check the cache every NN minutes for files that have expired. For example, if the monitorInterval is 60, then it will check the cache every 60 minutes. The password of the specified database user.

Include an exclamation at the beginning of the password so that it can be stored encrypted. Specify how long a borrowed in use connection can remain unused before it is considered as abandoned and reclaimed. The abandoned connection timeout is in seconds. Specify how long an available connection can remain idle before it is closed. The inactivity connection timeout is in seconds. The default page to display. The Oracle Application Express home page, apex , is commonly used.

Specify the procedure name s to execute after executing the procedure specified on the URL. Multiple procedure names must be separated by commas. Specify the procedure name s to execute prior to executing the procedure specified on the URL. Specify a pattern for procedures, packages, or schema names which are forbidden to be directly executed from a browser. Specify a pattern for procedures, packages, or schema names which are allowed to be directly executed from a browser.

Specify a validation function to determine if the requested procedure in the URL should be allowed or disallowed for processing. The function should return true if the procedure is allowed; otherwise, return false. This parameter specifies the location of the configuration file. Setting the Value of the c onfig. To specify the value of the config. Rezip the modified files into a new apex. Deploy the modified apex. Understanding Configuration File P arameters Each entry in the apex-config.

About Configurable P arameters Table A-1 lists editable parameters in the apex-config. Defaults to 7. Defaults to Each procedure name must be separated by a comma. Supported values: basic tns advanced basic apex. Supported values: true false default false apex. Maximum Connections - Specify the maximum number of connections. Maximum Statements - Define the maximum number of statements to cache for each connection. Configuring S ecurity Use the Security tab to validate procedure requests and determine if a user is allowed to access the procedure.

To specify Allowed Procedures: Click the Security tab. Click Allowed Procedures to expand or hide the content. In Inclusion list, enter the procedure name or procedure patterns separated by commas. Tip: The advantage of using Allowed Procedures is that the procedure names and procedure patterns are stored in the Oracle Application Express Listener, whereas invoking the Database Validation Function requires a database round-trip.

Advantages of Allowed Procedures The advantage of using Allowed Procedures is that the procedure names and procedure patterns are stored in the Oracle Application Express Listener. About B locked Procedures Use Blocked Procedures to specify procedures, packages, or schema names that cannot be executed from the Web browser. To specify Blocked Procedures: Click the Security tab. Click Blocked Procedures to expand or hide the content.

About the Internal Exclusion List The Oracle Application Express Listener includes an internal exclusion list which blocks users from accessing the following: sys.

Click Blocked Procedures to expand the content. Click Database Validation Function to expand or hide the section. In the field provided, enter the name of the Database Validation Function. About the Database Validation Function Format The validation function must return a boolean and have one argument for the procedure name. To specify Security Settings: Click the Security tab. Click Security Settings to expand or hide the content.

As a best practice, clear the cache whenever a Database Validation Function is updated. Understanding S ecurity Processing If the user enters data for Allowed Procedures, a Database Validation Function, or Blocked Procedures, the Oracle Application Express Listener determines if the entered procedure name is valid by checking the security information in the following order: Database Validation Function - Checks if the procedure name is valid.

Allowed Procedures - Checks if the procedure name is in the inclusion list. If these validations pass, then the procedure is valid for processing. The Cache Files page appears. Maximum entries Specify the maximum number of files to cache. When the maximum entries have been reached, the older files are removed from the cache when a new file is added.

Keep files for the specified duration If selected, files that are cached expire after the specified length of time. Expires after Specify the length of time after the files expire. Note the selected value must be a numeric value greater than 0. Options include: days , hours , or minutes. Tip: Once you specify a Procedure Name, the Keep files for the specified duration and Keep most recently used files button are enabled. Viewing S tatus Click the Status tab to view statistics, error tracking, and logging information.

Tip: Users with the manager role only see the Status tab. About Statistics Click Statistics to expand or hide this section. Total accesses, total traffic, total errors, total file downloads, and total processing time. Processing time in milliseconds for minimum, average, median, and maximum.

Database time in milliseconds for minimum, average, median, and maximum. Active requests. Active and available connections in the pool. Security enabled or disabled, and its cache entries and maximum entries. Cache file enabled or disabled, and its cache entries and maximum entries.

Description of the illustration statistics. About Logging Click Logging to expand or hide the log of the different types of activities that occur in the Oracle Application Express Listener. Configuring Mi scellaneous Options The Miscellaneous tab provides various configuration options, including specifying the default Web page, enabling the different types of error reporting, and whether to clear logging.

To specify options on the Miscellaneous tab: Click the Miscellaneous tab. The Miscellaneous tab appears. Description of the illustration misc. Show error messages on browser - Select this option to display error messages on the browser. Keep most recent error messages - Select this option to retain the error messages.