Re: Shared pool Memory question.

If you've created 4 databases, you've created four Instances, and I doubt that having four Instances on the one server is a very good idea (the usual advice is one per server!).

I'm also a bit confused why you think Oracle's memory usage should be governed solely by shared_pool_size. You've also got to worry about log_buffer, db_block_buffers, large_pool_size and java_pool_size. Not to mention sort_area_size and the various other xxx_area_size parameters.

Not sure why memory usage would be growing, off-hand. It shouldn't be. 8.1.7.0 ran for months on W2K here without memory leaks, but you could maybe download the 8.1.7.3 patch, and see if that helps (ftp.oracle.com has the patch set, but it's rather large!).

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Gaetan Poitras" <poitrasg_at_crcsogema.com> wrote in message
news:3ebc2be2.0203141236.52268bf6_at_posting.google.com...


> Hello, I install 4 databases 8.1.7 under win 2000 server.

> And I realize the memory usage in my task manager indicate more then I

> specify in my shared pool memory (for all 4 oracle.exe process).

> Also, the memory usage grow and never disallocate the memory after

> used. for all 4 databases after a week that I run I must shutdown and

> restart all the database if I want the memory usage to be

> re-initialized to my normal size.

> What can I do to solve that problem. ??

>

> Thanks.