Interpreting Free Space in ASM Diskgroup

The Perception: I had the perception that the FREE_MB returned from querying the V$ASM_DISKGROUP is the actual amount of free space available under a particular ASM diskgroup. Till date, I was using the following query to get

The unusual case of recreating Oracle (central) Inventory

It could be a rare situation, where your Oracle RDBMS inventory is corrupted or lost and you don’t have a copy of the inventory to restore it. As a standard process, we usually keep backup of the

Oracle database 12c (12.1) : Password file mystery

I was trying to implement password file authentication for my Oracle 12c database. However, seems like Oracle database was not recognizing the password file at all. As shown below, I had created a password file ‘orapwprodcdb’ for

Oracle Database 12c (12.1): Datapump Export and Pluggable databases

As a DBA, we all are familiar with the Datapump (EXPDP/IMPDP) utility for exporting and importing database objects in and across databases. However, with the introduction of Oracle Database 12c and particularly with the introduction of Multi-tenant

Script to Introduce Manual Block Corruption in Oracle Database

A block corruption in a database is a rare and unwanted situation. However, for testing corruption recovery scenario a DBA needs to have a actual corruption at the block level. I have written a wrapper script that

Oracle RAC: GRID_HOME is occupied by crfclust.bdb

Recently, I have come across an issue in 11gR2 RAC, where the GI file system GRID_HOME was mostly consumed by a single file called crfclust.bdb This single file itself was about 30 GB of size. [oracle@my-lab01 ~]$

DBVERIFY: Do we really need a USERID ?

DBVERIFY (dbv) is the Database Verification utility that can be used to perform a physical data structure integrity check. dbv can be used against ONLINE or OFFLINE datfiles as well as backup files. DBVERIFY is basically used

RMAN Block Media Recovery: Lets have a deeper look

As a DBA, we know there are situations where the database blocks get corrupted and we have different methods available to fix the corrupted blocks. In today’s article, I would be discussing the internals involved in the

Oracle Database 12c: Move Datafile Online

Prior to Oracle Database 12c, moving a datafile was always a OFFLINE task. There were different approach to move a datafile. However, there was always a downtime associated with the datafile move operation. Oracle has introduced ONLINE

Oracle Database: Finding Trace Event Codes to help in debugging

We often need to set different level of tracing for debugging database issues. However, it is not realistic for a DBA to remember the list of all the tracing event codes that can be set for debugging

Oracle Database 12c: You can acess the actual runtime query

While browsing through Oracle Docs, encountered with yet another new feature that Oracle has introduced in the 12c release. Starting from 12c, we can now get to know the actual query that is being executed against the

Oracle Database: Timezone mismatch between Local and Remote Connections

Today, I have come across an interesting issue. One of the application that I support, was complaining about timezone mismatch in the database between the local and remote connections. Basically, when they were directly (BEQ connections/ Local

Oracle Multitenant: Impact of a Pluggable Database (PDB) Failure

Introduction Today I would be discussing the impact of a pluggable database failure (particularly media failure) on the other pluggable databases and the parent container database. In this article series, I am trying to make an attempt

Oracle Database 12c: Data Redaction (Hiding sensitive data)

What is Data Redaction Data Redaction is the process of masking (redacting) data (more particularly sensitive data) for an application. Oracle Data Redaction functionality provides methods to mask (redact) data that is returned from user SELECT queries

Oracle Database 12c: The Multi-Threaded Process Model

History Oracle Database on Unix machines (Linux, Solaris, AIX, etc..) have always been a multiprocess database with each new version or release adding a new set of processes to the database architecture. However, On the contrary Oracle
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed