Use the following command to flush the shared pool and then try running the query again.

Alter system flush shared pool;

Regards
S.Prabhakar