Oracle Team

Rebuilt index on increasing values after deletes?

By Franck Pachot . Yesterday while giving our Oracle tuning workshop I discussed with the customer about a job they have that rebuilds indexes every Sunday. Except in very rare cases Oracle indexes are maintained so that free(…)

Variations on 1M rows insert (3): TimesTen

By Franck Pachot . In the previous blog post I measured how inserting 1 million rows takes 5 minutes instead of 45 seconds when we commit at each row inserted. In Oracle we can improve that down to(…)

Variations on 1M rows insert(2): commit write

By Franck Pachot . In the previous blog post I measured the time it takes to insert 1 million rows. About 45 seconds when done row-by-row which goes down to 7 seconds when inserted in bulk. In both(…)

Variations on 1M rows insert (1): bulk insert

By Franck Pachot . This blog is the first one of a series about inserting 1 million rows. Do you have an idea about the time it takes? The idea came from another project, about NoSQL databases, but I’ll(…)

A migration pitfall with ALL COLUMN SIZE AUTO

By Franck Pachot . When you migrate, you should be prepared to face some execution plan changing. That’s not new. But here I’ll show you a case where you have several bad execution plans because lot of histograms are(…)

List listeners and services from the instance

By Franck Pachot . Want to know all your listeners – including scan listeners, and the services it listens for? It is possible from the instance, with the – undocumented – view V$LISTENER_NETWORK which is there since 11.2 Let’s(…)

ALTER TABLE INMEMORY

By Franck Pachot . In-Memory Column Store is amazing. It brings very good performance to full table scans. I’t easy: just ‘flip a switch’ and you accelerate all reporting queries on your table, without thinking about what to index(…)

C15LV: Nothing to BLOG About – Think Again

By Franck Pachot . Before going to the airport to come back in Europe, the las session I assisted at IOUG Collaborate is a panel: Nothing to BLOG About – Think Again Some famous bloggers were there to help,(…)

SQL Monitor report little improvement in 12c

By Franck Pachot . This is a very short post about something I though I had already blogged about. I like SQL Monitoring active reports. The are graphical, and still very light. There is only one thing I don’t(…)

Yesterday’s AWR Straight to the Goal

By Franck Pachot . Yesterday I was a speaker at Collaborate15 and did my presentation about reading an AWR report. That was great. Many people (and not enough seats). Here are some aswers about questions that came later. I(…)