Parse Order and Analysis

Over the years I’ve heard and learned quite a lot about how Oracle does stuff. Some of it was logical, some just details to remember (I have a really lousy memory, but somehow, I actually remember some of the details). Not too long ago I wrote a query and got a parse error, and that lead me to write this post (and a couple more that will follow).

Continue reading

Advertisements

Analyzing the Listener.log

A little bit more than a month ago I spoke at OSWOUG event (and wrote this post about it). In the event, Jared Still talked about free tools for Oracle database. He basically said that there is a lot of stuff out there on the internet, and if you can’t find what you need, then write it and publish. So I couldn’t find what I need, and I wrote it, and now I publish (thanks Jared).

Continue reading

ODC Appreciation Day – Plan Statistics

If you don’t know that by now, OTN (Oracle Technology Netowrk) has changed its name to ODC (Oracle Developer Community), so OTN Appreciation Day becomes ODC Appreciation Day.

This initiative started by Tim Hall from ORACLE_BASE last year. In this day, every blogger writes something to thank Oracle for. You can read about the concept and “rules” here.

Continue reading

The English Language

I wrote this post quite a while ago and it stayed as draft since. A few days ago, during Oracle Open World 2017, I had a long chat with Jim Czuprynski and somehow we got to talking about the English language. As you well know by now, I’m not a native English speaker, but Jim is. I still managed to bring up some¬†anecdotes and taught him a thing or two about English in different countries in the world. After that talk I decided to go and publish this post. It’s not technical at all, but I like it and I think you might find some of the things amusing.

Continue reading