Re: Querying GV$ASM_DISKGROUP is slow

Please run the query with SQL Trace enabled, and share the output.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant at Pythian
Oracle ACE Alumni
Pythian Blog http://www.pythian.com/blog/author/still/ Github: https://github.com/jkstill
Personality: http://www.personalitypage.com/INTJ.html

On Fri, Dec 3, 2021 at 10:44 AM Hameed, Amir <amir.hameed_at_sleepnumber.com> wrote:

> Hi,
>
> The database version is 11.2.0.4. We have noticed that a simple query
> against view GV$ASM_DISKGROUP consistently takes 12-15 seconds.
>
>
>
> SQL> select count(*) from GV$ASM_DISKGROUP ;
>
>
>
> COUNT(*)
>
> ----------
>
> 15
>
>
>
> Elapsed: 00:00:12.20
>
>
>
> Under the hood, the statement does FTS on X$KFGRP. I am not able to get
> any information on whether this could potentially be related to a known
> bug. Has anyone run into this issue? Any feedback will be appreciated.
>
>
>
> Thanks,
> Amir
>

--
http://www.freelists.org/webpage/oracle-l