I have not used this feature but there is a note on metalink that you may find useful regarding dynamic SGA issues on Solaris 8.
It is note 151222.1 Scott --- dist cash <[EMAIL PROTECTED]> wrote: > > > > We are doing ORACLE 9.2.0.2 Enterprise Edition > testing on SUN server > (Solaris 8). Currently one problem happen. If I > put "SGA_MAX_size" entry > on init.ora file and restart database, the SUN > server will crash and > following messages on /var/adm/message file: > > > Dec 3 13:34:59 ISS unix: [ID 253085 kern.notice] > NOTICE: hat_memload: unsupported flags 256 > Dec 3 13:35:00 ISS unix: [ID 253085 kern.notice] > NOTICE: hat_memload: unsupported flags 256 > Dec 3 13:35:02 ISS last message repeated 9618 times > Dec 3 13:35:03 ISS unix: [ID 836849 kern.notice] > Dec 3 13:35:03 ISS ^Mpanic[cpu3]/thread=ffba0ac0: > Dec 3 13:35:03 ISS unix: [ID 977504 kern.notice] > invalid shared memory > l1 ptp > Dec 3 13:35:03 ISS unix: [ID 100000 kern.notice] > Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] > e166ba40 > unix:srmmu_share+130 (0, 0, ff61af38, 0, 8, > ff619c20) > Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] > %l0-7: 08000000 > ff61a998 21000000 00000001 ffc77004 ff0982c0 > ffc77484 01629b > 31 > Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] > e166bab0 > genunix:as_dup+dc (0, ffba14a0, ff61a9b4, ffbe2c28, > ffbe2c44, ff61a99 > 8) > Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] > %l0-7: e00e94f0 > ffc8f760 f0a2981c ff385908 e166bb7c ff385908 > 00000000 df13a0 > 00 > Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] > e166bb10 > genunix:cfork+10c (0, 0, ff876768, 1e, 0, 0) > Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] > %l0-7: 40401085 > df119740 df119744 e0060000 00000000 ffba0ac0 > ff577c10 e166bb > 80 > Dec 3 13:35:03 ISS unix: [ID 100000 kern.notice] > Dec 3 13:35:03 ISS genunix: [ID 672855 kern.notice] > syncing file > systems... > Dec 3 13:35:03 ISS genunix: [ID 733762 kern.notice] > 2 > Dec 3 13:35:03 ISS genunix: [ID 733762 kern.notice] > 1 > Dec 3 13:35:03 ISS last message repeated 19 times > Dec 3 13:35:03 ISS genunix: [ID 616637 kern.notice] > cannot sync -- > giving up > Dec 3 13:35:03 ISS genunix: [ID 353387 kern.notice] > dumping to > /dev/dsk/c0t0d0s1, offset 83886080 > Dec 3 13:35:03 ISS genunix: [ID 409368 kern.notice] > ^M100% done: 10698 > pages dumped, compression ratio 2.95, > Dec 3 13:35:03 ISS genunix: [ID 851671 kern.notice] > dump succeeded > > > > If I take out "SGA_MAX_size" entry from init.ora, > the database run > correctly. Does anyone knoe why SUN server crash? > > > Thanks. > > > > > > > _________________________________________________________________ > Add photos to your e-mail with MSN 8. Get 2 months > FREE*. > http://join.msn.com/?page=features/featuredemail > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: dist cash > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).