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

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:

are you sure that you're not simply attaching to the database?

GG wrote:

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 <norman.lastovica (AT) oracle (DOT) com> wrote

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.


Thanks and regards,
GG

Norman Lastovica <norman.lastovica (AT) oracle (DOT) com> wrote

This looks normal.

The first time you start a transaction against a database the program attaches to the database.
This requires some memory, some global and some local, so pagfilcnt should go down.
7700 pages is less that 4 Mbytes.
It seems reasonable, expecially is you are using local buffers.

The memory is not released to VMS at the end of the transaction.
Partly because the program will remain attached, and partly because Rdb releases the memory to an internal
pool which it will reuse.

Peter
Oracle Rdb Support

GG wrote: