Multiple Versions of SQL statements in memory

[sunkutup]

Hi
Can some one explain to me what causes a situation to have multiple versions
of SQL statements in memory. One of the remote database has this problem and

I have never delt withit before. all applications are written the same for all remote stattions. only this station has this problem

If I flushed the shared pool can this help? If so how do I go about it?

[SANJAY_G]

Check..
1. If there are users doing ad-hoc queries from SQL*Plus.
2. If the applications using bind variables or not.
3. Remember that the SQL statements differing in case (upper/lower) will be parsed separately

Sanjay

[pando]

there will be different versions if you have synonyms, there will be a parent cursor and several child cursor