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 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(…)
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(…)
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(…)
Database management, Oracle Index on SUBSTR(string,1,n) – do you still need old index? 27.03.2015 by Oracle Team By Franck Pachot . In a previous post I’ve shown that from 12.1.0.2 when you have an index on trunc(date) you don’t need additional index. If you need the column with full precision, then you can add it(…)
Database management, Oracle Standard Edition on Oracle Database Appliance 25.03.2015 by Oracle Team By Franck Pachot . The Oracle Database Appliance is really interresting for small enterprises. It’s very good hardware for very good price. It’s capacity on demand licensing for Enteprise Edition. But small companies usually go to Standard Edition for(…)
Database management SQL Server: Change Data Capture for Oracle 19.03.2015 by Stéphane Savorgnano This new feature has been introduced in SQL Server 2012 and needs an Enterprise Edition. It uses a Windows Service which scans Oracle Logs and tracks DML changes from Oracle tables into SQL Server change tables. In other words,(…)