All articles

Oracle 12c – Combining Flashback Drop and Flashback Query

By William Sescu If you think that Flashback Drop feature just brings back your table, then this is only half of the story. It does much more than that. Besides undropping the table, it also brings back your constraints, your(…)

OEL 7 – How to disable IPv6 on Oracle Linux 7 – Follow Up

By William Sescu This is a follow up to the Blog were I explained how to disable IPv6 on Oracle Linux 7. If you have done all the steps which I have explained here http://dbi-services.com/blog/oel-7-how-to-disable-ipv6-on-oracle-linux-7/  then you have already(…)

SQL Server Failover Cluster on Linux and synchronizing uids/gids across nodes

In my previous blog post, I talked about SQL Server on Linux and high availability. During my test, I used a NFS server to(…)

Windows Server 2016 RTM and Docker

I wrote some months ago several blog posts about the new Container feature of Windows Server 2016. Here is the list: Windows Server 2016: Containers Windows Containers: Migration Windows Container: installation and utilization Today, I(…)

Oracle 12c – Issues with the HEATMAP Segment even if the heat map feature is not used

By William Sescu When I don’t need I feature, I don’t turn it on, or do not use it because it reduces the possibility to run into issues. Most of the times this is true, however, during the preparation for(…)

12cR2 DBCA can create a standby database

By Franck Pachot . Do you like DBCA to create a database from command line, with -silent -createDatabase? On a simple command line you can provision a database, with oratab, tnsnames.ora directory creation and any setting you want. And you(…)

Oracle Public Cloud: LIOPS with 4 OCPU in PaaS

By Franck Pachot . In the latest post I've run a cached SLOB workload on Oracle Cloud IaaS to measure logical reads per seconds on a system covered by 2 processor licences (so 4 OCPs). Just(…)

Linux – Securing your important files with XFS extendend attributes

By William Sescu Let’s say, the tnsnames.ora is a quite important file on your system, and you want to make sure that you notice when someone changes the file. Taking a look at the modification time of that file would(…)

SQL Server AlwaysOn – Distributed availability groups, read-only with round-robin capabilities

This blog post comes from a very interesting discussion with one of my friends about the read-only capabilities of secondary replicas in the context of distributed availability groups. Initially, distributed availability groups are designed to address(…)

Oracle Public Cloud: 2 OCPU for 1 proc. license

By Franck Pachot . I've blogged recently about the Oracle Core Factor in the Clouds. And then, in order to optimize your Oracle licences, you need to choose the instance type that can run faster on(…)