If you are in Singapore and have 24th Feb afternoon available then you can register and join a free Oracle performance troubleshooting seminar I’m doing in Singapore Management University’s (SMU) campus.
The seminar will be about:
- Systematic Oracle Performance Troubleshooting
- Identifying performance troublemakers
- Understanding execution plans
The date is Wednesday, 24th Feb
The seminar time is from 15:30-19:00 (don’t be late)
Registration and more details are here:
Tanel Poder Cool stuff, Oracle, Performance, Troubleshooting, Tuning
I have written the first article to the troubleshooting section of my new website tech.E2SN.com:
It’s about a very valuable Oracle troubleshooting tool -> ERRORSTACK trace.
I cover 4 frequently asked questions there:
- Reading the current executing SQL statement text from errorstack trace
- Reading the current executing PL/SQL package and PL/SQL source code line number from errorstack trace
- Reading the current bind variable values from errostack trace
- Identifying how much private (UGA) memory a cursor is using
You can read it here:
By the way, if you like my new website, feel free to link to it !!! ;-)
Tanel Poder Administration, Cool stuff, Internals, Oracle, Troubleshooting, Tuning
Kyle Hailey has started putting together a much needed Oracle wait event reference.
You can access it here.
By the way, Oracle documentation also has a wait event reference section, it has more events, but it’s less detailed…
I have plans to go deep into some wait events and cover some less common ones in tech.E2SN too… in the future ;-)
Tanel Poder Cool stuff, Internals, Oracle, Performance, Tuning
Recent Comments