Re: Urgent Oracle parsing question

> We are facing extensive performance degradation.
> This is because of Oracle parsing the same SQL
> statements for too many number of times.

Are you using packages or stored procedures/functions? If not, that's the first thing you should do. If you are using packages/procedures, and they keep dropping out of memory, you can pin the most important ones in memory so they don't page out. Received on Mon Nov 16 1998 - 10:05:52 CST