Oracle Auto-Startup Script for Linux

This post is to provide a script to auto-start Oracle Instances on Linux upon server restart. First step would be to configure /etc/oratab file as per your requirement, oratab file is in the following format: <DB NAME>:<ORACLE HOME>:<Y|N> The last letter tells oracle if the database need to restarted or not, so we would change…

Monitoring Oracle Sessions

This post is to provide a set of queries to monitor any user session on an Oracle Instance more efficiently. Below query (Lets name it Query1 for the sake of discussion) gives you an overall status of what all sessions are active, what wait event they are waiting on and what are they executing. set…

SQL Server on Linux – Directory Structure

If you have installed SQL Server using my previous post Install SQL Server 2017 on Linux, this post is to describe the directory structure of SQL Server on Linux. MSSQL binaries are installed under /opt/mssql folder. This folder further includes mssql binaries & libraries sub-folders:- MSSQL Binaries /opt/mssql/bin :- MSSQL Libraries /opt/mssql/lib :- Then comes…

Install SQL Server 2017 on Linux

This post is to guide SQL Server 2017 installation on Linux. You can create a Linux VM following my previous post of Installing Linux 7 on Oracle VirtualBox. Once the Linux VM is build follow the instructions below to install SQL Server latest release. Step 1: Download the Microsoft SQL Server Red Hat repository configuration…

row cache lock – Oracle Wait Event

The Row Cache or Data Dictionary Cache is a memory area in the shared pool that holds data dictionary information to reduce physical I/O on the data dictionary tables. The row cache lock is used primarily to serialize changes to the data dictionary and is waited on when a lock on a data dictionary cache…

log file sync – Oracle Wait Event

When a user session commits, the session’s redo information needs to be flushed from memory to the redo logfile to make it permanent. At the time of commit, the user session will post the LGWR to write the log buffer (containing the current unwritten redo, including this session’s redo information) to the redo log file.…

log file switch – Oracle Wait Event

log file switch (archiving needed) Waiting for a log switch because the log that the LGWR will be switching into has not been archived yet. Check the alert file to make sure that archiving has not stopped due to a failed archive write. To speed archiving, consider adding more archive processes or putting the archive…