Today's Posts

Post questions about C, C++, Java, SQL, and other programming languages here.

Phantom Arrays in PL/SQL


Login to Reply

Thread Tools Search this Thread
# 1  
Old 08-26-2015
Phantom Arrays in PL/SQL

Having issue with an oracle stored procedure that fetches 5k array size to an down stream application using oracle client interface. It is creating phantom arrays and keeps sending arrays that do not exist to begin with and congesting the connections. This happened when we upgraded from oracle to ! The stored procedure uses stored memory for the variables since it is much faster. Any thoughts or experienced something like that before? if so what was done to fix it ?

# 2  
Old 09-01-2015
Oracle provided a fix. That fixed the OCI connection crash by running this alter statement.
alter system set events = '10946 trace name context forever, level 2097152';</SPAN>

It fixed the crash issue. However, arrays being fetched are not clearing now and they keep bouncing back and forth between the stored procedure in form of response and an ack from the oci connection program. When we run the tcpdump to check the packets. The last array fetched is stuck in memory eventhu it was acknowledged ! Somehow in oracle is not compatible with the oci connections when it comes to arrays. The alter statement above is suppose to force the pl/sql to behave as which is working fine in Any suggestions what else we can do to get around this issue of memory not clearing in oracle dbms

Last edited by mrn6430; 10-16-2015 at 12:33 AM.. Reason: Fix CODE tag.
Login to Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Can't access my device DJI Phantom 3 which uses UNIX. Need Help please! nobr3ga Security 5 07-23-2015 01:12 PM
Phantom Protocol Configuration File Azrael UNIX for Dummies Questions & Answers 4 02-14-2015 12:28 PM
Phantom space usage in / keefbaker Red Hat 3 04-16-2014 03:59 PM
question about int arrays and file pointer arrays omega666 Programming 1 03-16-2011 01:15 AM
"Phantom character" in Socket (RESOLVED) trutoman UNIX for Advanced & Expert Users 2 07-10-2009 08:00 AM
w shows phantom user xiko AIX 2 03-10-2007 09:02 PM
I created a phantom file now i can't delete it? Jazmania AIX 9 02-26-2007 10:54 AM
Kill phantom jobs automatically? Cyberface UNIX for Advanced & Expert Users 5 09-19-2001 04:54 AM

All times are GMT -4. The time now is 10:04 PM.

Unix & Linux Forums Content Copyright 1993-2018. All Rights Reserved.
Show Password