tag:blogger.com,1999:blog-20612393.post9131775426573553338..comments2009-11-17T09:20:10.948+07:00Comments on Surachart Opun's Blog: V$SGA_RESIZE_OPS.STATUS ERRORSuracharthttp://www.blogger.com/profile/05646896104906516714surachart@gmail.comBlogger2125tag:blogger.com,1999:blog-20612393.post-40786991279172648862009-11-17T09:20:11.104+07:002009-11-17T09:20:11.104+07:00Thank you for your suggestion.
I'll investigate th...Thank you for your suggestion.<br />I'll investigate the problem before increase SGA_TARGET. <br /><br />I think my system still reduces SGA from some pl/sql and some tables...<br /><br />With db_cache_ advice -)<br />COLUMN size_for_estimate FORMAT 999,999,999,999 heading 'Cache Size in MB'<br />COLUMN buffers_for_estimate FORMAT 999,999,999 heading 'Buffers'<br />COLUMNSuracharthttp://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-39055770047287042432009-11-17T04:10:19.209+07:002009-11-17T04:10:19.209+07:00IMHO, It looks like shared pool did not give the n...IMHO, It looks like shared pool did not give the needed memory back for buffer cache to grow. <br /><br />If I were you I would check the load on the system during that period to understand if there was already a demand on shared pool so it couldn't shrink. I would also check v$db_cache_advice to see if buffer cache needs a minumum. <br /><br />According to the sga_target_advice it looks Coskan Gundogarhttp://www.blogger.com/profile/11570869033287689498noreply@blogger.com