ASM disk mapping to segment
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Thu, 15 May 2014 11:54:19 -0700 (PDT)
Message-ID: <1400180059.7775.YahooMailNeo_at_web122104.mail.ne1.yahoo.com>
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: Thu, 15 May 2014 11:54:19 -0700 (PDT)
Message-ID: <1400180059.7775.YahooMailNeo_at_web122104.mail.ne1.yahoo.com>
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 Thu May 15 2014 - 20:54:19 CEST