Embed Size (px)
Citation preview
Tuning des Weblogic /Oracle Fusion
Middleware 11g
Copyright 2012 PITSS GmbH www.pitss.com1
Jan-Peter TimmermannPrincipal Consultant
PITSS
Agenda
• Bei jeder Installation wiederkehrende Fragen� Wieviel Forms Server brauche ich
� Wieviel RAM brauche ich bei 100 Usern (Hardware)
Ag
en
da
Copyright 2012 PITSS GmbH www.pitss.com2
� Wieviele Report Server benötige ich
� Wie viel Heapsize sollte der Forms Server bekommen (mehr als 1024 MB) ?
Ag
en
da
Viele Faktoren beeinflussen die UmgebungO
racl
e
• The client specification: memory and CPU
• The middle tier specification: memory and CPU.
• The database tier specification: can the database keep up
with the
Copyright 2012 PITSS GmbH www.pitss.com3
Ora
cle
with the
requests from all of your concurrent users or is it a bottleneck
• The network topology.
� Between the client and the middle tier.
� Between the middle tier and the database
• Do they do a lot of calculations (CPU-intensive)? Do they
process large amounts of data (memory-intensive)?
Was sagt denn Google dazu
• Suchbegriff : oracle forms 11g performance tuning
� 171.000 Ergebnisse
• Forum.oracle.com� Search Results » Messages: 189 - Search Terms: tuning wls_forms
Su
che
n
Copyright 2012 PITSS GmbH www.pitss.com4
� Search Results » Messages: 189 - Search Terms: tuning wls_forms
� https://forums.oracle.com/forums/thread.jspa?messageID=9795437�
Su
che
n
Was sagt Oracle zu dem Thema
• Information Center: Optimizing Performance
of Oracle Fusion Middleware 11g [ID
1469617.2]
Ora
cle
Copyright 2012 PITSS GmbH www.pitss.com5
� About Reports Servers Spawning Engines [Document 1446679.1]
� Oracle Support Policy on Oracle Forms/Reports Performance Tuning [Document
1352875.1]
� Slow Response Time with Arraysize Set to Higher Values in Forms 11 and Sqlplus
[Document 946045.1]
� Performance Decreasing Using Web Cache in Combination With Oracle Forms
[Document 443405.1]
Ora
cle
Oracle Support Policy on Oracle Forms/Reports Performance Tuning
• Oracle has no specific documents that state � "if you have X number of users you will need Y amount of RAM and Z amount of CPU
speed".
• Oracle Application Server Forms Services 10g
Ora
cle
Copyright 2012 PITSS GmbH www.pitss.com6
• Oracle Application Server Forms Services 10g
(9.0.4) Capacity Planning Guide
Seite 14 “The only true way to test the scalability for your application is to run your
own benchmarking tests”
Ora
cle
Kalkulations Vorschlag laut GuideO
racl
e
Total memory = Memory for the operating system + Base
Application Server memory + Memory consumed per user * # of
Users + Average free memory
Copyright 2012 PITSS GmbH www.pitss.com7
Ora
cle
Memory consumed per user = ( Total Memory - Memory for the
operating system - Base Application Server memory - Average
free memory ) / # of Users
Die Test-MaskenTe
stM
ask
en
Copyright 2012 PITSS GmbH www.pitss.com8
Test
Ma
ske
n
VerbrauchV
erb
rau
ch
Gesamt Benutzt Frei Verbrauch
Nur OS 8.002,39 651,93 7.350,46
Nach DB 8.002,39 995,49 7.006,91
Copyright 2012 PITSS GmbH www.pitss.com9
Ve
rbra
uch
Nach WLS 8.002,39 3.907,51 4.094,88
Test.fmx 8.002,39 3.920,55 4.081,84 13,04 MB
DatenMaske 8.002,39 3.988,05 4.014,34 80,54 MB
Reports
Maske 8.002,39 3.974,07 4.028,32 66 MB
Mit Report 8.002,39 74 MB
Daten Test 1 Anwender
Copyright 2012 PITSS GmbH www.pitss.com10
DatenTest 100 Anwender
Copyright 2012 PITSS GmbH www.pitss.com11
Mögliche Lösung
• In der Formsweb.cfg� prestartRuntimes=True
� prestartInit=100
� prestartMin=100
Copyright 2012 PITSS GmbH www.pitss.com12
• Oder� Prestart
Verwaltungsmaske / Test Reports
Copyright 2012 PITSS GmbH www.pitss.com13
Heap Size bei Forms/ReportsH
ea
p S
ize
Copyright 2012 PITSS GmbH www.pitss.com14
He
ap
Siz
e
Heap Size bei Forms/ReportsO
racl
e
Copyright 2012 PITSS GmbH www.pitss.com15
Ora
cle
Copyright 2012 PITSS GmbH www.pitss.com16
Copyright 2012 PITSS GmbH www.pitss.com17
Copyright 2012 PITSS GmbH www.pitss.com18
Erfasster Bildschirmausschnitt: 28.08.2012 13:36
Copyright 2012 PITSS GmbH www.pitss.com19
Zum Nachlesen
• Oracle Forum:� https://forums.oracle.com/forums/thread.jspa?messageID=9795437�
• Fortbildung:
Copyright 2012 PITSS GmbH www.pitss.com20
• Fortbildung:� WeblogicServer Forms & Reports für Administratoren (25 -27. Sept 2012)
� http://www.pitss.de/services/trainings/administration/weblogicserver-forms-reports-
fuer-administratoren/
Danke für Ihre Aufmerksamkeit
PITSS GmbH
Jan-Peter Timmermann:
Ko
nta
kt
Copyright 2012 PITSS GmbH www.pitss.com21
Principal Consultant
Email: [email protected]
Phone: +49 172 215 1043
Website: www.pitss.de
Ko
nta
kt
Stellen Sie Ihre Fragen…F
rag
en
un
d A
ntw
ort
en
Copyright 2012 PITSS GmbH www.pitss.com22
Fra
ge
n u
nd
An
two
rte
n
