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

Other related posts: