Oracle database operating system memory allocation management for PGA – part 3: Oracle 11.2.0.4 and AMM: Quiz

This is a series of blogposts on how the Oracle database makes use of PGA. Earlier posts can be found here (PGA limiting for Oracle 12) and here (PGA limiting for Oracle 11.2).

Today a little wednesday fun: a quiz.

What do you think will happen in the following situation:

-Oracle Linux x86_64 6u6.
-Oracle database 11.2.0.4 PSU 4
-Oracle database (single instance) with the following parameter set: memory_target=1G. No other (more...)

Managing your Database in a Zombie Apocalypse

Zombie Server Room

Only two things are really certain: network latency over long distances, and the fact that humanity will soon rapidly degenerate into undead brain-eaters.

When that day comes, when the dead are crowding at your door and the windows are busted out and ripped up rotted arms are clawing at the inside of your home, I know what you’ll be thinking: is my database protected?

Don’t worry, my friends. The Oracle Alchemist has you covered. We (more...)

Another Great OpenWorld

Steve at the Delphix Booth

Last week I attended Oracle OpenWorld 2014, and it was an outstanding event filled with great people, awesome sessions, and a few outstanding notable experiences.

Personally I thought the messaging behind the conference itself wasn’t as amazing and upbeat as OpenWorld 2013, but that’s almost to be expected. Last year there was a ton of buzz around the introduction of Oracle 12c, Big Data was a buzzword that people were totally excited (more...)

Fun : Destination Mars !

Et voilà mon Boarding Pass pour Mars !
Demandez le votre


Wireshark hanging on Windows 8.1 at startup

After upgrading Windows 8 to Windows 8.1 my wireshark freezed on every startup without showing up the main window.
The only workaround was to deinstall wireshark including wincap and installing it again. But after the nex reboot, it freezed again.

After searching around i found the following fix, with cured this problem:

inside the registry you have to change the DWORD start in
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesnpf
from 0 or 1 to 2. After that wireshark will start properly even after reboots....


Teach Your Children Well

computerroom

Today’s the first day of school in my city, and the plethora of “OMG 1st day of school!” posts of Facebook and my own kids heading back in to slog through another year of fundamentals got me thinking about education. My own kids (12/daughter and 10/son) came home and went swimming since it was about 104 degrees today…the hottest day of the summer, as it were.

minecraft-2__140227213724Anyways, after that activity my son decided to (more...)

Unforgettable In-Memory

Inspired by Maria Colgans quest for In-Memory bumper sticker slogans for OOW14, I couldn't resist a little fun. Musical readers should stop reading now :-)




Sung to the tune of the old Nat King Cole classic


Unforgettable
Like wizardry
Unforgettable
In-Memory

Like the speed of light my query go
Column aggregates just happen so
Never before
Has data been more...

||:
Unforgettable
So cleverly
Is forever more
In-Memory

Row based access, it's a dinosaur

Making the CDB Common User Without Using C## Prefix….

If you have done any play with the latest release of Oracle database 12c, you must have come across the concept of Common and Local users. I won’t rewrite what’s already there in the docs but for setting the context of the post, a Common user must be created with a prefix added to the username-C##. Miss that and you won’t be able to create one while being connected to the Container database. On (more...)

Fun : Une journée à Washington DC


Say Hello To Oracle Linux 7.0….

Seems like it’s going to be a week of new releases only. Last night only, I downloaded and installed Oracle database 12c patchset(12102) and today, Oracle Linux’s latest release OL7 is released. The download is available from E-Delivery portal and mine is going on. I don’t think it would take long before 12c would be certified for Oracle Linux 7 but I would do the installation of both, database and Linux, as soon as my (more...)

Oracle 12c(12.1.0.2) Has Arrived….

Just checked Tim’s latest post and guess what, Oracle database 12c’s latest release, 12.1.0.2 is available now for download. It is available as an OTN download as well as from E-Delivery. Seems like that there is no documentation update available yet as the New Features guide still doesn’t have 12.1.0.2 included in it. But I am sure that it’s coming soon!

So grab your copy now and happy downloads :=).

Packt Shares Its Full Range of eBook/Video For Just $10….

Yes, that’s correct! Packt Publications is celebrating 10 years of effective learning and information services to IT professionals. To make us part of this celebration, the good guys  are offering all eBooks and Videos at just $10 each until July 5th. So this would be a really good chance to get any e-book or Video of your choice in such a good price. Sounds good? Well follow this link then,http://goo.gl/Dnn5RP.

And since every (more...)

FritzBox 7270: CLIP stops working after upgrading to FritzOS 6.05 (problem solved)

After upgrading to FritzOS 6.05 CLIP stopped working with my analog phone.
The settings looked quite ok: (Telefonie -> Telefoniegeräte -> bearbeiten -> Merkmale des Telefoniegeräts)

This basic feature was certainly not shipped without testing. So this has to be a problem of data/parameter migration.
After unchecking CLIP, doing a reboot and ba checking the box again CLIP worked like before...

Dynamic Registration In 12c Using LREG….

There is a lot of change that release 12.1 or 12c has brought up. And it’s not in the more advanced new features that I am talking about but even in some areas about which, we have memorized a particular concept by heart from last many years. Once such change is what I am going to mention in this post-introduction of the LREG(Listener Registration) process.

Basics of Dynamic Registration
In the earlier releases,to register (more...)

WordPress 3.8.2

Just the usual upgrade of WordPress to the latest version 3.8.2. If you are able to read this, it went fine :=).Download it from here if you haven’t done it already.

Best Practice in 12c

Since PL/SQL now is closely integrated into SQL, we hence can happily state
sokrates@12.1 > with function bestpractice return varchar2
  2  is
  3  begin
  4     return 'Do not use PL/SQL when it can be done with SQL alone !';
  5  end bestpractice;
  6   (more...)