How to add or drop redo log groups in Oracle RAC
Hello friends, this week we are going to add a Redo log group, also steps to drop redo log groups. In RAC, each instance has a redo thread; when you …
Blog
Latches Oracle
Hello everyone, today we are going to talk about latches, an Oracle lock in memory. What are Latches? Latches provide a low-level serialization mechanism that protects shared data structures in …
SQL Server dynamic restore script
Hello everybody, today we are going to share a very useful script for server migrations and database moves. Sooner or later, database professionals have to deal with moving databases between …
Connectivity to Oracle database using TNSPING
Hello everyone, today we are going to talk about an Oracle tool that we use to know if we have connectivity with the instance of the Oracle database to which …
Oracle 12 IDENTITY Columns
Hello everyone, today we wanted to discuss with you a feature of Oracle 12.1 that is very powerful and rarely used, the IDENTITY columns. This functionality is implemented in most …
OCI CLI: Installation and configuration on Linux
Hello everyone. Today we are going to talk about the installation and configuration of OCI CLI on Linux. This OCI tool will be useful to have installed if you are …