Database Administration & Monitoring

In-memory trickle repopulation

By Franck Pachot . In the 'traditional' row store, the indexes are maintained at the same time as rows are changed. It's different with the In-memory Column Store. Changes are maintained by background processes. When rows are changed, the Snapshot(…)

MongoDB Days Paris

Tuesday, October 6th 2015, I attended to MongoDB Days France in Paris. The presentation was directly organized by MongoDB (10gen). Several presentations have be done to show how to use and deploy MongoDB in real cases. MongoDB is a(…)

How to use sqldeveloper’cart for loading data into DBaaS

Here we will show you how to unload data from a database on premise Oracle Database 12c PDB and how to load it into the table on the DBaaS Oracle Database 12c PDB. We will use a SQL Developer to(…)

How to connect DbaaS in your Cloud Control 12c

Oracle provides a monitoring console in the cloud but this console gives not all the information that we need. For example, it is not possible to send an email when a problem appear. However it is possible to use a(…)

SSISDB is too big and it is not every time the retention period’s fault!

In all blogs that I read, the solution is just to change the retention period to a reasonable value. Yes, it is true but in some case you need to go deeper in the analysis… Like you, I(…)

Dbvisit replicate CDC without old values

By Franck Pachot . In a previous post I presented how Dbvisit replicate can capture changes and write them in an audit table with old and new values. Here is how to do it wen you want only the(…)

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.

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