Automated Maintenance Tasks
This section looks at the automated maintenance tasks in the realm of memory management. In earlier releases of Oracle, when you got an ORA-04031 error related to memory, you had to resort to several methods to find the true cause and rectify it. One of the methods was to create an event in the initSID.ora file to get a trace file with additional information about the problem. Starting with Oracle 9.2.0.5 and Oracle Database 10g releases, a trace file is created by default in the user_dump_dest directory whenever a memory error occurs. So if you still get errors, even with a sufficiently large memory and with automatic memory management turned on, Oracle has already created the trace files for you to be sent to Oracle ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
