In the previous post I talked about the order of predicate execution based on the predicate position and inline view.As promised, in this post I’ll add statistics and see what
In the previous post I talked about the order of predicate execution based on the predicate position and inline view.As promised, in this post I’ll add statistics and see what
Resumable operations are operations that can be suspended instead of failing, allowing us to fix the problem and resume the operation. When importing data using impdp, if (for example) a
In my previous post, I wrote about the parsing operation and what happens first. In the footnote I said that the order doesn’t affect performance, the cost based optimizer doesn’t
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
In the previous part (you can find it here) I discussed the character sets Oracle supports and the length limits. In this part I’ll show how it is actually stored and
Being in North America (the English speaking side), made me understand that many people are not aware (and don’t actually care) about character sets too much. Everything supports English, and
My previous post about bypassing the listener was a big success. It actually broke my daily record (the previous one was the Oracle Challenge). Anyway, because of this success, I’ve
The listener is the first contact we make in order to connect to the Oracle database. Therefore, as DBAs, it is also the front-end component we can secure. There are
I’ve been asked quite a few times about the difference between number and character columns in Oracle. So I decided to write this article in order to explain how things