Learning is not a spectator sport

In April I’m off to that famous conference that so many speak about with affection… The conference on a cruise ship ! There’s a great line up of speakers – if you get a chance, please come along. http://www.ougn.no/vrseminar-2013 Read more

Here is my partitioned table SQL> desc PAR Name Null? Type —————————– ——– ———— X NUMBER(38) Y NUMBER(38) and it has a couple of partitions SQL> select partition_name 2 from dba_tab_partitions 3 where table_name = ‘PAR’; PARTITION_NAME —————————— P1 P2 So now I want to do the standard operation of creating a ‘template’ table which Read more

We’ve all done that common administrative task of: – find the HWM in a datafile – resize the datafile down to that mark. But sometimes, you might get what appears to be a problem: Here’s a tablespace I created a while back… SQL> create tablespace DEMO 2 datafile ‘C:\ORACLE\ORADATA\DB112\DATAFILE\DEMO.DBF’ size 100m 3 extent management local Read more

Recently, I was creating an IOT from an existing table via, and wanted to achieve it without logging. You cannot do this in two steps (ie, create table, followed by insert-append) because it will still be logged (see the addenda at the end of this post) So you need to do it with a CTAS, Read more

Starts tomorrow everyone… Its about the biggest list of international names Perth has ever seen at the conference: Tom Kyte (of asktom fame) Graham Wood (ever used Statspack, ASH ?, …. well, this is the guy you should be sending a “Thank you” card to) Melanie Caffrey (regular inside Oracle magazine) the list goes one. Read more

Thanks to all those people that attended my session last week at OpenWorld. A number of people have asked for copies of the slides.  I will post them here as soon as I get back home to Perth. Thanks for your patience. ….Posted from yet-another-airport-kiosk 🙂 Update: Slides below OOW slides Read more

Its the penultimate day at openworld First up was Gwen Shapira’s (http://www.pythian.com/news/author/shapira/) talk on Big Data and its integration into the "enterprise" and database.  This was perhaps the most relevant of big data talks this week, because I imagine anyone at an Oracle conference already has some (significant) investment in what could be called "conventional" Read more

Yesterday was another day of good quality sessions at OpenWorld.  Yes its true that there are many sessions that could only be described as pure marketing, but with a little effort, there are gems in the agenda ! It started with partitioning facilities that are coming in 12c. Interval/Reference partitions will be supported, although no Read more

Yesterday I went to a presentation on histograms in 12c.  A number of good improvements made there by Oracle coming in 12c. Particular emphasis seems to be placed on some of the short comings of height balanced histograms.  In 12c, we will have TOP-N histograms (where the "top scorers" get their own frequency bucket, and Read more

The ACE director briefings are over and Oracle Open World has kicked into full swing.  The scale of the event is staggering and its a challenge just finding sessions to go to.  This is not due to insufficient sessions – just the challenge of sifting through 100+ concurrent sessions, spread across multiple locations and timeslots… Read more