Troubleshooting Another Complex Performance Issue – Oracle direct path inserts and SEG$ contention
Here’s an updated presentation I first delivered at Hotsos Symposium 2015.
It’s about lots of concurrent PX direct path insert ant CTAS statements that, when clashing with another bug/problem, caused various gc buffer busy waits and enq: TX – allocate ITL entry contention. This got amplified thanks to running this concurrent workload on 4 RAC nodes:
When reviewing these slides, I see there’s quite a lot that needs to be said in addition to what’s on slides, so this might just mean a (Powerpoint) hacking session some day!
NB! After a 1.5 year break, this year’s only Advanced Oracle Troubleshooting training class (updated with Oracle 12c content) takes place on 16-20 November & 14-18 December 2015, so sign up now if you plan to attend this year!
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
공지 | Guru's Article 게시판 용도 | ecrossoug | 2015.11.18 | 608 |
4 | New Features of Security in Oracle Database 19c | 명품관 | 2019.02.08 | 5049 |
3 | More New Features in Oracle Database 19c | 명품관 | 2019.02.08 | 6593 |
2 | SQL Tuning Workshop | 명품관 | 2020.02.20 | 8158 |
1 | Oracle Linux 6.7 with Oracle 11.2.0.4 RAC | 명품관 | 2016.04.15 | 9699 |