Lately, I talked to several customers about Oracle patches, and each time it takes me quite a while to explain how it works.
So for all of you who don’t know about the different patching options (and what’s new in 12c), here is a short explanation about the topic.
Update (Feb 2016) – Oracle has recently changed the naming method for PSUs, please read my update here. Continue reading “Understanding Oracle Patching”
Today, something important about global temporary tables and the space they consume. Continue reading “Did You Know #3 – Temporary Tables”
Why do We Need Listener Registration?
In Oracle environment, we have a special component that listens to network requests to connect and pass them on to the instance. This is the listener, of course. We need to remember that a single listener can serve several instances, and a single instance can be served by several listeners. So in order to do its job, the listener needs to know all the instances it serves. Continue reading “Listener Registration Explained”
This time, about ASO or Advanced Security Option. Continue reading “Did You Know #2 – ASO”
So, this is the first “Did you know” post, and this time, unicode characters in char/varchar2 columns. Continue reading “Did You Know #1 – Unicode”
This is an idea I had. In this area of “Did You Know?” I’ll write short posts about interesting stuff I just discovered and are not very known or common (or even make sense).
Hope you find this interesting.
Last year I got an article published in the OTN. It talks about a strange behavior I saw when using the “shrink table” command with locally managed tablespaces with system allocation.
You can read the article here