Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
By William Sescu My good old DEPT table always had 4 rows with 4 different departments. However, I have noticed that a new row was inserted into the DEPT table and the row 50 popped up, and I would like to know when it happened? Before: SQL> select DEPTNO, DNAME, LOC from DEPT; DEPTNO DNAME LOC ———- ————– ————- 10 ACCOUNTING…
By Franck Pachot . Short summary of this post is that rolling invalidation do not occur when you gather statistics on Global Temporary Tables in 12c that have session statistic scope (which is the default) and this may cause too many hard parses. I’m sharing all details and comments are welcome. Update28-OCT-16 I’ve written this having in mind a specific…
How to migrate an environment that includes availability groups from one Windows Failover Cluster to another one? This scenario is definitely uncommon and requires a good preparation. How to achieve this task depends mainly of your context. Indeed, we may use a plenty of scenarios according to the architecture in-place as well as the customer constraints in terms of maximum…
By Franck Pachot . What’s common with Standard Edition, simplicity, reliability, high performance, and affordable price? Dbvisit standby can be an answer because it brings Disaster Recovery to Standard Edition without adding complexity ODA Lite (the new X6-2S and 2M) is another answer because you can run Standard Edition in those new appliance. So it makes sense to bring them…
In this blog, I will present you the new Stretch Database feature in SQL Server 2016. It couples your SQL Server On-Premises database with an Azure SQL Database, allowing to stretch data from one ore more tables to Azure Cloud. This mechanism offers to use low-cost hard drives available in Azure, instead of fast and expensive local solid state drives.…
I recently had problems with Enterprise Manager 13.1.0.0, receiving such alerts: EM Event Critical hostname Memory Utilization is 93,205 % crossed warning (80%) or critical (90%) When we have a look at the EM 13c console for the host: On the system the free -m command displays: oracle@host:~/24437699/ [agent13c] free -m total used free shared buffers cached Mem: 48275 …
By Franck Pachot . In a previous post, tribute to transportable tablespaces (TTS), I said that TTS is also used to move data quickly from operational database to a datawarehouse ODS. For sure, you don’t transport directly from the production database because TTS requires that the tablespace is read only. But you can transport from a snapshot standby. Both features…
By Franck Pachot . I’m preparing some slides about PDB security (lockdown) and isolation (resource) for DOAG and as usual I’ve more info to share than what can fit in 45 minutes. In order to avoid the frustration of removing slides, I usually share them in blog posts. Here is the basic concepts of CDB resource plans in multitenant: shares…
As you already know if you are following our Documentum Story, we are building, working and managing, for some time now, a huge Documentum Platform with more than 115 servers so far (still growing). To be able to manage properly this platform, we need an efficient monitoring tool. In this blog, I will not talk about Documentum but rather I…
Azure offers two deployment models for cloud components: Resource Manager (RM) and Classic deployment model. Newer and more easier to manage, Microsoft recommends to use the Resource Manager. Even if these two models can exist at the same time in Azure, they are different and managed differently: in PowerShell cmdlets are specific to RM. In order to be able to…
Disclaimer: This is in no way a recommendation to avoid PL/SQL. This post just describes a case I faced at a customer with a specific implementation in PL/SQL the customer (and me) believed is the most efficient way of doing it in PL/SQL. This was a very good example for myself to remind me to check the documentation and to…
Why should you Audit your MySQL Instances? First to provide you a way to track user accessing sensible data Secondly to investigate on suspicious queries in all your critical databases Thirdly to comply with law and industry standards The MariaDB Audit Plugin can help you to log all or part of the server activity as: – who was connected and…
