tag:blogger.com,1999:blog-20612393.post7394555888707612851..comments2009-11-18T19:34:25.502+07:00Comments on Surachart Opun's Blog: LOCK_SGA can not use with AMM or ASMMSuracharthttp://www.blogger.com/profile/05646896104906516714surachart@gmail.comBlogger2125tag:blogger.com,1999:blog-20612393.post-59237972685443957142009-11-18T19:34:25.666+07:002009-11-18T19:34:25.666+07:00Thank You..
Nice idea to use C code with shmctl() ...Thank You..<br />Nice idea to use C code with shmctl() - SHM_LOCK, SHM_UNLOCK<br /><br />$ ipcs -m | grep oracle <br />0x8895c820 393227 oracle 660 4096 0 <br /> <br />0x94106560 458764 oracle 660 4096 0 <br /> <br />$ ipcs -m | grep oracle | awk '{print $2'} | while read segment ; do ./fix_in_core $segmentSuracharthttp://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-15908021658255492892009-11-18T17:54:30.793+07:002009-11-18T17:54:30.793+07:00Hey Surachart,
Have a look at my site http://www....Hey Surachart,<br /><br />Have a look at my site http://www.petefinnigan.com/ramblings/lock_sga.htm from a few years ago where I came up with a different solution to locking the SGA in core.<br /><br />cheers<br /><br />PetePete Finniganhttp://www.petefinnigan.comnoreply@blogger.com