Re: 7.3.2 on NT memory problem

 Only a question :

After the shutdown of the database, do you NET STOP ORACLEServiceYourDatabase.
This command unload the Oracle73.exe of the memory.

On my database, we do many sorts and the process Oracle73.exe increase and increase.
The only way i have find, is : shutdown the database and stop all the oracle services.

Take care in the INITsid.ORA file :

SHARED_POOL_SIZE number of bytes
DB_BLOCK_BUFFERS numbers of blocks * DB_BLOCK_SIZE size of a data block SORT_AREA*** : area of PGA for sort data.

John Mason Jr a écrit:

> Hi,
> I have inherited a database running on NT 4 sp3. This database will continue
> to use increasing amounts of memory even while no users are running queries.
> The database is normally shut down each night and a cold backup is done.
> Then an import is done from an export file created on a VAX and some queries
> are run to get any new data from the imported tables. This process hid the
> problem, but I would like to find a solution. Where should I look? I would
> like to be able identify the source of the problem a design flaw, Oracle, or
> NT.
>
> Thanks
> John
Received on Thu Jan 28 1999 - 16:15:27 CST