Database Administration (MOSC)

MOSC Banner

Regarding ORA-32701 and DocID:

Hi there, could you please give me some advice?

Oracle 11.2.0.4 RAC.

I got ORA-32701 on 2 nodes of 11g RAC.

According DocID: 2226216.1

I flush shared_pool every 10 mins, and the error does not come again. I want to know the root reason of this error and resolve this completely , instead of just flush the shared_pool ,

the Doc says:

 "This error can be noticed in large databases using large amount of binding variables."

How can I confirm this and get more details, I tried with AWR report, but did not find useful info.


Thanks in advance.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center