I took some notes and screenshots whilst I installed Oracle Business Intelligence Enterprise Edition 11.1.1.3.0 in an 11gR2 database running on Oracle Enterprise Linux 5.5…they are on the wiki section here. The installation was on a Virtual Machine running in VMWare Workstation 7.1. Comments and corrections welcome.
Archive of posts tagged dba
$deleted$ tablespace names bug
This one turned out to be a an interesting bug the other day… I did a simple select from DBA_TAB_PARTITIONS and noticed that some tablespace_names were of the form “_$deleted$n$m” where n and m are numbers. Slightly worrying, but at least the data was all present and correct, when I checked. I knew the DBA [...]
No pruning for MIN/MAX of partition key column
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 2009, with data in all [...]
Installing Oracle 11gR1 on a Fedora Core 10 64 bit VM
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 [...]
Scripts for loading up DBGEN TPC-H data
If you’re interested in creating a TPC-H schema for testing purposes, then the following scripts may be of use to you: Unix Scripts:Multi Load TPCHLoad TPCH Stream SQL*Loader Control files:REGION TableNATION TableSUPPLIER TableCUSTOMER TablePART TablePARTSUPP TableORDERS TableLINEITEM Table You may wish to read and check them before you use them – they’re not exactly rocket [...]
Creating a TPC-H schema with DBGEN on HP-UX
I wanted to try out this HammerOra product from Steve Shaw, both at work and on my box at home…but after playing with it at home, I realised that it takes quite some time to build even a small (scale factor 1) TPC-H schema…I know it runs serially, but I’m still not quite sure why [...]
Problem with _gby_hash_aggregation_enabled parameter
Here’s a tale about an Oracle initialisation parameter…and a lesson we should all take note of… For three days, my colleagues in the support team on one of the warehouses I’m involved in, were struggling with a piece of code which was exhausting the available temp space and after trying everything they could think of, [...]
Tracking TEMP usage throughout the day
I really wanted to do this via AWR, but I’ve not been able to find out if this kind of information is stored and, if it is, how I’d get access to it…maybe someone else knows…hint hint?! I have various queries I run whilst I’m online and processes are running, but what I really wanted, [...]
CALIBRATE_IO Poll
After Doug’s comment on my earlier blog on CALIBRATE_IO, and after seeing Kevin using Mr Poll to do a RAC poll, I’ve now created a poll for the results people are getting from this CALIBRATE_IO routine in 11g. If you’d like to contribute please visit using the following link: Oracle 11g CALIBRATE_IO Results No prizes [...]