Querying GV$ASM_DISKGROUP is slow
From: Hameed, Amir <amir.hameed_at_sleepnumber.com>
Date: Fri, 3 Dec 2021 18:44:24 +0000
Message-ID: <CH0PR14MB501245E6B59A2241CE57B32DE06A9_at_CH0PR14MB5012.namprd14.prod.outlook.com>
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.
Date: Fri, 3 Dec 2021 18:44:24 +0000
Message-ID: <CH0PR14MB501245E6B59A2241CE57B32DE06A9_at_CH0PR14MB5012.namprd14.prod.outlook.com>
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
Received on Fri Dec 03 2021 - 19:44:24 CET