Tag Archives: Troubleshooting

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

New versions of LatchProf and LatchProfX for latch contention troubleshooting and tuning

The LatchProf and LatchProfX scripts allow you to be more systematic with latch contention troubleshooting and tuning. No more guesswork is needed as these scripts give you exact session IDs and in this version also SQLIDs of the troublemaking applications. … Continue reading

Posted in Cool stuff, Oracle | Tagged , , | 7 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

Recursive sessions…

I have published a new article to tech.e2sn.com about recursive sessions and ORA-00018: maximum number of sessions exceeded error message: http://tech.e2sn.com/oracle/oracle-internals-and-architecture/recursive-sessions-and-ora-00018-maximum-number-of-sessions-exceeded Note that I’m working on setting up RSS feed for tech.e2sn too, coming soon :) Note that this year’s … Continue reading

Posted in Oracle | Tagged , | 5 Comments