Database Administration & Monitoring, Oracle You are in Standard Edition One? Don’t worry. 19.09.2015 by Oracle Team By Franck Pachot . You want the amazing features of Oracle SQL and PL/SQL with minimal cost. Your database is too large for Oracle XE edition, but not big enough to require the cost of Enterprise Edition. You accept to(…)
Database Administration & Monitoring SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog 16.09.2015 by Microsoft Team During my investigation about the new AlwaysOn features, I wrote a blog post about the new SSISDB support for AlwaysOn. You can find it here: > SQL Server 2016 : availability groups and the new SSISDB support Just as(…)
Database Administration & Monitoring Install Oracle instant client and perl DBD::Oracle @ Mac OS X Yosemite 16.09.2015 by Jérôme Witt Recently, I tried to install and connect to Oracle databases directly from my new Mac Book using perl (Yes, perl is still one of the most friendly programming language for DBAs). What first seemed to be easy was in reality(…)
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(…)