Oracle/AIX Performance and Tuning
[Link]
Scribd Upload a Document Search Documents Explore
Documents
Books - Fiction Books - Non-fiction Health & Medicine Brochures/Catalogs Government Docs How-To Guides/Manuals Magazines/Newspapers Recipes/Menus School Work + all categories Featured Recent
People
Authors Students Researchers Publishers Government & Nonprofits Businesses Musicians Artists & Designers Teachers + all categories Most Followed Popular
Manh Ha We're using Facebook to personalize your experience. Learn MoreDisable Home My Documents
1 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
My Collections My Shelf View Public Profile Messages Notifications Settings Help Log Out
/ 70
s Document for Free
2 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
3 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
4 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
5 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
6 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
7 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
8 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
9 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
10 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
11 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
12 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
13 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
14 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
15 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
16 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
17 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
18 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
19 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
IBM Systems & Technology Group Technical Conference 2008
CPU : Simultaneous Multi-Threading (SMT)
Feature available on POWER5 and POWER6 system running AIX
5.3 or 6.1 allows 2 instruction path to share access to the POWER execution
/ 70
s Document for Free
20 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
-m on enables the SMT mode, -m off disables it -w boot makes SMT change effective on reboot -w now makes SMT change effective immediately but
IBM Systems & Technology Group Technical Conference 2008
CPU: Micro-Partitioning
Micro-Partitioning give the possibility to share processors between several LPARs. It improve CPU utilisation by reducing the number of idle cycle. (available on POWER5 and POWER6 system running AIX 5.3+)
DLPAR Configuration
SPLPAR Configuration
An example given based on a PeopleSoft/Oracle10g RAC benchmark (2,400 Virtual Users) ran at PSSC MOP (DLPAR performance vs. SPLPAR one)
IBM Systems & Technology Group Technical Conference 2008
CPU: Compatibility Matrix
T M R A P L
n o i t i t r a P o r c i
/ 70
s Document for Free
21 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
Total Throughput (bytes):2,037,677,193 Action_Transaction: 59.07 secs
Oracle 10g Oracle 11g
Total Throughput (bytes):2,715,373,065 Action_Transaction: 53.256 secs
IBM Systems & Technology Group Technical Conference 2008
Agenda
Oracle Server Architecture Memory
AIX VMM tuning Oracle Memory Structure Allocation
IO
AIX LVM Striping
CPU Monitoring & Tuning
Methodology & tools Focus on Two Oracle Tools: AWR & Grid Control
Conclusion
IBM Systems & Technology Group Technical Conference 2008
Monitoring & Tuning : Methodology
DBA System administrator
/ 70
s Document for Free
22 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
a minimun of AIX mount option performed at each iteration changes should be tuning is a joint effortASM Oracle between the system administrator and the DBA dont hesitate Asynchronous IO to keep a log to track changes and the impact of these changes
design/parameters changes Oracle monitoring
IBM Systems & Technology Group Technical Conference 2008
Monitoring & Tuning (contd) : System Monitoring Tools
vmstat useful for obtaining an overall picture of CPU, paging, and memory usage lvmstat useful to get logical volume I/O statistics iostat allows to get statistics on disk activity (and also on terminals, CPU, adapters) lparstat reports logical partition related information and statistics nmon complete tool which gives information on all the components of the system filemon uses the trace facility to report on the I/O activity of physical volumes, logical volumes, individual files, and the Virtual Memory Manager xmperf allows to define monitoring environments to supervise the performance of the local and remote systems netstat allows to monitor network activity
/ 70
s Document for Free
23 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
24 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
25 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
26 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
27 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
28 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
29 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
30 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
31 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
32 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
33 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
34 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
35 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
36 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
/ 70
s Document for Free
37 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
Oracle/AIX Performance and Tuning
Download this Document for FreePrintMobileCollectionsReport Document This is a private document.
Info and Rating
oracle tips advice AIX recommendations Tunning peformance Internet & Technology (more tags) oracleinsight
Access Denied (policy_denied)
Share & Embed Related Documents
PreviousNext / 70
s Document for Free
38 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
1. p.
p.
p.
2. p.
p.
p.
3. p.
/ 70 p.
s Document for Free
39 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
p.
4. p.
p.
p.
5. p.
p.
p.
6. / 70 p.
s Document for Free
40 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
p.
p.
7. p.
p.
p.
8. p.
p.
/ 70 p.
s Document for Free
41 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
9. p.
p.
p.
10. p.
p.
p.
11. p.
/ 70 p.
s Document for Free
42 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
p.
12. p.
p.
p.
13. p.
p.
p.
14. / 70 p.
s Document for Free
43 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
p.
p.
15. p.
p.
p.
16. p.
p.
/ 70 p.
s Document for Free
44 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
17. p.
p.
p.
18. p.
p.
p.
More from this user
PreviousNext
1. 70 p. / 70
Recent Readcasters
s Document for Free
45 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
Add a Comment
share: Characters: 400 pluto6203left a comment how can i download this doc?? 12 / 28 / 2009 Reply gwoudenleft a comment We have performance issues with AIX 5.3 and CIO. I would like to download the file. Please allow. Thanks 10 / 16 / 2009 Reply oracleinsight replied: you can contact my Center with this email address oraclibm@[Link]. If you have already a Oracle Service request created please let me know. 10 / 17 / 2009 pankajwcleft a comment Nice doc for users on AIX. I need to download the same. Kindly allow the same, to be downloaded. 06 / 04 / 2009 / 70 Reply
s Document for Free
46 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
abc6309982left a comment I would like to download this good doc. Please permit this doc to be downloadable. thanks. 05 / 15 / 2009 Reply
Upload a Document Search Documents Follow Us! [Link]/scribd [Link]/scribd [Link]/scribd
About Press / 70Blog Partners Scribd s Document for Free 101
47 of 48
11/16/2011 1:30 PM
Oracle/AIX Performance and Tuning
[Link]
Web Stuff Support FAQ Developers / API Jobs Terms Copyright Privacy Copyright 2011 Scribd Inc. Language: English
/ 70
s Document for Free
48 of 48
11/16/2011 1:30 PM
