Just a note, to myself more than anything, about what extra packages are required by a 64 bit installation of Fedora Core 10, when trying to install Oracle 11gR1. The installation I undertook was on a FC10 64 bit VM running under VMWare Server 2.0 running on top of FC10 64 bit OS. Tim, as [...]
11g IO Calibration tool
After reading how inadequate Doug was feeling over his IO subsystem, I decided to see how quick mine was…not that we’re getting into a “mine is better than yours” game, but rather to see how mine stacks up against Doug’s, bearing in mind his is a 5 disk stripe natively attached to his machine (I’m [...]
ORA-07455 and EXPLAIN PLAN…and statements which, perhaps, shouldn’t run
I encountered a scenario today which I thought was strange in a number of ways…hence, irresistible to a quick blog post. The scenario started with an end user of my warehouse emailing me a query that was returning an error message dialog box, warning the user before they ran the query, that they had insufficient [...]
Changing the subpartition template and pre-existing partitions
My colleague Tank could not insert some records into a subpartitioned table the other day as he kept getting an ORA-14400 error and couldn’t work out why – nor could I straight away until he mentioned the possibility that the subpartition template had changed on the table…which it had. Lets try and work through the [...]
Oracle 10gR1 on HP-UX – tracefile errors and DBMS_SCHEDULER
A couple of interesting Oracle 10gR1 on HP-UX issues I’ve come across in the past couple of days – ably assisted by a few of the Eon (Powergen) Team members (Phil Bridges, Tahir Mahmood and Zaheer Mahmood): Firstly, we were seeing a line in the trace files on our databases which looked like:Ioctl ASYNC_CONFIG error, [...]