Database Administration & Monitoring SQL Server AlwaysOn: number of databases and the hadr worker pool 15.09.2015 by Microsoft Team Often, when I’m in charge to implement an SQL Server AlwaysOn infrastructure with availability groups, customers ask me if it exists some best practices and recommendations about the maximum number of databases in an availability group planning. In fact, we(…)
Database Administration & Monitoring, Oracle Invisible indexes: it’s online in 12c – even in Standard Edition 14.09.2015 by Oracle Team By Franck Pachot . Do you think that online operations are available only on Enterprise Edition? That changed in 12c, there is an operation that is online (without the need for the ONLINE keyword) and available in Standard Edition and(…)
Database Administration & Monitoring, Technology Survey SQL Server 2016: Upgrade Advisor 14.09.2015 by Stéphane Savorgnano During the read of a blog of my colleague Nathan Courtine about Stretch database, I installed the version of SQL Server 2016 Upgrade Advisor and Oh surprise! it looks really NEW! “A new generation of advisor tool for SQL(…)
Database Administration & Monitoring, Oracle Waiting for row lock. But which row is locked? 13.09.2015 by Oracle Team By Franck Pachot . When you are waiting on a locked row, the locked resource is the transaction that has locked the row. We have no information about which row is locked. Here is how to get it from V$SESSION.
Database Administration & Monitoring, Oracle DataBase Cloud Service performance – Network 13.09.2015 by Oracle Team By Franck Pachot . In previous posts, I've installed SLOB on the Cloud Services, measured IOPS and(…)
Database Administration & Monitoring If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops? 08.09.2015 by Daniel Westermann This is the next post on this GoldenGate series: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with(…)
Database Administration & Monitoring, Oracle Measuring IOPS on XtremIO 07.09.2015 by Oracle Team By Franck Pachot . Today, we can put our database on very efficient storage. EMC XtremIO is one of them. In this blog post, I'll show how to look at the IO performance from Enterprise Manager, Orachrome Lighty, and XtremIO(…)
Database Administration & Monitoring Using GoldenGate event actions to suspend replication for end of day reporting 07.09.2015 by Daniel Westermann The last post in this series outlined on how to do an initial load of the target database using the “expdp/impdp” method: Installing and patching Oracle GoldenGate 12c to the latest release Setting up(…)
Database Administration & Monitoring, Oracle set state=apply-off and datafile consistency 06.09.2015 by Oracle Team By Franck Pachot . In a standby database (or in any database you recover) do you think the recovery uses buffer cache? And when you stop the apply in a standby database, do you think the datafiles are in a(…)
Database Administration & Monitoring Performing an initial load with GoldenGate (2) – expdp/impdp 04.09.2015 by Daniel Westermann The last post in this series outlined on how to do an initial load of the target database using the “file to replicat” method: Installing and patching Oracle GoldenGate 12c to the latest release(…)