QuestionLog CompetingagainstOracleExadata.pdf

(27 KB) Pobierz
Q&A: Competing against Oracle Exadata by Implementing Oracle 12c New
Features - a Performance Series Event
May 26, 2016
Question / Answer
Q
A
Q
A
Q
A
Q
A
Q
A
Q
A
1. Are the slides available for download?
Yes, they are in the Content Panel under the Handouts folder
2. Is this being recorded? Will it be available for replay?
Yes! An announcement will be made when it is available.
3. How do I find out about these type of webinars/events?
Join the mailing list "opensource.announce" via
http://directory.hp.com/group_subscribe/subscribe.cgi?groupname=opensource.announce
&operation=Add%20Me
4. Is there an event calendar?
Yes at http://calendar.osp.hpe.com/osl/month.php
5. How do I join the Open Source Profession?
Go to the main page at http://link.osp.hpe.com/go/osp and click on the Join button in the
upper right.
6. Send the links to the tuning papers.
Whitepaper "Mitigate the Benefits of Exadata COT using 12c"
http://intranet.hp.com/tsg/WW2/CPT/Linux/Pages/PerfPapers.aspx
Whitepaper "Optimizing Linux performance on HP Integrity Superdome X"
http://intranet.hp.com/tsg/WW2/CPT/Linux/Pages/PerfPapers.aspx
7. Do you use Large Pages?
Yes, Large Pages were used in all the testing
8. Are these features like in-memory parallel are not set by default on Oracle 12c? Does
DBA need to be aware of these to boost performance?
These are not set by default ... they must be specified
9. I meant Huge Pages (Large pages)
yes, it is a best practice for most all environments
10. Do you use Large Pages?
Yes, Large Pages were used in all the testing
11. Are these features like in-memory parallel are not set by default on Oracle 12c? Does
DBA need to be aware of these to boost performance?
These are not set by default ... they must be specified
12. How does one engage GSE?
The last slide in the presentation has details on how to engage GSE
13. OLTP is also uses column base search?
That feature is not commonly used for OLTP workloads. Accessing individual rows via
indexes is the most common access method
14. If you share Template for capacity planning for Data Warehouse will be helpful.
Basically how much memory is required to use in memory feature which does not require
lic.
Q
A
Q
A
Q
A
Q
A
Q
A
Q
A
Q
A
Q
A
Whitepaper "Mitigate the Benefits of Exadata using Oracle 12c" discusses memory
Q
A
Q
A
Q
A
Q
A
planning
15. Is Exadata a more available infrastructure than the HPE competitive configuration?
A properly designed Oracle RAC cluster on HPE gear provides the same availability as an
Exadata appliance
16. Can we leverage HP's new persistent memory to offload, redo, undo?
Certainly there is potential here and it could really improve performance for update
intensive workloads. I suspect that Oracle will throw a lot of FUD at it
17. Can we approach Debra directly in order to get support to handle exadata competition
in one of our existing account
The best way to formally engage Debra and our team is by opening a request in SFDC
18. Does the whitepaper for SDX contain the tuning recommendations for NUMA
configuration?
Yes it does, The Best Practice whitepaper documents testing done using NUMA tuning
within Oracle
Zgłoś jeśli naruszono regulamin