Re: shared_pool_size in really old oracle releases

  • From: De DBA <dedba@xxxxxxxxxx>
  • To: hurleyjohnb@xxxxxxxxx
  • Date: Tue, 26 Nov 2013 13:11:30 +1000

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

Other related posts: