|
I'd recommend the webcast as well since Joel also uses a number of live
demos to drive home the points. However, if you'd rather just thumb
through his slides, they're available at
http://www.oracleracsig.org/pls/apex/Z?p_url=RAC_SIG.download_my_file?p_file=1002080&p_id=1002080&p_cat=documents_new which is in the documents repository on the RAC SIG website. Dan Norris RAC SIG President P.S. Thanks, Edgar, for the reference to the RAC SIG! Edgar Chupit wrote: -- //www.freelists.org/webpage/oracle-lHi Guang, You can also take a look at very interesting recorder webseminar "Managing sequences in a RAC environment" by Joel Goodman at oracle sig webpage: http://www.oracleracsig.org/pls/apex/f?p=105:206 On slide 11, he explains usual cases when gaps can occur and also, as one of the measures, suggests to use dbms_shared_pool.keep to lock sequence in shared pool. This webinar explains very thoroughly all main details of sequences and other techniques of generating sequence numbers. Definitely worth watching this webinar, even if you think you know enough about sequences. On Fri, Oct 3, 2008 at 5:26 PM, Guang Mei <guangmei@xxxxxxxxx> wrote: |
