Search

Top 60 Oracle Blogs

Recent comments

January 2013

Dune Messiah…

Dune Messiah is the second in the Dune series written by Frank Herbert.

I got a few warnings from people that the sequels to the original book were not so good. I have to admit it lacks the direction and thrust of the first book, but it wasn’t as bad as I was expecting. In fact I actually quite enjoyed it. It does ramble a bit at times, but it was nice to see some of the other characters getting fleshed out a bit.

This book and the next book, Children of Dune, were combined into the Children of Dune TV mini series. Having seen that, I’m expecting Children of Dune to be a bit random. We shall see. :)

Cheers

Tim…

EXCHANGE PARTITION those pesky columns

 

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 I can then use to perform an exchange partition operation.

SQL> create table EXCH as
  2  select * from PAR
  3  where 1=0;

Table created.

Webinar - Understanding Oracle Optimizer Statistics

Embarcadero is sponsoring another Oracle Community webinar on January 29  (rescheduled) February 5 conducted by yours truly. Register for Understanding Oracle Optimizer Statistics and join me as I cover

Fedora 18 : The winner is MATE (so far)…

I’m a few days into Fedora 18 and I think I’ve come the the conclusion that the desktop that best suits *me* is MATE. The journey to this point has been a rather long and meandering one. Let’s cut it short and start at GNOME2.

Enkitec E4 2013

The 2nd annual Enkitec Extreme Exadata Expo (E4) is coming your way August 5-6, 2013 at the Four Seasons Hotel & Resort in Irving, TX. Last year's inaugural event received rave reviews from participants and this year's event should be even better!

After the conference, stick around and join me for a 3-day SQL/Exadata Performance Intensive course. I'll be covering how to approach optimizing SQL in both Exadata and non-Exadata environments. We'll start with some fundamentals that apply to how to approach tuning SQL in general and then look at how your focus needs to shift to take advantage of Exadata specific features.

Find and follow Enkitec in your favorite social media outlet to keep up with E4 news and lots more.

EvDBT » Page not found

Japanese translation of some of my blog articles

Ryota Watabe has translated some of my articles into Japanese and intends to translate more in the future (thanks for that! :)

I have added a little “translations” section to the left sidebar of the blog (scroll down). Or just go to this link:

You might also want to follow Watabe-san on Twitter to get notified of any new Japanese translations that show up.

If you want something done, ask a busy person…

New post on the ODTUG Board page…

dbms_xplan bug

Here’s a very long post (which is mainly an example) demonstrating a little bug in the “explain plan” functionality. It’s a variation of a bug which I thought had been fixed in 11g, but it still appears in some cases. Take a look at this execution plan, which comes from explaining “select * from dba_tab_cols” – the bit I want to emphasise is in lines 1 to 10:

Fedora 18 : Upgrading from Fedora 17…

I’ve just got to the end of a real upgrade of a Fedora 17 server to Fedora 18. The basic process goes like this.

  • Download the Fedora 18 ISO.
  • Update your current Fedora 17 system by issuing the “yum update” command and restart once it is complete.
  • Install the “fedup” package. “yum –enablerepo=updates-testing install fedup”
  • Run the fedup command pointing it to the Fedora 18 ISO you downloaded. “fedup-cli –iso /home/user/fedora-18.iso –debuglog=fedupdebug.log”
  • Check for errors in the log and correct if found.
  • Reboot the machine and select the “System Upgrade” option from the Grub menu.
  • Wait!

The system came up OK after this, but there are some gotchas. The first thing I did on completion was to run a “yum update” and lots of things were broken. Why? Well, after a lot of messing around and manually updating individual packages I finally figured out: