提升Oracle APEX应用程序的性能

最新推荐文章于 2023-05-31 20:15:00 发布

weiyangcau

最新推荐文章于 2023-05-31 20:15:00 发布

阅读量1.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： apex 文章标签： APEX 性能 Oracle

本文链接：https://blog.youkuaiyun.com/apextrace/article/details/16340817

apex 专栏收录该内容

37 篇文章

订阅专栏

本文介绍了通过将EmbeddedPL/SQLGateway替换为OracleHTTPServer来提升Oracle APEX应用性能的方法，并在ApacheServer上配置mod_deflate进行响应压缩。详细分析了EPG的缺点及解决措施，旨在减少不必要的HTTP请求，显著提高页面加载速度。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

提升Oracle APEX的性能

影响APEX APP的性能的因素有很多。当然也就有很多种调优的方法。例如，可以做SQL查询优化，修改实现方式，例如用AJAX或者Javascript提前处理数据等等。下面主要讲两个基本的调优方法：

1. 将Embedded PL/SQL Gateway替换为Oracle HTTP Server（Apache），与Oracle数据库分开，在单独一个机器上运行
参考http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#BHAGICFJ
EPG的缺点：
（1）EPG does not add an "Expires" header. So, lets say you have 25 images in your page template, and none of them change. Each page view will still
request those 25 images. They use etags, so you don't have to download the images, but your browser still makes the requests which is quite slow. From

my testing, pages could be up to 4 times slower with the EPG with a pretty standard template. The XDB team is aware of this and working hard to resolve it.

（2）EPG does not support gzip. This is another HUGE performance hit.
参考：https://forums.oracle.com/thread/860543

2. 在Apache Server上配置mod_deflate，目的是压缩传递给客户端浏览器的response
参考：http://apextoday.blogspot.sg/2008/05/apache-2-compression-with-moddeflate.html

参考：

[1]https://forums.oracle.com/thread/631477

[2]APPLICATION EXPRESS - DELIVERING PAGES IN 3 SECONDS OR LESS(BECAUSE USES DON'T LIKE WAITING!)

http://www.shellprompt.net/~jes/docs/3%20seconds%20or%20less.pdf