Search

Top 60 Oracle Blogs

Recent comments

March 2014

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 1Part 2, Part 3.

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 1Part 2, Part 3.

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 1Part 2, Part 3.

OUGN- Yes, I Get to be Julie the Cruise Director!

Tim and I leave for Oslo on Monday for the OUGN, (Oracle User Group Norway) conference.  This is a great conference that many of my friends have talked about for the last couple years and I finally let Oyvind talk me into going.  The conference is on a cruise ship that leaves from Oslo and sails for three days.

ASH Analytics- Activity Focused on Session Identifiers, Part III

We’re going to continue onto Session Identifiers in the ASH Analytics Activity view.  You can use the links to view Part I and Part II to catch u

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.

orabear

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 that plan to rest. Instead we just chatted a bit before the event started.

C14 OakTable World Las Vegas

Event date: 
Thu, 2014-04-10

 One of those events you don't want to miss.

C14 OakTable World Las Vegas

class="l-submain">
class="l-submain-h g-html i-cf">

If you haven’t yet made the decision to attend COLLABORATE 14 – IOUG Forum in Las Vegas taking place on 7-11 April, 2014 at the Venetian Hotel, this might just help you to make the call. You know you want to be there.

OakTable Network will be holding its OakTable World for the very first time during the COLLABORATE conference. While it’s a little bit last moment, IOUG was able to provide a room for us to use for the whole day and we at OakTable quickly put the schedule together. The agenda is selected by the OakTable speakers on the topics they are really passionate about. As history shows, this is generally what your also want to hear about.

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. This version is currently on its 3rd build since I first downloaded it and now the download links are broken. :(

 

Diagnostics

Here’s a little test you might want to try. Examine the following script, and decide what sort of symptoms you would see in the AWR report.


create global temporary table gtt1(n1 number);

execute dbms_workload_repository.create_snapshot;

insert into gtt1 values(1);
truncate table gtt1;

-- repeat insert/truncate for a total of 100 cycles

execute dbms_workload_repository.create_snapshot;

-- generate an AWR report across the interval.

I don’t need anyone to tell me their results – but if your predictions and the actual results match then you can give yourself a pat on the head.
You might also like to enable SQL trace for all the inserts/truncate to see if that shows you anything interesting.

This is one of the simpler scripts of the 3,500 I have on my laptop that help me interpret the symptoms I see in client systems.