Dump - DBIF_RSQL_NO_MEMORY

[Former Member]

Hello ,

I am getting the dump DBIF_RSQL_NO_MEMORY .

Please update me on this .

Thanks ,

Rahul

[Former Member]

Hello ,

I am getting the dump DBIF_RSQL_NO_MEMORY .

Please update me on this .

Thanks ,

Rahul

[Former Member]

Hi,

I guess your select statement returns a large volume of data whoch causes this memory dump or you are processing a large volume of data in your program.

Shruthi

[Former Member]

Use package size and clear unwanted internal table before making select for huge volume.

[Former Member]

hi

u ve to clear the header of the inter nal table

after operation if possible refresh the internal table

then also if it is showing no memory

then u ve to increase the size of table by addding " occurs 0" statement.

again if it is coming then just tell ur basics consultant to restart the server becoz the buffer area is full just for refreshing purpose restart it.

rewards if useful

sachhidananda tripathy

[Former Member]

Hello,

To fix this problem if you are using AIX or UNIX, you need adjust the AIX kernel for user root, ora<sid> and <sid>adm using smitty tools. The memory use for UNIX come reduced.

smiity -> change / Show characteristics -> and then change the following parameters:

Soft CPU time = -1

Soft FILE size = -1

Soft STACK size = -1

Soft CORE file size = -1

Soft Data Segment = -1

Regards,

Angelo

[ravi_lanjewar]

Hi,

Welcome to SDN, but before posting search in SDN.

Following lilnk will help you.