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...)