Is your database secure? Are you sure? Are you *really* sure?

Credit for finding this bug is given to Daniel Ekberg – https://www.linkedin.com/profile/view?id=10435009. He got the official credit given by Oracle Corp for helping out with security related bugs in the January 2014 CPU. He found the bug and had the tenacity to track down and prove that it was a bug and not just a flaw in the logging mechanism where this first was indicated to occur.

Today is the day when (more...)

The empire strikes back!

About 3 years ago SAP started to create a new database engine, SAP HANA, with a pure In-Memory concept. SAP aggressively move it's new database to it's software stack. The database was not used as cache but for running Enterprise Application satisfying both OLTP and OLAP demands on the same database.  

As oracle announced the new Oracle 12c in late 2012 there the 'c' was for cloud based computing, means the simplification of creating (more...)

9th Planboard DBA Symposium

A couple of months ago, Nienke Gijsen invited me to speak about materialized views at the upcoming Planboard DBA Symposium. Because I had the pleasure of presenting before, I knew the conference is always well organized and a pleasure to visit. So of course I accepted the invitation. We agreed I'd talk on "just" incremental refreshes of materialized views using materialized view logs and about my

Discuss Your Modernization Challenges with Oracle at Kscope14

With Kscope14 only a week away, I wanted to share a unique opportunity with my readers. This year Oracle Product Manager, Michael Ferrante, is going to be answering questions about modernizing with Oracle Forms at the AuraPlayer booth (#414). If you are concerned about the future of your Oracle Forms investment or if you are unsure how to update, modernize or go mobile, then you can start discussing these challenges directly with Oracle.

Michael will be available to (more...)

Autonomes Logging mit postgres

Im Rahmen von ETL-Operationen ergibt sich immer wieder die Situation, dass man eine Log-Message in ein ETL-Log schreiben möchte, ohne dadurch die eigentliche Transaktion per commit festzuschreiben, denn der Umfang der Transaktionen sollte nicht durch die Log-Einträge bestimmt werden. Da die Log-Nachricht im Fall eines Rollbacks der Transaktion ebenfalls zurückgerollt werden würde, kann man sich allerdings auch nicht auf den Abschluss der eigentlichen ETL-Operation verlassen. Zur Lösung dieses Problems bietet Oracle das Pragma Autonomous Transaction (more...)

NULL-Werte in Indizes

Jonathan Lewis hat in seinem Blog zuletzt zwei Artikel veröffentlicht, die sich mit der Speicherung von NULL-Werten in Indizes beschäftigen:
  • Bitmap Nulls: liefert ein kompaktes Beispiel für die Möglichkeit der Verwendung von Bitmap-Indizes bei der Einschränkung über ein IS NULL Prädikat: bekanntlich enthält ein B*Tree-Index keine Einträge für Datensätze, bei denen alle indizierten Spalten einen NULL-Wert enthalten - während im Bitmap Index ausnahmslos jeder Datensatz indiziert wird. Somit kann eine Bedingung column IS NULL im (more...)

Sequence disallows order by

A call to a PRICE_S1 sequence in a query with an ORDER BY clause is disallowed. Any attempt raises the following exception:

SELECT   price_s1.NEXTVAL AS price_id
                  *
ERROR at line 1:
ORA-02287: SEQUENCE NUMBER NOT allowed here

You need to remove the ORDER BY clause to eliminate the error.

MySQL Insert from Query

While working with an error that my students surfaced in the Oracle Database 12c, I blogged about the limit of using a subquery in an Oracle INSERT statement, and I discovered something when retesting it in MySQL. It was a different limitation. I was also surprised when I didn’t find any mention of it through a Google search, but then I may just not have the right keywords.

The original test case (more...)

SQL Insert from Query

Sometimes my students find new errors that I’ve never seen. One student did that this week by including an ORDER BY clause in a subquery that feeds an INSERT statement. It raises an ORA-00907 exception, like:

ORA-00907: missing right parenthesis

You can’t include a subquery with an ORDER BY clause because it generates an error. The reason is simple. A subquery can’t perform a sort operation inside a subquery. Here’s a quick (more...)

Nice evening in Nieuwegein

Thursday I went for a quick trip to Nieuwegein for the Amis KScope Preview. Nice evening :-)

After a train to Copenhagen and a plane to Amsterdam, I checked in at the CitizenM hotel at Shiphol airport. A bit different hotel - toilet and shower in big glass tubes in the room - but actually fairly nice for a single traveller.

Patrick Barel was kind enough to pick me up, so getting to the Amis (more...)

Don’t Miss Out: ADF Sessions at Kscope14!

