Re: is this a memory leak in Oracle RDB

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

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