Question on a SQL statement

 Say, if I have the following sql statement:

select * from view1 where column1 in ( select columnA from Table1);

(note: view1 involves 3 tables.)

If I need to run just "select * from view1;" from time to time, do you know if Oracle database will keep those data(of those 3 tables)  in memory to help out the above sql statement?

Thank you.

Martin