Unix/Linux Go Back    


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

Phantom Arrays in PL/SQL

Programming


Closed    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 08-26-2015   -   Original Discussion by mrn6430
mrn6430's Unix or Linux Image
mrn6430 mrn6430 is offline
Registered User
 
Join Date: May 2011
Last Activity: 28 September 2017, 1:14 PM EDT
Location: USA
Posts: 114
Thanks: 23
Thanked 0 Times in 0 Posts
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
Sponsored Links
    #2  
Old Unix and Linux 09-01-2015   -   Original Discussion by mrn6430
mrn6430's Unix or Linux Image
mrn6430 mrn6430 is offline
Registered User
 
Join Date: May 2011
Last Activity: 28 September 2017, 1:14 PM EDT
Location: USA
Posts: 114
Thanks: 23
Thanked 0 Times in 0 Posts
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-16-2015 at 12:33 AM.. Reason: Fix CODE tag.
Sponsored Links
Closed

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Phantom space usage in / keefbaker Red Hat 3 04-16-2014 03:59 PM
SQL Data with Spaces into Arrays mikem22 Shell Programming and Scripting 0 10-19-2007 06:49 AM
w shows phantom user xiko AIX 2 03-10-2007 09:02 PM



All times are GMT -4. The time now is 02:36 PM.