Re: ASM disk mapping to segment
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Tue, 20 May 2014 08:32:00 -0700 (PDT)
Message-ID: <1400599920.26027.YahooMailNeo_at_web122104.mail.ne1.yahoo.com>
Thanks Mark. I checked the same document earlier but not able to get close to mapping. Found some details on using DBMS_STORAGE_MAP and so working to get some test on this with ASM on dev environment. Sanjay On Friday, May 16, 2014 1:39 PM, Mark Bobak <Mark.Bobak_at_proquest.com> wrote: Sanjay, 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> Reply-To: "dmarc-noreply_at_freelists.org" <dmarc-noreply@freelists.org> Date: Thursday, May 15, 2014 at 2:54 PM To: oracle-l digest users <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
Date: Tue, 20 May 2014 08:32:00 -0700 (PDT)
Message-ID: <1400599920.26027.YahooMailNeo_at_web122104.mail.ne1.yahoo.com>
Thanks Mark. I checked the same document earlier but not able to get close to mapping. Found some details on using DBMS_STORAGE_MAP and so working to get some test on this with ASM on dev environment. Sanjay On Friday, May 16, 2014 1:39 PM, Mark Bobak <Mark.Bobak_at_proquest.com> wrote: Sanjay, 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> Reply-To: "dmarc-noreply_at_freelists.org" <dmarc-noreply@freelists.org> Date: Thursday, May 15, 2014 at 2:54 PM To: oracle-l digest users <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-lReceived on Tue May 20 2014 - 17:32:00 CEST