👤
Home Man
Search
Today's Posts
Register

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 11.2.0.3 to 11.2.0.4 ! 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 ?

Thanks
# 2  
Old 09-01-2015
Oracle provided a fix. That fixed the OCI connection crash by running this alter statement.
Code:
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 11.2.0.4 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 11.2.0.3 which is working fine in 11.2.0.3 Any suggestions what else we can do to get around this issue of memory not clearing in oracle dbms 11.2.0.4?

Last edited by mrn6430; 10-15-2015 at 11:33 PM.. 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 12:12 PM
Phantom Protocol Configuration File Azrael UNIX for Dummies Questions & Answers 4 02-14-2015 11:28 AM
Phantom space usage in / keefbaker Red Hat 3 04-16-2014 02:59 PM
question about int arrays and file pointer arrays omega666 Programming 1 03-16-2011 12:15 AM
SQL Data with Spaces into Arrays mikem22 Shell Programming and Scripting 0 10-19-2007 05:49 AM
w shows phantom user xiko AIX 2 03-10-2007 08:02 PM
I created a phantom file now i can't delete it? Jazmania AIX 9 02-26-2007 09:54 AM
Kill phantom jobs automatically? Cyberface UNIX for Advanced & Expert Users 5 09-19-2001 03:54 AM


All times are GMT -4. The time now is 01:29 AM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
×
UNIX.COM Login
Username:
Password:  
Show Password