Some time ago I pulled off the apocryphal “from 2 hours to 10 seconds” trick for a client using a technique that is conceptually very simple but, like my example from last week, falls outside the pattern of generic SQL. The problem (with some camouflage) is as follows: we have a data set with 8 “type” attributes which are all mandatory columns. We have a “types” table with the same 8 columns together with two more columns (more...)
Red Samurai ADF Performance Audit Tool v 3.4 – ADF Task Flow Statistics with Oracle DMS Servlet Integration
DMS Spy Servlet context is accessed in certain intervals and we are not only displaying DMS data, but storing (more...)
Implemented features in v 3.3:
1. Logging audit data from multiple WebLogic servers
Audit is improved to log data from several WebLogic servers into the same (more...)
This is the second part of a series of blogpost on Oracle database PGA usage. See the first part here. The first part described SGA and PGA usage, their distinction (SGA being static, PGA being variable), the problem (no limitation for PGA allocations outside of sort, hash and bitmap memory), a resolution for Oracle 12 (PGA_AGGREGATE_LIMIT), and some specifics about that (it doesn’t look like a very hard limit).
But this leaves out Oracle version (more...)
Well, this blog posting is not about explaining the (more...)
|Ver este articulo en Español|
This is THE MySQL performance book. Period!
|Ver este articulo en Español|
During the past week I had the opportunity to assist both the Oracle Performance Firefighting and the
Advanced Oracle Performance Analysis and only can say: awesome!!!
Craig Shallahamer is a great teacher and has a lot of resources to effectively share knowledge, even if
the subject is complex like buffer cache structures or arid like the mathematical foundation required for
perf analysis. That is not all, he provides valuable tips of the trade or anecdote nuggets, dipped on a
very fresh and sometimes humorist perspective.
The result: we started searching for those (more...)
Tuning has always being good fun and something like a challenge for me.
From time to time we are being asked to find out why something did run slow while you are sleeping; answering this question is, in most cases, a challenge.
My batch did run slow last night, can you let us know why? Or why did this query run slow? Are questions we, as DBAs, have to answer from time to (more...)
I regret not being able to write new things more often, but in fact it only means I am OK: very busy with work, doing private stuff (which is important since life is not all about working), enjoying the three young kids and trying to achieve some good results in track and field. And for that last goal, I can say I did. After a few months of struggling to find a tiny piece of shape comparable to last years shape, just in time I found it. I won the gold medal in the Dutch Championships 400 metres hurdles. OK, be (more...)
Recently, I wanted to work out the maximum value of a column on a partitioned table. The column I wanted the maximum value for, happened to be the (single and only) partition key column. The table in question was range partitioned on this single key column, into monthly partitions for (more...)
My primary skills are in troubleshooting and tuning Oracle systems, from entire databases to individual SQL queries.
If you have an application running on an Oracle database and you need someone to investigate an issue on that system, get in touch.
"My name is Peter Moore. I am a professionally qualified and highly experienced database administrator with extensive (more...)