Category Archives: Oracle

Tweaking

The following question came up on OTN recently: Which one gives better performance? Could please explain. 1) nvl( my_column, ‘N’) <> ‘Y’ 2) nvl( my_column, ‘N’) = ‘N’ It’s a question that can lead to a good 20 minute discussion – if you were in some sort of development environment and had a fairly free hand […]

Oracle Midlands : Event #3 – Registration Open

Registration is now open for Oracle Midlands Event #3 on Tuesday 20th May.. As I mentioned in a previous post, Christian Antognini will be the speaker for both the sessions this time. He’ll be covering “12c Adaptive Query Optimization” and “Row Chaining and Row Migration Internals”. Red Gate Software have kindly offered to sponsor the event again, so registration […]


Oracle Midlands : Event #3 – Registration Open was first posted on March 31, 2014 at 6:04 pm.
©2012 “The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Juggernaut

One of the problems of “knowing” so much about Oracle is that the more you know the more you have to check on each new release of the software. An incoming ping on my posting “Lock Horror” reminded me that I was writing about 11.2.0.1, and the terminal release is 11.2.0.4, and the whole thing may have […]

Juggernaut

One of the problems of “knowing” so much about Oracle is that the more you know the more you have to check on each new release of the software. An incoming ping on my posting “Lock Horror” reminded me that I was writing about 11.2.0.1, and the terminal release is 11.2.0.4, and the whole thing may have […]

Remote Surprise

Here is an example of surprising behaviour from a remote DB from an OTN forum thread Setup a link to a remote DB (I’ve used an actual remote DB and not tested a loopback) Remote DB: Local DB: Then alternate variations on this sequence of events: 1. On local DB execute SELECT: 2. On remote […]

UKOUG Operating System and Storage Event – 28th May

Just a quick note to say the call for papers is open for the UKOUG Operating System and Storage Event in Birmingham on the 28th May. To quote the website, “This event will cover Linux and Solaris Administration, Storage and Network Administration, Virtualisation and Engineered Systems. UKOUG Operating Systems & Storage Event takes place in Birmingham on […]


UKOUG Operating System and Storage Event – 28th May was first posted on March 27, 2014 at 10:30 am.
©2012 “The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Oracle Memory Troubleshooting, Part 4: Drilling down into PGA memory usage with V$PROCESS_MEMORY_DETAIL

If you haven’t read them – here are the previous articles in Oracle memory troubleshooting series: Part 1, Part 2, Part 3. Let’s say you have noticed that one of your Oracle processes is consuming a lot of private memory. The V$PROCESS … Continue reading

Oracle Midlands : Event #2 Summary

The second Oracle Midlands event took place last night. The most important part of the evening was the opportunity to win an Oracle Press teddy bear. Oh yeah, there were a couple of talks too… I was planning to arrive early and go for a quick drink with my dad, but the Birmingham traffic put […]


Oracle Midlands : Event #2 Summary was first posted on March 26, 2014 at 9:34 pm.
©2012 “The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

C14 OakTable World Las Vegas

OakTable Network will be holding its OakTable World for the very first time during the COLLABORATE conference.

VirtualBox 4.3.10

VirtualBox 4.3.10 has been released. The downloads and changelog are in the usual places. At the time of writing, the link to the Windows version seems to be broken, but the Mac, Oracle Linux and Fedora versions are there. Happy upgrading! Cheers Tim… Update: Probably best to wait a while before downloading this new version. […]


VirtualBox 4.3.10 was first posted on March 26, 2014 at 4:28 pm.
©2012 “The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.