Skip to content

Author Archives dombrooks

Temp Usage

Some observations on a system’s usage of TEMP. There’s no conclusion or revelation here – just some notes. The graph below shows the average read times against temp table space from the one hour snap intervals captured from a week’s worth of statspack reports (obviously system-wide averages showing a system-wide trends). To summarise, a variation [...]

Posted 08 September 2010 § Uncategorized ‡ Comments Off °

GLOUP

GLOUP = Group of London Oracle Users in a Pub? Would anyone be interested in the occasional gathering of like-minded Oracle-focused people for a beer? What do you think? Good idea? Any interest? Could it work? I’m thinking something after work for a couple of hours. I’m thinking possibly in the function room (free?) of [...]

Posted 06 September 2010 § Uncategorized ‡ Comments Off °

Just the job

Yesterday I finished the week in a right, stinking mood. I’d done a bit of work on a DIY stats gathering procedure which used DBMS_JOB to split up the work into N parallel streams (Oracle 9i). Then I was told that DBMS_JOB was not certified by the DB Engineering team for use in any environment [...]

Posted 04 September 2010 § Uncategorized ‡ Comments Off °

Call that support

My severity 3 ticket with Oracle Support has been waiting for a response since I uploaded the requisite trace files on 14th July. My regular updates asking why are getting more and more sarcastic but still no response. I’m thinking, almost hoping for Oracle Support’s sake, that it must be a system problem. That the [...]

Posted 11 August 2010 § Uncategorized ‡ Comments Off °

Upgrade experiences

I’m planning for an Oracle upgrade, 9i to 11gR2. Cross-platform – Sun Solaris to Linux. Different Endian. It’s just under 1TB so not big these days. Downtime shouldn’t be too much of an issue. It’s not like it needs to be done in an hour or anything demanding like that. As long as it can [...]

Posted 10 August 2010 § Uncategorized ‡ Comments Off °