Oracle Concepts – Find indexes for a table
See the indexes for a table
It is not unusual to wonder what indexes a specific table might have, and what columns in the table are assigned Read More…
Year: 2014
Oracle : TKPROF simple steps
1. Set the following parameters
TIMED_STATISTICS = TRUE
MAX_DUMP_FILE_SIZE = unlimited (also see metalink article 108723.1)
USER_DUMP_DEST = /oracleRead More…
SQLNET: How does Oracle Client connect with Oracle Server
Lets first try to understand what is Oracle Server and what is Oracle Client: Oracle Database Server:
Oracle Database Server is usually a physical maRead More…
Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
Before we begin installing Oracle Database XE in Linux, we need to prepare
the environment by installing the required packages, setting kernel parametRead More…
Relational Database Design – Normalization
It’s common for people new to relational databases to approach the design of the tables like they would a flat, Excel-like spreadsheet: to design the Read More…
Beginner’s guide to creating Tables in MySql
The first thing that you will need is to download MySql. I am working with MySql version 5.0. You can download it from their site. After setting it uRead More…
MySQL Basics Everything you need to know to start using MySQL databases
Introduction
This article describes all that you need to know to start working with MySQL database. Everything from the basic info on SQL, how to set Read More…
Monitoring MySQL using Nagios
This tutorial will discuss the various ways using which you can effectively monitor your MySQL Database using Nagios.
Prerequisites: Nagios MonitorRead More…
Quick Start: Setup CentOS 7 as a LAMP Server
In this tutorial, I’m going to show you simple steps using which you can setup your own LAMP (Linux-Apache-MySQL-PHP) on a CentOS 7 system.
PrerequisiRead More…
Quick Start: LAMP on Ubuntu 14.04
Quick Start:
LAMP on Ubuntu 14.04 Here’s a simple, easy to follow guide that will help you set up a fully functional “LAMP”: Linux (duuuuhhhRead More…