Monthly Archive:: October 2014

Installing MySQL on Linux : Part 1

Introduction: MySQL is world’s most popular open source database. MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack

What’s New in Oracle Database 12c Password file?

Introduction Oracle has introduced a number of new and important features with respect to a password file in Oracle Database 12c release. The noted improvement is, we can now store a password file directly in to ASM

Query to check high I/O ASM Disks

This query can be used to identify the Top 10 ASM disks involved in High I/O for a particular database ---------------------------------- ----- Script: chk_asm_io.sql ----- Author: Abu Fazal Abbas ----------------------------------- set lines 200 col Device for a55

Create Disk with ASM Filter Driver (ASMFD)

In my last article, I have demonstrated the steps involved in migrating ASM Disks from ASMLIB to ASMFD (ASM Filter Driver). Today, I would be discussing the steps involved in creating and adding a new ASM Disk

Steps to migrate to Oracle ASM Filter Driver From ASMLIB (GI Standalone Setup)

In Today’s article, I would be demonstrating the steps involved in migrating the ASM disks from Oracle ASM Library Driver (ASMLIB) to the new Oracle GI 12c feature ASM Filter Driver (ASMFD) for Oracle Clusterware Standalone Environment.

ASM Filter driver doesn’t support Unbreakable Linux Kernel

I was in the process of configuring ASM Filter Driver (ASMFD) and it was failing with following errors. -bash-3.2# $ORACLE_HOME/bin/asmcmd afd_configure Connected to an idle instance. AFD-620: AFD is not supported on this operating system version: '2.6.32-100.26.2.el5'

An Encounter with ASM Filter Driver (ASMFD): Oracle GI 12c New Feature

Introduction With Oracle Grid Infrastructure release, Oracle has introduced a new GI component called ASM Filter Driver (ASMFD). Here, I am presenting my first encounter with Oracle ASM Filter Driver (ASMFD). In its simplest form, ASMFD

Simple Perl script to query Oracle database

This post is for the beginners, who are willing to write PERL codes for querying Oracle database. Prerequisite: PERL must be installed (it comes by default with Oracle Binaries) DBI and DBD::Oracle module for PERL must be

Database Session details

Following script can be used to get information like OS process ID, PGA allocation, SQL_ID, etc. associated with a database session. The script takes SID and SERIAL# as input. -- Query to find the OS process details of

Oracle Database 12c New Feature: Auto increment column value with DEFAULT clause

This article is follow up of my last article where I had discussed about the Identity Column. As I had mentioned, in Oracle database 12c; we have two new features available that facilitates auto increment of column

Oracle Database 12c New feature: Identity column or Auto-increment column

Introduction: Prior to Oracle database 12c, there was no direct method available to auto increment a column value in a oracle database table. We had to implement triggers and generate sequence values based on those triggers and

ORA-39726: While dropping column from compressed table

We know that we can use the ALTER TABLE DROP COLUMN command to drop a column from a table. However, if the table is a compressed one; the scenario is bit different. Today, I would be covering

Which Index to choose? Global or Local Index for partitioned table !!

Introduction: We often deal with Indexes while working on Oracle database tables. We do know, there are different type of indexes like B-Tree, Bitmap, Hash-value, etc, etc.. which helps us to improvise the query performance. However, with respect to

DESCRIBE table with variable substitute and the alternative

Recently one of my friend was designing a script, where the requirement was to DESCRIBE a table structure based on the dynamic input (schema and table name) values provided to the script. DESC command worked fine, when the inputs were
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed