Re: ASM disk mapping to segment
- From: "Sanjay Mishra" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "smishra_97@xxxxxxxxx" for DMARC)
- To: "Mark.Bobak@xxxxxxxxxxxx" <Mark.Bobak@xxxxxxxxxxxx>, "dmarc-noreply@xxxxxxxxxxxxx" <dmarc-noreply@xxxxxxxxxxxxx>, oracle-l digest users <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 May 2014 08:32:00 -0700 (PDT)
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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxx>
Reply-To: "dmarc-noreply@xxxxxxxxxxxxx" <dmarc-noreply@xxxxxxxxxxxxx>
Date: Thursday, May 15, 2014 at 2:54 PM
To: oracle-l digest users <oracle-l@xxxxxxxxxxxxx>
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
Other related posts:
