Oracle Point, Oracle Life.

This is digest note I made while I was reading some metalink docs.

1. Note: 396940.1 Troubleshooting and Diagnosing ORA-4031 Error 

• How is memory allocated and deallocated in the SGA pools?
• What is the Reserved Area and how it affect memory allocation?
• How ora-04301 error occurs? and, possible solution
• Couple of scripts check free memory and to predicate error Ora-04301
• A rule of thumb for setting up ASMM
• What database parameters are relevant to ORA-04031 problems?
• What is relevant in the Statspack/AWR report for a 4031 error?

2. Note: 146599.1 Diagnising and Resolving Error Ora-04301

• Steps of diagnosing and resolving error Ora-04301

3. Note:62143.1 Understanding and Tuning the Shared Pool

• reduce the load on the shared pool with adjustment of init parameters
• sample scripts to look at shared pool problems

Popularity: 5% [?]

This is quick note for myself in figuring out the following error we experienced this morning.

“FRM-40735: BUILD_COLL trigger rarised unhandled exception ORA-06502″

At first, we refer to Oracle Metalink Note:139548.1

Then, we narrowed down that a sequence is incremented to a value which exceed the limit defined in our form application.

At last, we reset the sequence by referring the attached guide, along with Oracle Meralink Note:443618.1.

Guide to Reseting Sequence AUDSES$ in Banner with Oracle

Popularity: 6% [?]