Searching google for answers is something we all do with every question or request for information we have. I sometimes wonder how much of this data is simply wrong. This
Searching google for answers is something we all do with every question or request for information we have. I sometimes wonder how much of this data is simply wrong. This
As a senior consultant, I often come to a client’s site to diagnose and fix a problem they have. It can be a performance problem, strange database behavior, database crash
Many of my clients use storage backup (snapshots, etc.) to backup their databases. The right and supported way to do that is like any hot backup: place the database in
People ask me quite a lot about how I analyze performance issues. While I have some guidelines, there is no complete answer to this question. The actions I take depend
In the last post about tablespaces (tablespaces free space) I talked about used and free space in permanent and temporary tablespaces. I also included a script to see all the
I added a new page to my blog, the Script page! I know it doesn’t have a lot of content right now, but it has some useful links to scripts
Over the years I got many questions about free space in tablespaces and other issues related to allocating and de-allocating of space, fragmentation and more. So I decided to write
This is an interesting question that I sometimes find myself thinking about. I’ll start with my answer, I actually don’t know, but I can show you that all of them
When Oracle releases a new version or even a patchset, sometimes they change the default value of initialization parameters or add new features and introducing new parameters with them. These
If you don’t know, Oracle VTS is presented 3 times for three different parts of the world.