Here is a series of Oracle performance tuning videos that I put together recently at Delphix. All the presentations are free and open to the public, just have to register.
Successfully managing a modern organization’s complex data estate requires careful work at multiple layers, from the implementation of organization-wide data policies and platforms to the careful tuning of particular databases. Only with optimization at every level can data achieve its full potential, enabling the (more...)
I recall that the Dec 1999 or Jan 2000 issues of Nat’l Geographic magazine had a “Letters From The Editor” column that speculated, in jest, that the rate at which humans were saving back-issues of Nat’l Geographic magazine, would by the year 2100 result in the total accumulation of yellow magazines outweighing planet Earth.
Anyway, that statement resonated with me, because although I change residences every few years, it has only been (more...)
John Beresniewicz and I worked hand in hand on developing the performance pages in Oracle Enterprise Manager. John is one of the foremost experts on active session history (ASH) queries and he has recently posted some of his presentations on ASH to slideshare:
People ask me to justify use of Delphix. I can understand. Delphix is pretty new and often, most of my friends who are DBAs respond with “I can copy a database, so what, I can do it a little faster with Delphix.” Well that’s missing the whole boat. The question won’t be why you should use Delphix but “can you justify working without Delphix?”
I see Delphix as amazingly positioned at nexus of data (more...)
There was a problem at a customer in application development where using full copies for developers and QA was causing excessive storage usage and they wanted to reduce costs , so they decided to use subsets of the production development and QA
Data growing, storage costs too high, decided to roll out subsetting
App teams and IT Ops teams had to coordinate and manage the complexity of the shift to subsets in dev/test
One of my pet peeves on Oracle is the inability to find out what SQL took out a lock that another user is waiting. It’s easy to find the waiting user and their SQL with v$session by looking at v$session.event where the event is an “enqueue” (v8 and v9) or “enq: TX – row lock contention” and then looking up their SQL via the v$session.sql_hash_value which joins to v$sql.hash_value for the v$sql. (more...)