Oracle Documentation permalink creation

Tim Hall of ORACLE-BASE spoke for a lot of people when he (yet again) wrote about Oracle Documentation links changing all the time. There exists a method for a more permanent link to Oracle Documentation, but it can be a hazzle to create such a permalink involving manually searching HTML code of the doc source (see my comment to Tim's blog post.)


Then I thought that this manual creation of permalink probably could be (more...)

VirtualBox 5.0.16 Released….

As always, Tim Hall was the first to find it out :=) . So if you haven’t done already-update your VirtualBox setup to VirtualBox 5.0.16 version. I have done the update on my laptop (this one, Win 7 Professional) and desktop(Win 7 Professional) with no issues.

Have upgrading!

The Fundamental theorem of arithmetic – SQL version

Every positive integer (except the number 1) can be represented in exactly one way apart from rearrangement as a product of one or more primes, see for example Wolfram MathWorld or Wikipedia.

Here is the SQL-Version, we compute this for all integers up to 100

with bound as
(
select 100 as bound from dual
),
n_until_bound as (
select level+1 n
from dual
connect by level <= (select bound.bound from bound)
),
primes_under_bound  (more...)

A Greedy Algorithm using Recursive subquery factoring

Today is friday and I like the twitter-hashtag #FibonacciFriday,
so I tweeted

 

Don’t be afraid of having a look at the wikipedia-site, the math is not complicated at all ( you don’t need more than adding natural numbers smaller than hundred ), nevertheless the theorem is nice from a (more...)

Non-CDB Architecture Is Officially Deprecated….

Yeah, it’s indeed true and official. So if you still haven’t started reading and learning Multitenant architecture introduced in 12.1.0.1 and enhanced in 12.1.0.2, it’s high time that you start doing it. Not because that it’s new but because the old architecture you are familiar with, it’s officially on the verge of extinction.

Packt $5 E-Book Bonanza Is Back….

So it’s the first blog post of 2015 and what better can be than this that you can start 2015 with buying any e-book or video from https://www.packtpub.com/"  in just $5 till 6th January 2015! I believe this is a great chance to grab your favorite book(s) or video(s) at a really really good price! And if you are undecided about which book to start from, how about from my 12c Backup (more...)

Fun : 2015 !

Excellente Année 2015 !

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....


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...)

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...)

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...