O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required