If you’re starting to work with Exadata you need to work out what how much impact you can have by doing the right (or wrong, or unlucky) sorts of things with the technology. Fortunately there are only a few special features that really need investigation: Hybrid Columnar Compression (HCC), Offloading (and related Smart Scan stuff) and Storage Indexes. These are the features that will have the biggest impact on the space taken up by your data, the volume of data that will move through your system as you load and query it, and the amount of CPU it takes to do something with your data.
My DBA friend Dejan from Baze Podataka database related site wrote post about Oracle Bug 8943287 which reminded me how dangerous bug this is. I was completely unaware about this bug till few months ago.
Pythian was a sponsor of this year’s Oracle Partner Golf Tournament which took place July 9th at the Eagle’s Nest Golf Club in Vaughan Ontario. Grand Prize winners of 4 Apple TVs for highest team points are: Bradley – Oracle James CIBC Gaetan, CIBC Mark, CIBC They putt 31 points with a hockey stick – [...]
The other day I was writing a query for my Apex application and I required an outer join. In this case I decided to use the ANSI syntax, and out of habit I used a scalar subquery to reference an application item:
select col1, col2 from my_table a left outer join my_other_table b on a.id = b.id and b.sub_id = (SELECT v('F_SUB_ID') FROM DUAL)