I believe sql-statements which follows indexes will be kept in shared pool for further usage, because they will have explain plan, parsed code and all.
My question is will sql-statements which do full table scaning be stored in shared pool?.
Exactly what kind of sql-statements will be stored in shared pool?.
Please do give me proper explanation about this?.
go to tahiti.oracle.com and read concepts guide, clear and very good explanation
Click Here to Expand Forum to Full Width