Re: Changeing database parameters on the fly

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Tue, 29 Mar 2005 18:18:00 GMT
Message-ID: <42499bab.447575259@localhost>

No gotchas.. as long as max_sga_size allows it. You might want to run statspack to see if there are going to be any benefits in increasing.

-A

On 29 Mar 2005 09:37:24 -0800, "Muz" <themuzicman_at_gmail.com> wrote:

>I'm running 9.2.0.4, and I need to increase the db_cache_size. Has
>anyone done it on the fly? Are there any gotchas? Pitfalls? Things
>to watch out for?
>
>I guess I'm looking for anyone with some experience doing this to give
>me a heads up on what to look for.
>
>Muz
>

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Mar 29 2005 - 12:18:00 CST