Infrastructure at your Service

Category

Database Administration & Monitoring

Daniel Westermann

Linux Magic System Request Key Hacks

By | Database Administration & Monitoring | No Comments

Recently at a customer we needed to power-cycle a database system because we wanted to be sure that a cluster resource fails over to a remaining node as expected. The issue was that we did not have access to the data center where the system is running nor did we have access to the console. What to do? Actually it is quite easy to force a system to reboot without syncing the disks or unmounting…

Read More
Oracle Team

SQL> alter database switchover to …

By | Database Administration & Monitoring, Oracle | One Comment

By Franck Pachot . In 12c the manual switchover to physical standby requires only one command (ALTER DATABASE SWITCHOVER) instead of two (ALTER DATABASE COMMIT TO SWITCHOVER on each database). We usually recommend to use the broker and I wanted to see if the broker uses that new command or not. Let’s compare the alert.log for both manual and broker switchover. One simple command I have the broker configured, but try a manual switchover with…

Read More
David Barbarin

SQL Server 2016 query store

By | Database Administration & Monitoring, Development & Performance | 2 Comments

One of the most new interesting features that will be introduced by SQL Server 2016 is certainly the query store that will complete the performance tuning toolbox of database administrators. Basically, the query store will track queries, their query plans and runtime statistics as well. It will be a great tool to detect regressing queries. I remember a real customer case a couple of months ago where I was involved in a database migration project…

Read More
Oracle Team

You are in Standard Edition, when to worry?

By | Database Administration & Monitoring, Oracle | 4 Comments

By Franck Pachot . A previous blog post explaining what happens for those in ‘Standard Edition One’ had a “don’t worry” in the title because you can upgrade to SE2 with minimal additional cost – except when you have to buy new NUPs – and get only small additional limitation. I didn’t made such a post for people in Standard Edition but there is a case where it can be worrying because of the 2…

Read More
Stéphane Savorgnano

SQL Server 2016: New possibilities for Index Maintenance Task

By | Database Administration & Monitoring | No Comments

The new CTP 2.4 has been released some weeks ago by Microsoft. My colleagues and I have already blogged about some new functionalities. I will focus in this blog about the new possibility of Index Maintenance Tasks regarding Indexes. Until SQL Server 2016, DBAs didn’t use often the Maintenance Plan provided by SQL Server for indexes. In fact, those two tasks, Reorganize Index and Rebuild Index were not enough detailed and DBA’s preferred to create…

Read More
Pierre Sicot

dbsnmp expiring password, manually triggering metrics collections

By | Database Administration & Monitoring | No Comments

When you use Enterprise Manager Cloud control 12c, the monitor username commonly used is dbsnmp. Depending on the Oracle profile used for this user, the dbsnmp password can expire, and as a consequence multiple targets will be seen in a pending status by Enterprise Manager Cloud control 12c. An interesting way to solve this problem is to create a metric extension detecting in how many days the password will expire: You realize the operation as…

Read More
Olivier Toussaint

How to migrate your tablespace from 11g to a PDB in the Cloud

By | Database Administration & Monitoring | No Comments

Goal We will take a tablespace named FOR TRAVEL for migrate it into a PDB situated in your Europe Cloud in extreme performance database. This migration will be executed with Data Pump and transportable tablespace method. We will migrate the tablespace “FOR_TRAVEL” with a table  from Windows Oracle 11g database to Linux  Oracle 12c PDB Database. On-Premise Database You must have : A directory and permissions : Operactions Let’s take our BACKUP_DIR directory for the…

Read More