Oracle Database Discussions

Hello friends,

We are getting timeouts on application from database (RAC - 12.1.0.2.0 two machines on Linux 2.6.32-431.el6.x86_64) after certain number of execution having sql and pl/sql. Whether we run application on 500 tx/sec or 800 tx/sec, we get timeouts relatively. After few timeouts application recovers. If we restart database the scenario occurs after around 2 -3 million transactions after that it can occur randomly.

Assuming there was some problem in SGA, Initially SGA was auto tuned so we tried it to set manual but we are still facing the issue. Currently SGA is manual and v$sgainfo stat is following:

NAME                                            BYTES           RES   CON_ID

-------------------------------- ---------- --- ----------

Output from the query

select component, current_size/1024/1024 "CURRENT_SIZE", min_size/1024/1024 "MIN_SIZE", user_specified_size/1024/1024 "USER_SPECIFIED_SIZE",

   last_oper_type "TYPE" from v$memory_dynamic_components;

component current_size MIN_SIZE USER_SPECIFIED_SIZE TYPE

In the above output we see the shared pool is growing.we checked v$sga_resize_ops for the same too.

Please provide your valuable suggestions/feedback.