topic Dump - DBIF_RSQL_NO_MEMORY in Application Development and Automation Discussions

Dump - DBIF_RSQL_NO_MEMORY

Former Member — Tue, 20 May 2008 09:36:43 GMT

Hello ,

I am getting the dump DBIF_RSQL_NO_MEMORY .

Please update me on this .

Thanks ,

Rahul

Re: Dump - DBIF_RSQL_NO_MEMORY

Former Member — Tue, 20 May 2008 10:21:17 GMT

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

Re: Dump - DBIF_RSQL_NO_MEMORY

Former Member — Tue, 20 May 2008 19:30:03 GMT

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

Re: Dump - DBIF_RSQL_NO_MEMORY

Former Member — Tue, 27 May 2008 08:52:05 GMT

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

Re: Dump - DBIF_RSQL_NO_MEMORY

Former Member — Tue, 26 Oct 2010 15:47:19 GMT

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

Re: Dump - DBIF_RSQL_NO_MEMORY

ravi_lanjewar — Wed, 27 Oct 2010 05:00:24 GMT

Hi,

Welcome to SDN, but before posting search in SDN.

Following lilnk will help you.