INSTR to search characters

The main goal of this post, is to know the different file systems where the Database’s data files are living on.

To do this, there must exist characters searches to manipulate and bring the first part of a file system.

Here I show how this can be easily done, indeed I have seen many people that have a little problems where they try to do some of this information segmentation.

Bulk ASM disks’ creation with Linux

Maybe sometime, you’ll have the need to add a quantity of disks to the Automatic Storage Management (ASM) to be used in the disk groups and so, have enough space for the tablespaces’ data files. Here you’ll find how to do this in a  dynamic and fast way with the help of Linux tools.

Over which block device is mounted an ASM disk?

How to know over which block device is mounted a disk of the Oracle’s Automatic Storage Mangemente (ASM)?, it’s important to know this in order to determine which partition can be used for the creation of a new disk in that storage technology.