Database management, Oracle Variations on 1M rows insert (1): bulk insert 18.05.2015 by Oracle Team 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(…)
Operating systems Using Windows 2012 R2 & dynamic witness feature with minimal configurations 18.05.2015 by Microsoft Team 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(…)
Technology Survey Windows Server Next, AKA Windows Server 2016! 18.05.2015 by Stéphane Savorgnano 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(…)
Database management, Oracle A migration pitfall with ALL COLUMN SIZE AUTO 18.05.2015 by Oracle Team 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(…)
Database management, Oracle List listeners and services from the instance 18.05.2015 by Oracle Team 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(…)
Database management, Oracle ALTER TABLE INMEMORY 18.05.2015 by Oracle Team 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(…)
Database management, Oracle C15LV: Nothing to BLOG About – Think Again 18.05.2015 by Oracle Team 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,(…)
Database management, Oracle SQL Monitor report little improvement in 12c 18.05.2015 by Oracle Team 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(…)
Database Administration & Monitoring Get the main information from Windows Server with PowerShell 18.05.2015 by Nathan Courtine This blog will present you a way to retrieve Windows Server main information via PowerShell. The goal is to be able to automate the extraction of information for different purposes: audit, report generation, dashboards… Disclaimer: I am not a(…)
Development & Performance bulk loading semi structured data in postgresql 10.05.2015 by Daniel Westermann The last post took a look at how to efficiently load 1m rows into a table in PostgreSQL. In this post I’ll take a look on how to do the same with semi structured data.