Session SQL

Jonathan Lewis on 17 February 2012 with 0 comments

From time to time a request for a query to “show the current SQL” for each session appears on the internet. It’s not really difficult to write something suitable, but this particular request is an interesting demonstration of how much inertia there is in the Oracle world. Here’s a recent suggestion of what the query should look like: select sess.sid,… Continue Reading →

E-Business Suite and APEX

Dimitri Gielis on 15 February 2012 with 0 comments

There is a series of posts on my blog where I focussed on getting information out of E-Business Suite and use it in my APEX application. This is especially useful for people using APEX. Here is a complete overview of those posts: Calling EBS Webservices from APEX Using EBS Open Interface from APEX Debugging EBS API calls in APEX Updating EBS data… 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 →

Dynamic Sampling (I), an Introduction – Part 2

Randolf Geist on 08 February 2012 with 0 comments

If you follow me on my blog you might wonder if I let you get away without an actual test case, and of course I won’t do so. Here is a simple test case that demonstrates Dynamic Sampling in action: set echo on timing on time on drop table t; purge table t; — Create a sample table create table… Continue Reading →

Migrating databases to new storage

Steve Harville on 06 February 2012 with 1 comments

This was a last minute request to move five databases on two servers from an old failing storage system to a new one. There was a total of 5.6 terabytes to move and the databases were in heavy use by the development team. The DBA who usually supported these systems was unavailable so I started working with the storage team… Continue Reading →

Trouble in the Server Room Puzzle

All Things Oracle on 03 February 2012 with 3 comments

My apple core puzzle in December seemed to go down well with our mathematical-minded audience so I’m planning on putting up a monthly puzzle. This month’s puzzle will challenge your problem solving skills… Trouble in the server room Here at Red Gate central we have a pretty simply layout for our server room. The 9 servers are laid out on… Continue Reading →

Applied Rapid Development Techniques for Database Engineers

Dominic Delmolino on 31 January 2012 with 2 comments

This article is based on the webinar delivered on 22 Nov 2011. You can read the full article below including the Q+A or: Download a PDF version Watch a video recording: Applied Rapid Development Techniques for Database Engineers In this article, Dominic Delmolino describes his experience in implementing a rapid refactoring and professional schema management process using standard software development… Continue Reading →

Dynamic Sampling (I), an Introduction – Part 1

Randolf Geist on 30 January 2012 with 0 comments

Welcome to my first post on AllThingsOracle.com! This is the initial part of a series highlighting different aspects of “Dynamic Sampling”. So what is Dynamic Sampling? Probably most of you have already heard of it as a feature that deals with tables that don’t have any statistics gathered for – so it’s a feature of the Cost-Based Optimizer that has been… 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 →