if the issue happens do a session less sqlplus session
sqlplus -prelim
and then use "oradebug” utility to analyze the SGA
SQL> oradebug setmypid
SQL> oradebug hanganalyze 12
Which wil produce a tracefile in udump, which can give a clue on what happening in the memory.
| 
Меню сайта