RE: Accessing ASH is slow
From: Sayan Sergeevich Malakshinov <malakshinovss_at_psbank.ru>
Date: Mon, 22 Jul 2013 17:15:03 +0400
Message-ID: <OFF15665E2.D192A25C-ON44257BB0.00487FF1-44257BB0.0048CA16_at_psbank.ru>
> But it seems that the two tables don't have any index to improve the
> access path.
Date: Mon, 22 Jul 2013 17:15:03 +0400
Message-ID: <OFF15665E2.D192A25C-ON44257BB0.00487FF1-44257BB0.0048CA16_at_psbank.ru>
> But it seems that the two tables don't have any index to improve the
> access path.
You can get all fixed indexed through v$indexed_fixed_column:
select *
from v$indexed_fixed_column
where table_name in ('X$ASH','X$KEWASH');
-- Best regards, Sayan Malakshinov http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 22 2013 - 15:15:03 CEST