Oracle Database Discussions

Hi,

3 months back we have upgraded our databases from 10g to 11g, we have multiple schema's in single database for each individual client we use one schema.

oracle version details:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

After we have migrated our database we are seeing random "ORA-00942 table or view does not exist" from application, this is happening once in a while .
for example if we go to some x page and try doing some action it gets successfully 9 out of 10 times. but 10Th time it fails saying table or view does not exist.

we tried to replicate the scenario in our development environment but could not able to do so. its only happening in production.
We have the exact similar environment in development compared to production.

This issue not particular to one single page its happening across most of the pages on random basis, but our client reported this issue on one page where we have a scenario of building the SQL dynamically and executing it (this page is most frequently used).

Thanks for the help