DBIF_RSQL_SQL_ERROR

[Former Member]

Hi ,

There is a big dump ended with the following error.

SQL error 4031 occurred when accessing table .

Can you please tell me what does it mean.

regards,

evangeline.

[Former Member · Accepted solution]

Hi,

This error means that you've got a full tablespace.

Look at your /oracle/SID/saptrace/background/alert_SID.ora. There you'll find what's the failing TS. Then you can use BRTools either to create a new datafile, expand an existent one, or activate autoextend function.

Best Regards,

JC Llanes.

[Former Member]

Dear All ,

This problem occured by the windows memory not enough to load data from database because when you used system a long time , the windows don't release the unused memory . It have 2 solution for solve this problem ,

1. increase oracle parameter : SHARED_POOL_SIZE to the optimize value in init<SID>.ora

2. Re-boot system for clear the garbage memory.

Regards ,

Surapol K.

[Former Member]

Hi Evangeline,

This error appear when attempting to load a big package

or while executing a very large procedure and there is not sufficient

contiguous free memory in the SHARED_POOL.

This may be due to two reasons fragmentation or insuficient memory in the shared pool .

Could you tell us DB version and shared pool value in your intalation?

Oscar.