Oracle Portal Performance

This note apply to Oracle Portal 10.1.4.2.0 in HA environment and linux S.O.

In the webcache event.log file , continuously this message is shown :
[warning 11366] [ecid: xxxxxx] A client connection to listening port 80 is dropped.

If the mandatory patches was applied and portal performance is really slow, follow bellow :

This note instructs an intermediate tuning based on experiences.

 

Portal:

Cache:
First of all, put the first page and all principals pages in cache:
Log-in at http://site.domain/pls/portal and click in navigator->page group->Pages->Properties (selected page)
Select “Cache Page Definition and Content at System Level for” and insert “5” Minutes .
Select “Limit Time Spent Fetching Portlets to” and insert “30” Seconds .

Show html/portlets times:
Put after url “?_debug=0”,  example :  http://site.domain?_debug=0

Show Urls Times:
Log-in at Database:
select parsing_schema_name, sql_text, elapsed_time/1000000 elapsed_sec, executions, disk_reads, buffer_gets
from v$sqlarea  order by elapsed_time desc

 

Infrastructure Database:

init.ora:
shared_pool_size = 2Gb
large_pool_size = 256M
java_pool_size = 256M
db_cache_size = 256M
log_buffer = 14226432
processes = 3000
sessions = 4000
transactions = 4000
open_cursors = 5000
db_writer_processes = 6

 

Infrastructure HTTP Server:

KeepAlive Off

 

Midtier WebCache:

Network Timeouts:
Keep-Alive Timeout(sec): 15

Resource Limits:
Maximum Cache Size (MB): 1500
Maximum Incoming Connections: 850
Maximum Cached Object Size (KB): No maximum set

Origin Servers:
Capacity: 300
Failover Threshold: 3
Ping Interval: 5

/etc/sysctl.conf:
net.ipv4.tcp_keepalive_time = 900
net.ipv4.tcp_keepalive_probes = 3
net.ipv4.tcp_keepalive_intvl = 20

/etc/hosts (put all the host name in Site Definitions in hosts) :
Example:
192.168.1.10   www.domain
192.168.1.11    bi.domain

 

Midtier HTTP Server:

KeepAlive On
MaxKeepAliveRequests 0
KeepAliveTimeout 15
MinSpareServers 20
MaxSpareServers 50
StartServers 20
MaxClients 400
MaxRequestsPerChild 0

 

Midtier OC4J_Portal:

opmn.xml:
number of processes = 2

$ORACLE_HOME/j2ee/OC4J_Portal/applications/portal/portal/WEB-INF/web.xml :
maxParallelPortlets = 100
maxParallelPagePortlets = 20
poolSize = 100
queueTimeout = 40

 $ORACLE_HOME/Apache/modplsql/conf/dads.conf:
Location /pls/portal :
PlsqlMaxRequestsPerSession 5000

 $ORACLE_HOME/Apache/modplsql/conf/cache.conf:
PlsqlCacheTotalSize 209715200

 

 

Good Luck !

Leave a Reply

1 Trackback to "Oracle Portal Performance"

  1. on 08/25/2011 at 3:12 PM