RE: Accessing ASH is slow

  • From: Sayan Sergeevich Malakshinov <malakshinovss@xxxxxxxxx>
  • To: usn@xxxxxxxxx
  • Date: Mon, 22 Jul 2013 17:15:03 +0400

> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: