Re: is this a memory leak in Oracle RDB

Hi ,

                Am sorry for not detailing the problem .

          Am using a procedure in the test.sqlmod file called procedure
set_Trans . This procedures just contains a statement as follows.

The test.sqlmod file looks like this :


------------------------------------------------------------------------------
-- Declaration Section
------------------------------------------------------------------------------
DECLARE TEST$DB ALIAS FOR FILENAME 'F$LIBRARY:F$AUDIT_DATABASE'

-------------------------------------------------------------------------------
-- Procedure Section
-------------------------------------------------------------------------------

PROCEDURE SET_TRANS
        SQLCA;

        SET TRANSACTION READ WRITE RESERVING
                TEST$DB.EVENT FOR SHARED WRITE ;

PROCEDURE COMMIT_DATA
        SQLCA;

        COMMIT;


In the test.c file :


   set_trans(&sqlca); --
        
         I just use this statement once. But i print the value of 'pagfilcnt'
before and after this statement . This value reduces by 7700 units .
Is this an expected behaviour or a memory leak.




Norman Lastovica <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> It isn't clear to me what your problem might be.  I would
> suggest that you get in touch directly with Oracle Rdb
> support.  You will want to be prepared to provide them
> with a reproducable example of your problem.
> 
> GG wrote:
> > 
> > Hi All,
> >         We are using Oracle RDB so long in our product . I'm facing a
> > problem with Oracle RDB . The problem is , am facing a lot of
> > reduction in Remaining page file quota and increase in process page
> > count when i do a "SET TRANSACTION " statement with the options like
> > READ only , WRITE only., WAIT , NOWAIT  etc.. . Our application uses
> > 'C' language and the SQL module file . We had also seen in a sample
> > program which had just the procedure with set transaction statement
> > and a commit, for that particular database and two other databases
> > also . We ran a simple monitor along with this to print the remaining
> > pagefile quota  program for this database we found that because of
> > this single statement in this program there was a reduction of nearly
> > 8000 pagfilcnt . Is this a memory leak problem ? or are we doing any
> > errors in our program. Kindly can anyone me provide me the guidelines.
> > 
> > Thanks in advance,
> > 
> > Regards,
> > GG