Re: shared pool

From: Chris Hamilton <ToneCzar_at_erols.com>
Date: Thu, 08 Apr 1999 12:19:26 GMT
Message-ID: <370c9ea0.2583214@news.erols.com>

On Wed, 07 Apr 1999 16:33:25 -0700, Naushi Hussain <Naushi.Hussain_at_Alliedsignal.com> wrote:

>its 7.3.4

Well, the problem may still exist in one form or another. Did you try the flush of the shared pool before the export -- has it worked?

Chris

>
>Chris Hamilton wrote:
>
>> On Tue, 06 Apr 1999 14:37:55 -0700, Naushi Hussain
>> <Naushi.Hussain_at_Alliedsignal.com> wrote:
>>
>> >I get error in donig a full export - not enough memory to allocate ....
>> >
>> >Do I need to increase shared pool and how do I calculate my need. Any
>> >help will be appreciated.
>>
>> Before you begin the export, run the following command in Server
>> Manager:
>>
>> SVRMGR> alter system flush shared_pool;
>>
>> This will flush the shared pool, defragmenting it in the process. The
>> problem you're experiencing is likely due to fragmentation in the
>> shared pool -- too many small chunks of free memory but not enough
>> contiguous space to allocate. This was a problem in 7.0 through 7.2.
>> What version are you running?
>>
>> Chris
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> Chris Hamilton -- toneczar_at_erols.com
>> Oracle DBA -- Wall Street Sports
>> http://www.wallstreetsports.com/

---

Christopher Hamilton
Oracle DBA -- Wall Street Sports
chris_at_wallstreetsports.com
http://www.wallstreetsports.com/ Received on Thu Apr 08 1999 - 07:19:26 CDT