Query to monitor progress of Index creation or Index rebuild

The following query can be used to monitor the progress of Index creation or Index rebuild for huge indexes. ------------------------------------- ---- Script: chk_idx_progress.sql ---- Author: Abu Fazal Mohammed Abbas -------------------------------------- set lines 200 col "Index Operation" for

Oracle Database: You can not shut me down !!

Today, I have come across a strange behavior of Oracle Database. I was trying to SHUTDOWN my database with the IMMEDIATE option and the database came back to me saying I can not shut it down. Here

Oracle Database 12c Multitenant: Create a Pluggable Database

Oracle Database 12c multitenant architecture allows multiple pluggable databases (PDB) to be hosted in a single container database (CDB) or root database. In today’s article, I would be discussing the different methods that we can utilize to

Installing MySQL on Linux: Part 2

This is the 2nd article in the series “Install MySQL on Linux”. In the first article, I had demonstrated how to install MySQL on Linux using RPM packages. Today, I would be demonstrating another method of installing

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
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed