How to Gather SQL Resource Consumption Metrics in Oracle

Karen Morton on 26 April 2012 with 4 comments

The following video and set of resources are from the webinar broadcast by Red Gate on 8 May 2012. The video above is accompanied by the following downloadable resources: Presentation slides (.pdf) Resource Consumption Metrics Examples (.txt) Workload Repository SQL Report (awrsqlrpt_1_16411_16412.html) SQL Monitoring Report (0-6x2sh0kvzac0t-2.html) ASH Report for BIUAT/biuat1 (ashrpt_1_0505_1117.html) Download all resources (.zip) SQL is utilized to return… Continue Reading →

Free eBook: Expert Oracle Database Architecture

All Things Oracle on 23 April 2012 with 0 comments

Download your FREE eBook Expert Oracle Database Architecture (Apress Media) provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world’s foremost Oracle experts, Thomas Kyte. This fully revised second edition covers the developments up to Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only… Continue Reading →

Caching Part 2

Patrick Barel on 23 February 2012 with 5 comments

Never trust a computer you can’t throw out of a window. Steve Wozniak Deterministic Function Caching A function is considered deterministic if the outcome is the same if the input values are the same. Another thing is that the program should have no side effects. All the program changes are the return value and any out parameters. It is because… Continue Reading →

Caching Part 1

Patrick Barel on 14 February 2012 with 0 comments

To err is human, but to really foul things up takes a computer. – Farmers’ Almanac (1978) While programming in the Oracle Database you interact a lot with the data in the tables. Retrieving this data from the database involves context switching between the PL/SQL Engine and the SQL engine. This takes up a relatively large amount of time. You… Continue Reading →

Comparing Schemas: Red Gate Schema Compare for Oracle

Alex Nuijten on 26 January 2012 with 0 comments

This week I attended a webinar by Cary Millsap, organized by Red Gate. It was called “Real Developers DO use Tools” and was focussed on, well, tools. At the end of Cary’s talk, James Murtagh showed a demo of their Schema Compare tool. The demo wasn’t flawless, but he recovered nicely (note to self: don’t do live demo’s). And this… Continue Reading →

Invoker Rights Part 2

Patrick Barel on 25 January 2012 with 0 comments

Kindness is the beginning of cruelty Frank Herbert Syntax If you check the syntax for the different program objects you can see that the entire program is defined either using definer or invoker rights. The default is definer rights, so if you don’t supply the clause, the program will be defined using definer rights. This means you don’t have to… Continue Reading →

Timing in PL/SQL

Patrick Barel on 06 January 2012 with 0 comments

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. The PLVTMR package relies on a… Continue Reading →

Invoker Rights Part 1

Patrick Barel on 08 December 2011 with 2 comments

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. The… Continue Reading →

How to make comments the most important ‘code’ you write

David Njoku on 23 November 2011 with 3 comments

80% of all communication, it is often said, is nonverbal. The actual percentage is disputed – with experts quoting figures that range from 50% all the way up to 93% – but what is not in dispute is the fact that what is left unspoken is often as important as what is said. An almost direct parallel can be drawn… Continue Reading →

An interview with…Steven Feuerstein

Gert Poel on 10 November 2011 with 0 comments

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. But… Continue Reading →