ASM disk mapping to segment

  • From: "Sanjay Mishra" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "smishra_97@xxxxxxxxx" for DMARC)
  • To: oracle-l digest users <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 15 May 2014 11:54:19 -0700 (PDT)

Hi 

Can someone shared the script to map as what Oracle Database segment is located 
on particular ASM Disk in the Diskgroup ? We have 5 disk out of 40 disk in a 
diskgroup that are reported as high IO. As same diskgroup is shared among 5 
database and so need to find what are different segements at this particular 
disk from multiple databases.

Thanks
Sanjay

Other related posts: