A collection of techical notes, cheat sheets, how-to documents, hints, tips, resouces and other odds'n'ends for anything database related.

Latest posts

How to reset MySQL root password

Have you forgotten MariaDB root password? You don't know how to recover it. Not to worry, use these steps to reset MariaDB root password.

How to reset MariaDB root password

Have you forgotten MariaDB root password? You don't know how to recover it. Not to worry, use these steps to reset MariaDB root password.

Oracle Parameters on Solaris 10

The table below shows the System V IPC parameter and the corresponding Soalris resource controls for Oracle on Sun Solaris 10 OS.

Oracle lsnrctl commands

The listener process runs on the database server. It receives client requests and manages the traffic of these requests to the database server.

Enable/Disable archivelog mode

The following are the steps required to enable archive log mode on an Oracle 10g or 11g database.

Oracle Import and Export utilities

imp and exp are Oracle utilities that allow us to make imports and exports of data objects.

Oracle export and import Utilities

Export (exp) and import (imp) are the Oracle utilities used to perform logical database backup and recovery.

System Global Area (SGA)

The maximum size of a single shared memory segment is specified by the shmmax (shm_max on Tru64 UNIX) kernel parameter.