Back from two weeks of vacation I noticed that the schedule of the next OpenWorld is available here.
The detailled information about my session, which is based on chapter 10 of my book, is the following:
This presentation explains how the query optimizer joins multiple sets of data to each other. First it explains the operation [...]
A reverse engineering example:
"Tracing connection between TDW_NOCOMPRESS SAPGUI environment variable to bothering window and actual data compression routine."
Hello Dear Readers,
As promised in June, we are back with the latest refreshing
issue of Oracle Connect - Oracle Newsletter with current
topics surrounding Oracle APEX, Oracle BI (OBIEE) and
Oracle connect newsletter July, 2010 issue
Don't hesitate to send us your valuable feedback to:
Perhaps you were introduced to Apex in a similar way to me. When I started using Apex, I was pleased to see a good selection of simple themes and templates I could use straight away. There was no need to worry about creating a consistent look-and-feel across my applications, I could dive right into building [...]
Following on from my previous post, I’m rapidly reaching the conclusion that the CASE statement is, well, a little bit touchy. First off, here’s a quick recap or you can have a look here.: create table final_four ( team varchar2(30) NOT NULL, winners VARCHAR2(30), runner_up VARCHAR2(30), third VARCHAR2(20), fourth VARCHAR2(20), best VARCHAR2(30)) / insert into [...]
I just completed upgrade to 11gR2 for a test and small reporting database. This time I used DBUA (recommended) versus the manual process.
In my next blog series, I will explore four key roles that leaders play in business: Conceptuaizers Strategizers Actualizers Maximizers When you boil it down, these four roles capture the essence of leadership. Leaders in all realms of leadership spend a great deal of time doing things that fit one of these four areas: Conceptualizing [...]
Sometimes it is necessary to automatically trigger SQL trace. Automatically here means that code must be added somewhere.
The simplest approach is to create a logon trigger at the database level. To avoid enabling SQL trace for all users, I usually suggest creating a role (named sqltrace in the following example) and temporarily granting it only to the user utilized for the test.!-->!-->
Systemtap is a scripting language for analyzing linux systems. Systemtap needs debuginformation to be able to know what is going on. Systemtap is considered the “answer” to Sun/Oracle’s DTrace. Systemtap and DTrace differ, most notably because DTrace doesn’t need additional software (debug information) for both kernel and userspace. Let’s see how Systemtap can be installed [...]
I’ve got this USB memory stick which I use to carry around my scripts, documents, presentations, Oracle manuals and enough music to keep me going for a few days. It is on an 8GB Gizzmo Junior and it is tiny. By tiny I mean as wide as my little finger, the length of a matchstick [...]