Tag Archives: ASM queries

15 Awesome Oracle ASM Queries every DBA must know

Last updated on August 25th, 2016 at 09:55 amVery Useful Oracle ASM queries for day to day activities for Oracle database administrator HOW TO CLEAR ASM DISKS dd if=/dev/zero of= *path of the disk* bs= *block size* count=10000 QUERY TO FIND THE FILES IN USE BY AN ASM INSTANCE col full_path format a50 col full_alias_path format a50 SELECT concat(‘+’||gname, sys_connect_by_path(aname, ‘/’)) full_alias_path FROM (SELECT g.name gname, a.parent_index … Continue reading 15 Awesome Oracle ASM Queries every DBA must know »

Top 5 ASM queries every DBA should know

Last updated on August 24th, 2016 at 06:48 pmASM is being used as storage environment in various organization.Here are Top 5 ASM queries every DBA  should know QUERY TO FIND THE FILES IN USE BY AN ASM INSTANCE col full_path format a50 col full_alias_path format a50 SELECT concat(‘+’||gname, sys_connect_by_path(aname, ‘/’)) full_alias_path FROM (SELECT g.name gname, a.parent_index pindex, a.name aname, a.reference_index rindex FROM v$asm_alias a, v$asm_diskgroup g … Continue reading Top 5 ASM queries every DBA should know »