[sqr-users] Réf. : Re: [sqr-users] SQR Issue

[Anass.RAZIKI@bnpparibas.com]

I think that is not due to insufficient memory for Oracle because that work
with the same Oracle instance when we launch the program from NT system.

Anass.



Internet
guiman@bellsouth.net@sqrug.org - 21/11/2002 14:10


Veuillez répondre à sqr-users@sqrug.org

Envoyé par :      sqr-users-admin@sqrug.org

Pour : sqr-users

cc :


Objet :     Re: [sqr-users] SQR Issue


Anass, have you reviewed the possibiilty of issuing explicit commits with
the SQR, does your Oracle instance have sufficient memory allocated?


HTH,
Steffon
============================================================
From: Anass.RAZIKI@bnpparibas.com
Date: 2002/11/21 Thu AM 07:05:48 EST
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR Issue

We are running a SQR program on Unix Platform with Oracle RDBMS.
It's an interfacing program to integrate data from foreign sites to
PeopleSoft database, using a flat file input.
After many hours of processing, the program stops with a coredump error
(memory fault). We noticed that the size of the occupied memory in Unix
system grow up to 265M, and the pprogram stops just after.
The same program with the same input file completes execution without
problems in Windows NT system (the process swap memory from hard disk).
I am waiting for any idea: how to force swapping to a process in Unix, or
an easy way to solve this issue, ....

Thanks for your help.

Anass RAZIKI
PeopleSoft Technical Senior Consultant




This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.

                ---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
============================================================


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users






This message and any attachments (the "message") is
intended solely for the addressees and is confidential. 
If you receive this message in error, please delete it and 
immediately notify the sender. Any use not in accord with 
its purpose, any dissemination or disclosure, either whole 
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message. 
BNP PARIBAS (and its subsidiaries) shall (will) not 
therefore be liable for the message if modified. 

                ---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le 
"message") sont etablis a l'intention exclusive de ses 
destinataires et sont confidentiels. Si vous recevez ce 
message par erreur, merci de le detruire et d'en avertir 
immediatement l'expediteur. Toute utilisation de ce 
message non conforme a sa destination, toute diffusion 
ou toute publication, totale ou partielle, est interdite, sauf 
autorisation expresse. L'internet ne permettant pas 
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce 
message, dans l'hypothese ou il aurait ete modifie.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users