Re: ASM disk mapping to segment

X$KFFXP is the view you're probably looking for.

See this article by Luca Canali of CERN, for some ideas on how to interpret/use it: https://twiki.cern.ch/twiki/bin/viewfile/PSSGroup/HAandPerf?rev=1.4&filename=ASM_metadata_30012006.html

Hope that helps,

-Mark

From: Sanjay Mishra <dmarc-noreply_at_freelists.org<mailto:dmarc-noreply_at_freelists.org>> Reply-To: "dmarc-noreply_at_freelists.org<mailto:dmarc-noreply_at_freelists.org>" <dmarc-noreply_at_freelists.org<mailto:dmarc-noreply_at_freelists.org>> Date: Thursday, May 15, 2014 at 2:54 PM
To: oracle-l digest users <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: ASM disk mapping to segment

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri May 16 2014 - 19:37:55 CEST