Bad Tuning, need to reset spfile

9i Version 9.2.0.3
Unix-Solaris 8

I did some research before asking but really need some confirmation.

1)I dynamically increased my the following parameters on DB1 with scope=both except for sga, can only scope to spfile.

sga_max_size     -> 2G 
shared_pool_size -> 400M
large_pool_size  -> 400M
db_cache_size    -> 500M

2) Memory errors, I allocated 2Gig of the 4Gig RAM to the SGA. I guess I got greeedy and took too much memory. Obviously I'm a amatuer. Doh!

3) Shutdown DB1 so DB2 & DB3 can still work. Yes, three databases on the same domain sharing the same RAM, not my choice.

4) I want to startup DB1 and reset the params. I'm afraid I might not even have enough memory to finish the first couple of alter system stmts, plus it might cause memory errors again hurting DB2 & DB3.

5) Can I do the pre-9i way and issue a startup pfile=init.ora with the init.ora containing new lower param values? Then dynamically update the params with the old low values so they are written to the spfile too.

Also, should I do a complete startup and OPEN the database or should I do a NOMOUNT?

Thanks in advance!! By the way, is tuning more of an art than a science? Received on Sat Jun 07 2003 - 22:23:39 CEST