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 [...]
Archive of posts tagged bugs
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 [...]
Cursor keys not working in Virtual Server 2 VM
Posted as a reminder to myself about how to fix this issue… I couldn’t get some of the cursor keys to work properly on my virtual machines running under VMWare Virtual Server 2 on Fedora 10 x86_64. Kept giving funny behaviour like bringing up the screen capture applet! A bit of searching the net came [...]
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, [...]
DBA_SEGMENTS misleading PARTITION_NAME column
Whilst writing some code that referenced the DBA_SEGMENTS dictionary view today, I realised that the contents of the PARTITION_NAME column actually contains the name of the subpartition when the table is a subpartitioned table…a script and results to illustrate: drop table jeff_unpartitioned purge/drop table jeff_partitioned purge/drop table jeff_subpartitioned purge/create table jeff_unpartitioned(col1 number,col2 number)/create table jeff_partitioned(col1 [...]
Partition exchange loading and ORA-14097
Continuing the theme of this post by Howard, I came across a scenario today which was resulting in this error: ORA-14097 – column type or size mismatch in ALTER TABLE EXCHANGE PARTITION I ran my checker script to try and identify exactly what the mismatch was but it came back with nothing. My script, whilst [...]
10gR2: OBJECT_NAME missing from V$SQL_PLAN for INSERT statement
I’d written a query the other day to try and identify SQL statements that had been run which wanted a certain degree of parallelism (DOP) and had either run with less than the requested amount of PX slaves or had run serially – in order that we could identify whether the (poor) performance of a [...]
V$SQL_PLAN bug in 10gR1
I’ve been working on trying to determine where long running queries are at and came across a problem today with V$SQL_PLAN on HP-UX 10gR1(10.1.0.4.0) that I thought I’d share with you… Essentially, I was trying to go into V$SQL_PLAN for the problem query, joining up the PARENT_ID and ID columns using CONNECT BY when I [...]