Database hangs intermittently
I am very new to this community. so kindly bare me.
I am facing severe problem of PRODUCTION database hanging intermittently and following are suggestion from one of the Oracle Support Engineer.
-------------------------------------------------------------------------------------------------------------------------
1) Increase the shared pool size so that there is less chance of aging out cursors.
2) turn off timed_statistics, sql_trace, oracle trace, and _rowsource_execution_statistics if they are set so as to prevent the different
cursor types from being selected.
3) increase _row_cache_cursors such that a process does not end up needing to close one from its LRU for row cache
operations. The default for this is 10, it is sugegsted this could be increased to 20
I am facing severe problem of PRODUCTION database hanging intermittently and following are suggestion from one of the Oracle Support Engineer.
-------------------------------------------------------------------------------------------------------------------------
1) Increase the shared pool size so that there is less chance of aging out cursors.
2) turn off timed_statistics, sql_trace, oracle trace, and _rowsource_execution_statistics if they are set so as to prevent the different
cursor types from being selected.
3) increase _row_cache_cursors such that a process does not end up needing to close one from its LRU for row cache
operations. The default for this is 10, it is sugegsted this could be increased to 20
0