Infrastructure at your Service
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 quite difficult and long. Alone, the huge quantity of hits on the WorldWideWeb was impressive. However none of the hits were providing the entire solution. Follows, all the steps to prepare and install the Oracle…
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 have to keep in mind the relation between databases and the SQL Server worker pool in this architecture. Remember that the SQL Server AlwaysOn and availability group feature is an extension of the SQL Server…
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 a very important feature for performance tuning: invisible indexes.
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 Server” aka Microsoft. To download and install it, click here. This new version has a dual role: Check the compatibility of old versions of SQL Server compared to SQL Server 2016 Help adoption of new SQL…
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.
In previous posts, I’ve installed SLOB on the Cloud Services, measured IOPS and CPU. There’s another resource that is even more important in a cloud environment: network.
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 GoldenGate (1) – file to replicat Performing an initial load with GoldenGate (2) – expdp/impdp Using GoldenGate event actions to suspend replication for end of day reporting One question that pops up when stopping the replication by using an event marker is: What happens…
As in the past years, dbi services is present at DOAG, and our speakers give 8 sessions, as well as one full day training. We are looking forward to meet you there. Here is the program.
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 client interface.
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 a sample replication with GoldenGate Performing an initial load with GoldenGate (1) – file to replicat Performing an initial load with GoldenGate (2) – expdp/impdp In this post I’ll look into how to use event actions to suspend GoldenGate replication for…
