Re: Is this serious?

On Tue, 03 Sep 2002 21:18:59 GMT, "Tom" <tomNOSPAM_at_eazyriders.com> wrote:

>
>The shared pool size is
>
>shared_pool_size = 6291456
>
>this database is not massive in size but it does have quite a number of open
>connections. The box had 4gig of memory and currently supports 2 instances.
>What would be an optimum size for the shared pool do you think?
>
>We do run 8.1.7 but this box is one of the older ones and i'm not sure it
>would be worth the upgrade from 8.1.5. On the upgrade note what do people
>recomend on the best upgrade route? Install the newer version and then exp
>out of the old and imp into the new?
>
>A full exp of this database is only about 5gigs so it is not unmanageable.
>Incedently i exp'd the whole instance the other day and actually caused one
>of these errors to occur. Does that give any more clues?
>

A shared pool of about 6M is just ridiculously low. The average shared pool would start at 40 - 80 M
The worth of the upgrade from 8.1.5 is that it will bring you in a supported configuration.
If your database is not badly fragmented there is no need to create a new database, as 8.1.7 is a maintenance release, you can install it safely (provided you do make backups) over 8.1.5

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Sep 03 2002 - 17:35:13 CDT