19 January 2012
19 January 2012

DBA Monitoring Top Five

0
Have you ever just sat there watching all of the processes running against the database, just waiting for something to happen? Of course not! We are database administrators, architects, developers and we don’t have time for that! We also might get bored wondering why there seems to be millions of the same query running against the database – a discussion… Read more
10 January 2012
10 January 2012

Introduction to Materialized Views: Query Rewrite

2
In the fairy tale, The Shoemaker and The Elves, a poor cobbler works to the best of his ability; and somehow, when he isn’t looking, magical beings would sneak in and polish and perfect his handiwork. It seems the people at Oracle are up on their fairy tales. Perfectly-tuned queries are the Holy Grail to developers and DBAs; we ar… Read more
06 January 2012
06 January 2012

Timing in PL/SQL

0
In my current project I wanted to add some timing to the logging the code already does. So I started my search for a good timing package. My first idea was to download PL/Vision and use the timer that is in there. Installing this was not as simple as I hoped it to be.… Read more
05 January 2012
05 January 2012

Using a database link with heterogeneous services in APEX

0
Last weeks I ran into some issues with APEX, so let’s take some time to write something about them. The most recent is about heterogeneous services (also referenced as HS). Here is the case: We have an Oracle DB instance with some APEX applications and in one of those applications I need data from a MS SQL server database. Not… Read more
20 December 2011
20 December 2011

The Ramp

0
I love stories about performance problems. Recently, my friend Debra Lilley sent me this one: I went to see a very large publishing company about 6 months after they went live. I asked them what their biggest issue was, and they told me querying in GL was very slow, and I was able to fix quite easily. (There was a… Read more
16 December 2011
16 December 2011

Indexes are Tables

0
Oracle’s optimizer has many strategies for acquiring the data you want with the minimum of work. Some of these strategies are really quite subtle and sophisticated – think of the Star Transformation, for example, which uses a two-phase approach to dimension tables; or the Index Join which does hash joins between indexes to avoid visiting tables. Despite all the clever things… Read more
15 December 2011
15 December 2011

Expert Oracle Application Express Plugins

0
One of the most anticipated new features that was introduced in APEX 4.0 was the ability to create your own APEX objects using the plugins framework. Since plugins were new when 4.0 was released there were just a handful of examples available online to help you learn how to create them. Today I’m pleased to announce that there’s a new… Read more
09 December 2011
09 December 2011

Simple Bar Chart Reports with SQL Developer

1
There are many good articles out there that go into detail for creating reports with Oracle SQL Developer. I was reading my predecessor’s write up in Oracle Magazine (May 2007) on the subject, and keyed into the following snippet: Building a Chart When creating a report with the Chart style, the rule of thumb is to use SELECT group, series,… Read more
08 December 2011
08 December 2011

Invoker Rights Part 1

0
Truth suffers from too much analysis. Frank Herbert In the Oracle database you have a choice of two models for executing the PL/SQL code. The default model (and the only one available until Oracle 8i (8.1.7)) is the Definer Rights model. When using this model the program executes under the authority of the owner (or creator) of the program. T… Read more
16 November 2011
16 November 2011

SQL Developer Data Modeler Quick Tip: Use SubViews

0
Modeling is cute when you’re in a class and the sample application is for a rotisserie league for fantasy football, or you need a shopping cart ordering system for online retail. You spend a few hours and might come up with several dozen tables. But what about in the real world when you are trying to wrap your head around… Read more
14 November 2011
14 November 2011

Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2

0
This article on ORACLE-BASE describes the installation of Oracle Database 11g release 2 (11.2 64-bit) RAC on Linux (Oracle Enterprise Linux 5 64-bit) using VMware Server 2 with no additional shared disk devices. The article is arranged in the following sections: Introduction Download Software VMware Server Installation Virtual Machine Setup Guest Operating System Installation Oracle Installation Prerequisites Install VMware Client… Read more
11 November 2011
11 November 2011

Which of these things is not like the other?

0
Have you ever played the game where you try to identify the differences between two side-by-side seemingly-identical pictures? Sometimes answering the question “why does my query perform well in development, but it drags in test and production” is the same sort of game: you must identify where your environments differ, either obviously and subtly, then weigh those differences to determin… Read more
10 November 2011
10 November 2011

An interview with…Steven Feuerstein

0
Some time age one of my colleagues, An V., played with the idea to start a company magazine. Everybody liked the idea and our manager gave a green light to create “De Poreiflash”. Why it’s called “De Poreiflash” is a long story and I have to kill you when you don’t work for iAdvise and I tell you this%hellip; … Read more
31 October 2011
31 October 2011

Dynamic Show/Hide in APEX

0
Understanding is required before success is possible [Dune] old Orange Catholic Bible When you want to hide and display certain regions in an APEX based application based on the selection of the user, for instance when a button or a link is pressed then you can of course use the Region Display Selector, but this takes up a region on… Read more
21 October 2011
21 October 2011

APEX-Challenge.com

0
A few months ago we (APEX Evangelists) launched the APEX Challenge, a weekly quiz where you get a question about Oracle Application Express. Next to the fun of answering the questions and see your rank, you will hopefully learn something.… Read more