About UsServicesPricingPapers & PresentationsFAQScriptsBlogContact Us
PAPERS & PRESENTATIONS

Papers & Presentations

1. cost based query transformation-paper

2. Cost based query transformation presentation - presentation

3. Debunking myths about redo undo commit - paper

4. Debunking myths about redo undo commit - presentation

5. Exciting SQL new features - paper

6. Exciting SQL new features - presentation

7. Tools and techniques for advanced debugging

8. Performance tuning with SQL new features - paper

9. Performance tuning with SQL new features - presentations

10. Internals of locks

11. redo internals ppt

12. redo internals doc

13. Performance features 11g paper

14. Performance features 11g presentation

15. Battle of the nodes RAC performance myths paper

16. Battle of the nodes RAC performance myths presentation

17. Cost based query transformation htm

18. Tuning 101 scientific approach to bottleneck identification ppt

19. Redo internals scripts in pdf format

20. Advanced index internals

21. Why optimizer hates my SQL?

22. Advanced RAC troubleshooting paper

23. Advanced RAC troubleshooting presentation


Investigations

1. Tuning log file sync waits Blog discussion about tuning 'log file sync' waits

2. Resolving-hw-enqueue-contention Investigation about HW enqueue contention

3. Resolving-latch-contention-cbc Investigation about latch contention cache buffers chains latches

4. High CPU usage SYS mode

5. Investigations: Performance and hugepages

6. Investigations: Extended stats and multi column correlation

7. Investigations: Correlation, nocorrelation and extended stats

8. Investigations: cardinality feedback to resolve latch contention

9. Investigations: A stroll through shared_pool heaps

10. Investigations: Tuning SQL statements scientifically

11. Investigations: Systemstate dump analysis high intensive noncache sequence RAC

12. Investigations: High global cache waits on tab$?

13. Investigations: Dynamic plan table, x$kqlfxpl, library cache latch

14. Investigations: Library cache locks and pin waits

15. Investigations: Resolving corruption issue with file_hdr dumps

16. Investigations: RAC, parallel query and udpsnoop

17. Investigations: ORA-4031 and shared pool durations

18. Investigations: Shared pool free lists and durations

19. Investigations: plan_hash_value and gc traffic

20. Investigations: Dynamic remastering in RAC

About Us | Services | Pricing | Papers & Presentations | FAQ | Scripts | Blog | Contact Us
© 2008 OraInternals All rights reserved.