All articles

Oracle In-Memory Column Store for Business Intelligence at #swissbiday

By Franck Pachot . I'm currently presenting at Swiss BI Day in Geneva about Oracle In-Memory option to improve analytic queries. Here are the slides, uploaded to SlideShare.

Oracle and Analytic Queries before In-Memory option

By Franck Pachot . Next Tuesday in Geneva I'm presenting Oracle In-Memory Column Store to Business Intelligence people at the Swiss BI Day After defining what is an analytic query, I show the different approaches to optimize that in(…)

Result Cache and 12c ‘fetch first n rows’

By Franck Pachot . At our bi-annual dbiXchange I was talking with Nicolas Jardot about his presentation on Result Cache (don't forget Jérome witt session about RC at DOAG) where he has shown an unexpected behavior on(…)

SQL Server 2016 : tempdb database enhancements in CTP 2.4

The new CTP 2.4 has been released and announced by Microsoft in its blog post a couple of days ago. During my investigation, I noticed some new  installer capabilities about the tempdb database. As a reminder,(…)

Query V$UNDOSTAT for relevant time window

By Franck Pachot . When you have a query failing in 'ORA-01555: snapshot too old: rollback segment number ... with name ... too small' you have two things to do: Convince the developer that the rollback segment is not too(…)

Nothing in feature usage statistics since 12c?

By Franck Pachot . It don't want to rub salt in the wound about 12c upgrades and Adaptive Dynamic Sampling being overzealous, but here is a case with an unexpected consequence: you see nothing in the 'Database Feature Usage' since(…)

Row Level Security (RLS) is also coming to MS SQL Server

Why “also” in my title? On 29 August, my colleague Daniel Westermann wrote an article about Row Level Security in the next version of PostgreSQL. Row Level(…)

SQL Server 2016: Transaction Performance Analysis Overview & In-Memory OLTP Migration Checklists

To be able to define which Tables or Stored Procedures will us the best performance gain after migration to In-Memory OLTP, SQL Server 2014 provided a tool called AMR (Analysis Migration and Reporting). This tool was really interesting but we(…)

SQL Server 2016 : availability groups with no domain dependencies

Are you aware about the new features of the next Windows version? Currently we’re in TP3 and during my investigation, I was very happy to see the new features for Windows clustering (cf. this blog post from Microsoft). By(…)

SEVERE:OUI-10020:The target area /u01/app/oracle/oraInventory/ is being used as a source by another session

What to do if you get the above error when you try to install Oracle SE2 (did not test if the same issue is there with EE, but probably it is) in silent mode?: ./runInstaller oracle.install.option=INSTALL_DB_SWONLY ORACLE_BASE=/u01/app/oracle/ ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_2_4/ UNIX_GROUP_NAME=oinstall oracle.install.db.DBA_GROUP=dba(…)