Sunday, January 3, 2016

ASM: asmcmd

ASM command line utility "asmcmd" to manage asm 

Use "lsdg" to examine the disk groups.
ASMCMD>lsdg

Use the "ls" command to list the ASM directory structure
ASMCMD>ls

"cd" command to change to the AWORLD directory
ASMCMD>cd AWORLD

"du" command to evaluate size of the disk group directory
ASMCMD>du

"lsct" command to see software versions.
ASMCMD> lsct

"lsct -g" to examine the client’s use of diskgroups
ASMCMD>lsct–g

"lsdsk" shows the disks that are managed by ASM

 "iostat" to see the Reads and Writes
ASMCMD> iostat

---Nikhil Tatineni--
---Oracle : ASM ---

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...