Re: shared_pool_size in really old oracle releases
From: Chris Dunscombe <cdunscombe_at_yahoo.com>
Date: Tue, 26 Nov 2013 08:34:29 +0000 (GMT)
Message-ID: <1385454869.62235.YahooMailNeo_at_web28701.mail.ir2.yahoo.com>
Date: Tue, 26 Nov 2013 08:34:29 +0000 (GMT)
Message-ID: <1385454869.62235.YahooMailNeo_at_web28701.mail.ir2.yahoo.com>
Hi,
Yes I remember shared pool's around 30MB being large and many databases with < 10MB. One error we used to get on dev databases was direct path sql loader jobs failing with insufficient space in the shared pool, from memory we had to increase the shared pool to around 9-15MB, sorry can't be more specific.
This was on 7.3.2 on hpux.
Cheers,
Chris
On Tuesday, 26 November 2013, 3:13, De DBA <dedba_at_tpg.com.au> wrote:
I've still got my create scripts hanging around from those days... came in handy last month when I had to recreate a 8.0 database on ancient hardware that had crashed.. ;)
From the 7.3.4 init.ora (1998):
shared_pool_size = 6000000 # small:3.5M medium:6M
large:9M
Cheers,
Tony
On 26/11/13 12:47 PM, John Hurley wrote:
Doing some legwork/research for a presentation. Any people with good memories / funny stories much appreciated.
>
>Found this leftover from the first system I supported in production ... ( was running on hpux ).
>
>Starting up ORACLE RDBMS Version: 7.3.2.1.0.
>System parameters with non-default values:
>
>Later some output shows this value for shared_pool_size ... I was thinking back and guessing that maybe we had a 30 mb shared pool but sure looks like this ( shared_pool_size 3500000 ) was running on 3+ mb ... wow ... was that even possible?
>
>Does anyone have any reliable memories of what common shared pool sizes were back then ( 7.3 days ? ).
>
>Thanks John
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 26 2013 - 09:34:29 CET