Cancel package from SGA??
From: Chad A Brockman <chadb_at_sugar.NeoSoft.COM>
Date: 8 Feb 1994 15:54:47 -0600
Message-ID: <2j91n7$mfk_at_sugar.NeoSoft.COM>
Date: 8 Feb 1994 15:54:47 -0600
Message-ID: <2j91n7$mfk_at_sugar.NeoSoft.COM>
How does Oracle7 know when to get rid of a package. If an application calls package after package without disconnecting from the database, seems the database memory would fill up pretty quick... Just curious. Oh, by the way, I'm asking because I'm designing a rather large system using OCI and stored procedures. OK I'm gonna start rambling... Seems to me, if the application unbinds the variables (is there an unbind?? I'm just getting familiar with OCI and stored procs) the SGA memory should be freed. Well, if anyone knows for sure, please let me know...
Chad
-- (-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-)Received on Tue Feb 08 1994 - 22:54:47 CET
) Chad A.Brockman - (
( VertiComp, Inc. - I'm just an OS/2 junkie!! )
) chadb_at_sugar.NeoSoft.com - (