Development & Performance Variations on 1M rows insert(2): commit write – PostgreSQL 04.05.2015 by Daniel Westermann Franck was quite fast with his second post Variations on 1M rows insert(2): commit write. Lets see what we can do on the PostgreSQL side. I’ll take the same test table as Franck again: create(…)
Development & Performance Variations on 1M rows insert (1): bulk insert – PostgreSQL 04.05.2015 by Daniel Westermann When I read Franck’s post about Variations on 1M rows insert (1): bulk insert I thought doing quite the same in PostgreSQL might be interesting. Lets start by using the same test tables, one using a primary(…)
Enterprise content management QlikView – Load data in QlikView / QlikSence – Best practice and trick 14.04.2015 by Alain Lacour In this blog, I will give you some best practices and tricks when you are loading table to generate your data. But before, I will review the different ways to load data in a QlikView or QlikSense report. 1.How to(…)
Hardware & Storage, Oracle Yesterday’s AWR Straight to the Goal 14.04.2015 by Oracle Team 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(…)
Database management, Oracle Cloning a PDB from a standby database 13.04.2015 by Oracle Team By Franck Pachot . Great events like IOUG Collaborate is a good way to meet experts we know through blogs, twitter,etc. Yesterday evening, with nice music in the background, I was talking with Leighton Nelson about cloning PDB(…)
Operating systems, Oracle RAC Attack! was another great success at C15LV 12.04.2015 by Oracle Team By Franck Pachot . The RAC Attack – install a RAC in your own laptop – is a great success at Las Vegas. The idea is to help people follow the RAC Attack cookbook which is available at:(…)
Database management, Oracle Dbvisit replicate REDO_READ_METHOD 09.04.2015 by Oracle Team By Franck Pachot . A frequent question about replication is the overhead in the source, because in a lot of cases the source is production. Dbvisit replicate comes with the possibility to do the minimum on the source: only(…)
Database management, Oracle DataGuard wait events have changed in 12c 08.04.2015 by Oracle Team By Franck Pachot . There are several new features in 12c about Data Guard: cascaded standby, far sync instance. But there are also some architecture changes: new processes and new wait events. Here is an example of an(…)
Enterprise content management QlikSense – The easy way to create a QlikView report 07.04.2015 by Alain Lacour Today, one of the most used Business Intelligence products is undoubtedly QlikView. This Swedish product is one of the best positioned in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms matrix and has been for a number of(…)
Database management, Oracle Oracle tuning silver bullet: add an order by to make your query faster 01.04.2015 by Oracle Team By Franck Pachot . You have read all Cary Millsap work about Oracle database performance tuning. You know that there are no silver bullets. Reducing the response time requires a methodical approach in order to analyze the response time(…)