| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> set event 4031
We have been having occasional ORA-4031 problems. I will probably need to increase the shared_pool, but before doing that I wanted to get some extra information. Yesterday I entered ALTER SYSTEM SET EVENTS '4031 trace name heapdump level 2'. This morning I found a few trace files in the udump directory. They all seemed to show enough free space (I looked at the size of the free space chunks in the FREE LIST section) so I didn't understand why we would have the 4031. I asked one of our developers to send me the log file of the application where the 4031 shows up, and he said there were no such errors last night. This is consistent with the amount of free space in the shared_pool, but why am I getting the trace files? Anybody else seen this? I am on 8.1.6.3
Thanks.
Henry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Henry Poras
INET: Henry.Poras_at_ctp.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Aug 31 2001 - 11:21:21 CDT
 |
 |