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 …
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 …
Change location of control files in Oracle
Hello everyone, we are going to comment on one of the actions that as DBAs we are going to have to perform sometime if we work in database environments Oracle …
Autonumerics: get the latest embedded in Oracle, MySQL, and SQL Server
Hi friends!!! In today’s post we are going to work with Autonumerics in Oracle, MySQL and SQL Server . We will see how to obtain the last value of the …