Re: shared_pool_size in really old oracle releases

From: De DBA <dedba_at_tpg.com.au>
Date: Tue, 26 Nov 2013 13:11:30 +1000
Message-ID: <52941162.1040303_at_tpg.com.au>

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_size3500000 ) 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-l

Received on Tue Nov 26 2013 - 04:11:30 CET