All articles

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(…)

Using Windows 2012 R2 & dynamic witness feature with minimal configurations

F I wrote a blog post some time ago about using a file share witness with a minimal windows failover cluster configuration that consists of two cluster nodes. In this blog post, I told I was reluctant to use(…)

Windows Server Next, AKA Windows Server 2016!

The first technical preview of the future version of Windows Server was, since last October, available (here) and a second one with more new features should be available in May. The final version which should be normally released(…)

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(…)