Search

Top 60 Oracle Blogs

Recent comments

August 2013

LAOTN Tour (Southern Leg) : GOUB…

The journey from Buenos Aires, Argentina to Sao Paulo, Brazil was quite straight forward. Just a 3 hour flight and I found myself in Brazil. I got one of the official taxis from the airport to the hotel, but if I told you the price you would think I had booked a private helicopter ride! Brazil is very expensive. :)

I dumped all my stuff in the hotel and took a walk around the shopping mall next door. Wow! This place is really expensive! If I lived here I would be skinny because I couldn’t afford to eat. :)

12c Join Views

There are a couple of posts on the blog describing problems with updateable join views or, to be more precise, join views which were key-preserved but which the optimizer did not recognize as key-preserved. Both scenarios are addressed in 12c:

Installing SQL*Developer on Debian Based Distributions

Oracle provide a free tool SQL*Developer that I rather like. Recently it has had a significant update to version 4 which is available as a beta/early adopter release at this link. The only slight difficulty is that unlike previous releases there is no zip or tarball of the installation. In my case I run Ubuntu […]

Manuals

Just glancing through the 12c manuals (Server Reference 12.1 June 2013 – E17615-16) to check a particular database limit, I came across the following: “Services – maximum per instance – 115″. That’s a bit of a problem, given that you can have 254 pluggable (tenant) databases in a single container database, and each plugged database gets its own service – but I’m guessing that that bit of the manual is wrong, after all it didn’t say anything about pluggable databases at all. It’s hard to keep documentation up to date as things change.

LAOTN Tour (Southern Leg) : ArOUG Day 2…

I was determined to get on a bus tour of Buenos Aires this morning. The plan was to do this yesterday, then spend this morning revisiting a few parts of the city in a bit more detail. Unfortunately, my inability to follow basic directions scuppered that plan… :)

So this morning I got myself to the tour bus and rode the loop of the city, taking photos as I went. You will see lots of blurred images and lots of pictures containing parts of the bus, but I don’t care because they are still good memories. :)

LAOTN Tour (Southern Leg) : ArOUG Day 1…

I arrived in Buenos Aires, Argentina late last night. The ferry ride from Montevideo took about 3 hours.

This morning I got a taxi to the ArOUG conference venue and did my first presentation of the conference. I was originally scheduled to do both my presentations today, then have tomorrow off, but Alex Gorbachev needs to leave earlier tomorrow, so I’ve swapped slots with him and my second presentation is now tomorrow afternoon.

Feeling adventurous, I decided to walk back from the conference venue. The directions seemed pretty straight forward, but I managed to get myself lost. I walked around for quite a while, thinking I must be close to the hotel, but not managing to find it. I eventually decided the only way to get back was to get a taxi. As I walked to find one, I noticed I was standing next to my hotel. Bonus!

LAOTN Tour (Southern Leg) : UYOUG…

The trip from Lima to Montevideo took quite a long time. First I flew back to Santiago, then from there to Montevideo, Uruguay. The drive from the airport to the hotel was pretty cool. It was dark, but we were driving along the coast and the city was all lit up. We arrived quite late, so we dropped off our stuff at the hotel and went out to eat.

12c Asynchronous Global Index Maintenance Part III (Re-Make/Re-Model)

As I discussed previously in Part I, the space occupied by orphaned row entries associated with asynchronously maintained global indexes is not automatically reclaimed by subsequent DML operations within the index. Hence the need to clean out these orphaned index entries via the various options discussed in Part II. However, a good question by Jason […]

AMIS presenteert: Twee-daagse Masterclass PL/SQL 12c door Steven Feuerstein

Steven Feuerstein, dé PL/SQL autoriteit, komt op 12 en 13 december naar AMIS in Nieuwegein. Twee dagen lang verzorgt hij een masterclass waar u intensief door hem persoonlijk gecoached wordt. Intensief en persoonlijk Normaal verzorgt hij seminars waar hij vanaf een podium voor een grote groep mensen presenteert. Nu hij een AMIS masterclass geeft ontstaat

Read More...

12c Asynchronous Global Index Maintenance Part II (The Space Between)

In Part I, I discussed how global indexes can now be asynchronously maintained in Oracle 12c when a table partition is dropped or truncated. Basically, when a table partition is dropped/truncated with the UPDATE GLOBAL INDEXES clause, Oracle simply keeps track of the object numbers of those table partitions and ignores any corresponding rowids within the […]