Re: Shared memory problem on Oracle 7.2.2

From: Rich Holoch <holoch_at_ccnet.com>
Date: 1996/01/17
Message-ID: <4dj6p4$40m_at_ccnet2.ccnet.com>#1/1


I have had to set the shared_pool_size as high as 200MB to load a PeopleSoft 5.01 database into Oracle. I had to flush the pool between load scripts that were broken up into smaller pieces. It was a real nightmare, took days, and all but one of 3000+ objects were built just fine.

Every now and then I receive the 4031 during my nightly exports, but recycling the database once a week seems to help.

What a major pain!

Rich Received on Wed Jan 17 1996 - 00:00:00 CET

Original text of this message