Tag Archives: Tuning

Oracle Latch Contention Troubleshooting

I wrote a latch contention troubleshooting article for IOUG Select journal last year (it was published earlier this year). I have uploaded this to tech.E2SN too, I recommend you to read it if you want to become systematic about latch … Continue reading

Posted in Cool stuff, Oracle | Tagged , , , , , , , , , , | 12 Comments

Oracle Troubleshooting: How to read Oracle ERRORSTACK output?!

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 … Continue reading

Posted in Cool stuff, Oracle | Tagged , , , | 14 Comments