APWith Kscope14 fast approaching next week it’s time to stat preparing your agendas so you don’t miss out on any of the amazing opportunities or the fun that’s available! Of course most of the fun will be at the AuraPlayer booth #414. I invite any of my readers to come on down for a toast and to get one of our one-of-a-kind shotglasses.

 

 

MY TOP 11 ADF KSCOPE 14 SESSIONS

Now back to business. The (more...)

Hadoop-Einführung für Oracle-Nutzer

Eine kompakte und gut verständliche Einführung zum Thema Hadoop for Oracle Professionals hat Arup Nanda veröffentlicht, der darin diverse BigData-Termini und -Konzepte in die Sprache eines RDBMS-Benutzers übersetzt. 

Finland: OUGF Harmony 2014

Last week was the annual conference for the Oracle User Group Finland. This time the conference was at the Finnish Nature Center called Haltia. Needless to say that the location was beautiful.
Even though the conference started on Thursday, most speakers flew in on Wednesday. Heli, the president of the OUGF and dear friend, acted as a tourguide and showed Helsinki. The tour ended with a dinner at a Viking restaurant where the food (more...)

SQL Analytics – Ranking with ordinal suffix

SQL Analytics provides a fairly simple mechanism for determining positional rank within a set of results.

Before I demonstrate that query - which is already found in many good libraries - I thought I'd show how we could take it a step further and add the ordinal suffix (st, nd, rd, th) to a result.

We can do this using date format masks

with placing as (select rownum rn from dual connect by level <  (more...)

Interpretation von AWR Reports

Ich behaupte zwar bisweilen allerlei - aber nicht, ein Experte auf dem Gebiet der Interpretation von AWR-Reports zu sein. Normalerweise schaue ich fast ausschließlich auf die Query-Abschnitte. Aber wenn ich eine detaillierte Interpretation eines AWR-Reports durchführen müsste, dann würde ich mich an der von Jonathan Lewis in seinem Blog erstellten Link-Sammlung orientieren. Eine hübsch gestaltete einführende Präsentation zum Thema gibt's von Franck Pachot.

Late to the game: SAP

Having working with Oracle Fusion Applications, I know what a modern, cutting-edge user experience for enterprise software looks like. Something like this:

fusion-applications-screenshots-3I’ve also sometimes been subjected to SAP. Suffice to say, it does not look like this.

But maybe they’re upping their game – according to job hunting site Glassdoor.com, SAP is looking for 58 User Experience engineers. A bit late to the game, given than Oracle is already shipping stuff like the (more...)

OUGF Harmony 2014, #OUGF14

Originally posted on HeliFromFinland:
I am Finnish and this is the end (Björn Rost). The OUGF Harmony 2014 has ended. Sad:( It was such a fun event. I already miss all our great speakers and attendees…. ? We started on Wednesday with the speakers’ dinner in a Viking restaurant Harald. There was plenty of food…

Bestimmung der Log-Writer-Aktivität mit strace

Craig Shallahamer zeigt in einem Artikel und einem zugehörigen Mini-Video (Laufzeit 3:11 min) mit Hilfe eines strace-Aufrufs, dessen Ergebnisse er in eine Log-Datei schreiben lässt, dass der log-Writer-Prozess LWGR auch in 12c in einem beschäftigungslosen System alle drei Sekunden aufgeweckt wird, um zu prüfen, ob es etwas zu erledigen gibt. Im Trace-File findet sich regelmäßig ein Aufruf der Semaphoren-Operation semtimedop, die dazu dient einen Prozess für eine bestimmte Zeit in den sleep-Modus zu versetzen, sofern (more...)

Apex theme fun


Sometimes you are working with an off-the-shelf product and find something odd, and you're not quite sure whether it is a bug, a feature or whether you've lost the plot.

I use Oracle's Application Express, and was digging into the included theme_18. The templates refer to classes "t18success" and "t18notification"



And then I go looking into the CSS and see hash / ID selectors.

#t18Success{margin:5px auto;font-size:12px;color:#333;background:#DAEED2;width:600px;background-repeat:no-repeat;padding:5px;border:1px #95C682 solid;border-right:none;border-left:none;}

#t18Notification{margin:5px auto;padding:5px;font-size:12px;color:#333;text-align:center;vertical-align:top;border:1px #ffd700 solid;border-right:none;border-left:none;background-color:#ffffcc;width:600px;}

For added confusion, (more...)

Bin Fitting problems with SQL

“Bin Fitting” or “Bin Packing” means putting the greatest quantity in the smallest number of “bins” or containers. There are some good solutions with the MODEL clause, but the most concise and efficient solutions use the new 12c MATCH_RECOGNIZE clause. There are two categories of “bin fitting” problems: The number of bins is fixed and the […]