Sybase ASE – Create new Database & Device in Sybase ASE

In Sybase ASE the database is hosted on devices which in turn are mapped to physical datafiles. So to create a database we should have devices already created, if not we can create new devices as:- disk init name='<Device Name>’, physname='<PATH where the datafile would be created>’, size='<Size in MB>M’, directio=true go From the above…

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…

Queries to Monitor 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…