on 08-04-2009 9:23 AM
In our BI7.0 with Oracle 10.2.0.4 this error occurs during activation and found abap runtime dumps in ST22.
Runtime Errors DBIF_RSQL_SQL_ERROR
Exception CX_SY_OPEN_SQL_DB
How to correct the erroru2026
Database error text........: "ORA-12801: error signaled in parallel query
server P291#ORA-12853: insufficient memory for PX buffers: current 428176K, max needed 2386944K#ORA-04031: unable to allocate 32816 bytes of shared memory ("shared poolu201D, u201Cunknown object","sga heap(1,0)","PX msg "
Information on where terminatedu2026
Termination occurred in the ABAP program "CL_RSODSO_ACTIVATE_REQUESTS===CP" -
in "ACTIVATE_DATA_FROM_QUEUE".
The main program was "RSPROCESS ".
In the source code you have the termination point in line 198
of the (Include) program "CL_RSODSO_ACTIVATE_REQUESTS===CM00D".
The program "CL_RSODSO_ACTIVATE_REQUESTS===CP" was started as a background job.
Job Name....... "BI_PROCESS_ODSACTIVAT"
Hello,
In case shared pool is set to correct value and ORA-04031 is temporary problem
you can flush shared pool by
alter system flush shared_pool;
Regards,
Reema
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ORA-12853: insufficient memory
Make sure shared pool is big enough... also check that your oracle parameters according to the recommended values
Read,
SAP Note 830576 - Parameter recommendations for Oracle 10g
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.