Identify data files used by index

select * from dba_data_files
where file_id in(
select distinct file_id from DBA_EXTENTS where segment_name in ('SKU_PK')
intersect
select distinct file_id from DBA_EXTENTS where segment_name in ('XIF7SKU'))

Flush specific sql from shared pool

select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID like 'cj15zn2ydvac4';

exec DBMS_SHARED_POOL.PURGE ('000000085FD77CF0, 808321886', 'C');

To flush complete shared pool ofcourse:

alter system flush share_pool;