| Not enough memory available [message #597917] |
Wed, 09 October 2013 05:11  |
 |
sinpeak
Messages: 59
Registered: January 2011
Location: india
|
Member |
|
|
Hello,
We are invoking the following code from a shell script :
LOADFILE=`sqlplus -S $DATABASE <<-_END
SET SERVEROUTPUT ON SIZE UNLIMITED;
WHENEVER SQLERROR EXIT SQL.SQLCODE;
SET LINESIZE 100;
SET HEADING OFF;
SET FEEDBACK OFF;
SET PAGESIZE 0;
SET TRIMSPOOL ON;
SET NEWPAGE NONE;
SET TERMOUT OFF;
SET ECHO OFF;
SPO $VFileName;
SELECT 'test: TRUE' FROM DUAL;
SELECT 'a: '||CREF_VALUE FROM CREFDATA;
SPO OFF;
EXIT
_END`
When the data in CREFDATA table is huge ( lets say 150K + rows ) , then the shell script returns the following error :
/bin/CR.ksh[423]: 0403-029 There is not enough memory available now.
[genpprod]:/geneva_prog/PR1 $Error 45 initializing SQL*Plus
Internal error
When we try the same test in another other environment setup/server, the shell scripts runs fine.
Please advise as in..what should be done from DBA/Sys Admin point of view on the original environment ( where we are getting the error ) to avoid such an error.
Thanks.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
