Thanks everyone for your help. I found a few items on Metalink.

To Pin a Table:
Alter table cache;

Pin SQL statements in memory using DBMS_SHARED_POOL:
1. Issue the SQL statement
For example:
SQL>select * from scott.emp;

2. Get the SQL address from v$SQLAREA
SQL> select address, hash_value, sql_text
from v$sqlarea
where sql_text like '%scott.emp%';

ADDRESS HASH_VALUE SQL_TEXT
________ ____________ ______________
836187c0 1131378091 select * from scott.emp

3. Pin the SQL statement using address and hash_value.
SQL> exec dbms_shared_pool.keep('836187c0, 1131378091','c');

4. To check if it was pinned properly
SQL> select name, type, kept
from v$db_object_cache
where kept = 'YES';

Thanks for all your help,