Re: Growth of CCursor sub-heap of the shared pool
From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Mon, 16 Dec 2013 17:23:05 -0800 (PST)
Message-ID: <a4f73ac8-1a72-4e66-94eb-2b5ba3ab882d_at_googlegroups.com>
Date: Mon, 16 Dec 2013 17:23:05 -0800 (PST)
Message-ID: <a4f73ac8-1a72-4e66-94eb-2b5ba3ab882d_at_googlegroups.com>
Thanks, trace files on ORA-04031 get produced automatically (I think from 9.2.0.7), and it is from these files we found that most of the pool was taken by CCursor. Unfortunately the database starts generating ORA-04031 only 20 minutes or so before becoming completely unusable, so we are trying to keep it from reaching this point by restarting (approx every two weeks). Received on Tue Dec 17 2013 - 02:23:05 CET